|
I am new in database,will love to create a table,using the question below,i have tryed it so many time but still not working for me,will be glad if i get a helpping hand here,thanks.
1. Draw up a list of tables for this database. These tables are to be in third normal form (or BCNF).
For each table, you should indicate its Primary Key, any foreign keys and all nonkey attributes.
2. Specify the SQL commands to implement the set of tables and to create these tables in ORACLE.
3.Create the necessary tables in ORACLE and populate them with data. You should create around 5 subscribers, around 20 books across 3 or 4 categories and approximately 20 loans, some where the book has been returned and some where the book has not yet been returned.
4. Using the ORACLE Application Developer Tools, create a master/detail which shows for each category, the books in that category.
5. Write SQL commands for the following:
(i) The total number loans by each user of the library (including returned and non-returned books);
(ii) The total number of books in each category;
(iii) A list of all books currently on loan, with details of the book, loan and user, ordered by issue date;
[FONT='Times New Roman','serif'](iv) The total number of copies of each book, ordered by category and then by author[/FONT]
[FONT='Times New Roman','serif']In the West Anglia County Library, details of books such as its publisher, author(s) and title are kept. Every book has a unique ISBN number and belongs to a category identified by its dewey decimal code. Every category has a title and a description.
There may be multiple copies of a book, each copy being uniquely identified. Each time a book is issued to a subscriber, we must keep a record of when it was issued and when it was returned. Subscribers have names, titles and genders.
[/FONT]
|
