onsider the following set of requirements to maintainaSmartBuy store database: •You should record the store with store ID,store name,and location.There are more than one stores inacity,one store isasupervised store. •Stores sell items.You should record each item as item code,name,and price.Different stores may supply different prices for same item. The database should also maintain customer information.You should record the name,address, and phone number of each customer. An invoice is written forasingle customer,butacustomer can have many invoices.You should record invoice number and the date of an invoice issued. •You should record items of each invoice which describe the items bought by the customer.You should record the quantity of each item.
Consider the following set of requirements to maintainaSmartBuy store
•You should record the store with store ID,store name,and location.There are more than one
stores inacity,one store isasupervised store.
•Stores sell items.You should record each item as item code,name,and price.Different stores
may supply different prices for same item.
The database should also maintain customer information.You should record the name,address,
and phone number of each customer.
An invoice is written forasingle customer,butacustomer can have many invoices.You should
record invoice number and the date of an invoice issued.
•You should record items of each invoice which describe the items bought by the customer.You
should record the quantity of each item.
According to the information above,answer the following questions:
a)Indicate the name of entities,attributes,and relations.You must use uppercase to name your
entities.
b)Draw and then copy and paste the image of the ER-Diagram corresponding to the above case
study.Clearly indicate the names for entities,attributes,and relations.Underline all primary keys
and mention FK next to all foreign key attributes.Note:Kindly Use Draw.io tool to draw ER
Diagram.
c)Clearly indicate participation and cardinalities between entities.
Step by step
Solved in 8 steps with 8 images
