Write SQL Commands to Create the following tables along with attributes and Primary/Foreign key constraints. Use the appropriate Data Types for each attribute.
Customer (CID, CName, Address, Phone)
Order (Order-ID, Description, CID)
Product (PID, PName, Price, CAT-ID)
Product-Order (Order-ID, PID)
Invoice (Inv-ID, Description, Total-Amount, Order-ID)
Category (CAT-ID, CATName)
Vendor (VID, Name, Address)
Product-Vendor (PID, VID)
 |
Upload your Solution |