Assignment No. 04
Semester Fall 2011
Database Management Systems-CS403
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)
Semester Fall 2011
Database Management Systems-CS403
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)
0300-9520262
Get solution in 24 hour |cpmputer & internet
mileys81:[SIZE="4"][SIZE="3"]....[/SIZE][/SIZE]