Keys in a Database

Assignments

1. .Order Management. Make the following tables.
1. Items Table
   (Item No Primary Key, Item Name, Price)
2. Customers
   (Customer Id Primary Key, Customer Name, Customer Address)
3. Orders Table
   (OrderNo Primary Key, Customer Id references Customers(Customer Id))
4. Order Items Table
   (Item No Primary Key, Item No references Items(Item No), Order No references Orders(Order No))

Contact us for software training, education or development