|
Am I a Newbie?
Joined: 02 Feb 2007
Posts: 2
|
Hello,
I would like to get help with my assignment because I do understand databases and stuff, but the wording of the assignment is not clear and its not explained well!! please can anyone help me with the diagram cause i drew some of it and i cant seem to comlete it al somehow im stuck   The question is as follows:
The head librarian of the University of Ottawa (UofO) library has asked you to design a database for the library, in order to manage books. The database must enable the librarians to check books in and out and to assess the fines based on late returns. In essence, your database must enable the librarians to manage the book inventory efficiently. For each book, we keep the ISBN, name, the author(s), the date of publication, publishing house, purchase price and category. The librarians must also be able to check which books are on loan and when these books are to be returned. In addition, the librarians want to be able to get a usage summary for all books by category: history, science, music, and so on. Also, we want to be able to record information about the librarians themselves,
e.g. who checked out a book when, and so on. (This is to avoid a situation where a book “disappears” since some-one forgot to scan it and to balance the librarians’ workloads.) Books can be checked in and out by students, professors, research associates such as post doctoral associates, as well as administrative or support staff. Visiting scholars and alumni are also allowed to check books out, but only for a period of 2 months. We keep each person’s name, address, date of birth, phone number, email and student, alumni or employee number. Students have a library card, which is valid for 12 months from date of issue. All staff members also have cards, which are valid for a period of five (5) years. Students or staff members who have left the university, but still owe books, must be “black listed” and the library will try to relocate them.
Question 1: Theory (1 points)
Example the difference between logical and physical data independence, with reference to the UofO library case study described above.
Question 2: ER diagrams (15 points)
Create the Entity Relationship diagram for the UofO library database, using the ER diagram notation as described in Chapter 2 of the text book. Remember to show all your assumptions clearly.
Thanks a lot. |
|
|
