Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

4. Label problematic uses of language and their remedies

Answered: 1 week ago