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 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
Get step-by-step solutions from verified subject matter experts
