Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

02.(25 points) A library database contains the following information: Library is organized into sections, like Arts, Children, Sciences, and so on. Each section has a

image text in transcribed
02.(25 points) A library database contains the following information: Library is organized into sections, like Arts, Children, Sciences, and so on. Each section has a name, a number, description and is headed by a librarian. .Each book belongs to a section, has a title, authors, ISBN, call number, year and publisher. Each book has several copies For each copy of the book, keep track of the current borrower, the due date and the librarian who charged it out. An author has id, full name, and gender. An author could have written many books. Members of the library have membership number, a driver's license number, an address a phone number and a birthday Members could borrow books and hold books. Librarian has a name, number, phone, ssn, and address. Please draw the ER diagram for this database and convert it into relational model and using SQL to create tables in your database under your mysql account. Please submit 1) (10 points) ER diagram (either on paper or e-file) 2) (15 points) Structures of tables in a script file. (You can either send me your.sql file or run "describe tableName" after you create these tables in your database)

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

Recommended Textbook for

Genetic Databases

Authors: Martin J. Bishop

1st Edition

ISBN: 0121016250, 978-0121016258

More Books

Students also viewed these Databases questions