:wacko: طلب مساعده من الأخوان
اللي عنده خلفيه عن قاعدة بيانات للمكتبه لايبخل علينا
ويجزاه الف خير
والسؤال بالتفصيل
Country Library
A country wishes to create a database to control its local libraries.
Each library has a number of employees, one of whom is designated as the manager of the library and is responsible for supervising employee and the general day-to-day management of the library. Each library stores a number of books and CDs.
A citizen has to become a member of a library before he or she is allowed to borrow any books, but thereafter can borrow books from any country library. Books are stored on shelves and CDs are stored in a number of racks in the center of the library.
Generally, a library stocks a number of copies of each book title and each CD. Details of book publishers are maintained but not CD publishers. To find an item, searches can be performed based on the book/CD title, the author /artist’s name, the category of the book/CD, or the publisher’s name.
_____________________________________________
________________________________________
Project description:
Each student has to work ALONE.
You will be evaluated at the final lab, so if we discover any sheeting, you will take ZERO.
You have to submit a report that include:
Logical design (ER – Relational Schema)
Physical design (Tables)
Populate tables with appropriate data.
Write SQL statements according to your judgment.
Include any references or tools that used, such as tools used to draw ER.
Grading:
According to your report and problem understanding.
There is no limitation of numbers of quires. It will be according to what you understand.