Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Consider the following library management system. The library contains a large collection of books, magazines, and DVDs . Each item ( book ,
Consider the following library management system. The library contains a large collection of books, magazines, and DVDs Each item book magazine, DVD has a unique ID title, publication date, and genre. The library serves many members who are identified by member ID and have a name, address, and phone number.Members can borrow multiple items. Each borrowing record should include a unique transaction ID the date of borrowing, and the date of return. Books and DVDs can be borrowed for a period of up to weeks, while magazines can be borrowed for week.Furthermore, the library employs several staff members, each having a staff ID name, position, and salary. Staff members are responsible for managing the borrowing process and maintaining the librarys inventory.Finally, the library organizes events such as book readings or educational workshops, where each event has a unique event ID name, date, and associated staff member who organizes it aDraw the conceptual schema ie the ER diagram for this application. bShow all the functional dependencies that should hold among the attributes. cDraw the relational schemas for the database that are each in Third Normal Form NF
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started