Question

You are given the following database:

Books $($bid:integer, bname:string, author:string, year:integer,

price:integer$)$

Orders$($cid:integer, bid:integer, quantity:integer$)$

Customers$($cid:integer, cname:string, zipcode:string$)$

The meaning of attributes is as follows:

bid: unique book identifier,

bname: book name,

author: book author,

year: book publication year,

price: book price,

quantity: number of books purchased with an order,

cid: unique customer identifier,

cname: customer name,

zipcode: customer address zipcode.

Solve the following questions according to the entity$-$relationship model:

$($a$)$ Draw the E$/$R diagram for this database, assuming no constraints hold other than what

results from the schema.

$($b$)$ Modify the E$/$R diagram from $($a$)$ to reflect the constraint that each customer must

have at least one order placed.

$($c$)$ Assume that this is a rare bookshop. Modify the diagram from $($a$)$ such that a customer

can place at most one order. please draw the diagram and explain how you do each question. don't give diagram that is already on chegg please give me your answer. I need help.