Question: Design a database for a library system using tucidchart Assignment1, Due Feb 8th at 11-59pm Tables: 1. Books: - Columns: book_id (Primary Keyl, title, author,

 Design a database for a library system using tucidchart Assignment1, Due

Design a database for a library system using tucidchart Assignment1, Due Feb 8th at 11-59pm Tables: 1. Books: - Columns: book_id (Primary Keyl, title, author, ISEN, publication_date, genre, description, copies 2. Members: - Columns: member_id (Primary Keyl, first_name, last_name, email, address, phone_number, membership_start_date 3. Checkouts: - Columns: checkout_id (Primary Keyl, book_id (Foreign Key to Books), member_id (Foreign Key to Members), checkout_date, due_date, return_date 4. Fines: - Columns: fine_id (Primary Key), member_id (foreign Key to Members), checkout_id (Foreign Key to Checkouts), amount, payment_date Relationships: 1. One member can check out many books (1-N) 2. One book can be checked out by many members (1:N) 3. One checkout record is associated with one book and one member (1:1) 4. One member can have many fine records (1:N) 5. One fine record is associated with one checkout record (1:1) Instructions: 1. Create a new Lucidchart document 2. Add the four tables mentioned above 3. Add the primary key and foreign key relationships as described above 4. Use suitable data types for each column 5. Add any additional attributes or entities as required 6. Save and submit the final ERD diagram to D2L dropboi

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!