Question

Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)

Attributes :

          Customer

• Cust_ID: key identifier, required, simple, single valued

• Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried

•   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip

• (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)

          Inventory

• Book_ID: Key identifier, required, simple single valued

• Book_Name: Key identifier, required, simple, single-valued

• Genre: required: simple; single valued

• Publication_Date: required; simple; single valued

         

         Transaction

•    Book_ID: Key identifier, required, simple, single valued

• Rental_Date: required, simple, single valued

• Rental cost: required, simple, single valued

• Rental_Date: required, simple, single valued

Answer 1

Customer

• Cust_ID: key identifier, required, simple, single valued

• Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried

•   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip

  Inventory

• Book_ID: Key identifier, required, simple single valued

• Book_Name: Key identifier, required, simple, single-valued

• Genre: required: simple; single valued

• Publication_Date: required; simple; single valued

         

         Transaction

•    Book_ID: Key identifier, required, simple, single valued

• Rental_Date: required, simple, single valued

• Rental cost: required, simple, single valued

• Rental_Date: required, simple, single valued