Assignment No. 04View more random threads:
- CS609 System Programming Assignment No 1 Fall Semester 2012...
- cs403 assignment no 1 spring fall 25 october 2011
- Software Project Management assignment no 1 fall 2011...
- CS506 Web Design and Development Assignment No.3 Solution...
- CS506- Web Design and Development assignment no 1 spring...
- IT430 E-Commerce Assignment No.2 Solution Fall Semester 2012
- cs607 Artificial Intelligence Assignment # 01 Spring 2012
- cs506 Assignment No. 4 solution fall 2010
- CS609-System Programming Assignment No. 3 december fall 2011
- CS403 assignment no 5 fall 2010 solution on 29/01/2011
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.
Sponsored Links
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)
Last edited by Vuhelper; 01-04-2012 at 08:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)