Question: Suppose that a Database Administrator creates four accounts ( U 9 1 , U 5 6 , U 4 7 and U 8 2 )

Suppose that a Database Administrator creates four accounts (U91, U56, U47 and U82), and allow U82 to create base relations under a schema called MyStore.
Account U82 creates 4 base relations under MyStore schema as follows:
MyStore DB Schemas
ITEMS(item_id, Name, Price)
ORDERS_ITEMS(order_id, item_id)
ORDERS(order_id, order_date, customer_id)
CUSTOMERS(customer_id, customer_name, customer_email)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!