We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

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)                                                                         

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 2081

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Attachments:

Replies to This Discussion

Please Discuss here about this assignment.Thanks

please help each other...............................and give solution if any one have...thanx.

CS403+Assignment#04+Solution

See the attached file please

Attachments:

Assignment No_4

Data Base Management System

Total Marks = 20

Solution:

CREATE TABLE Customer (

CID char (20) primary key,

CName varchar (50),

Address varchar (100),

Phone char (10)

)

*******************************************************************...

CREATE TABLE _Order (

Order_ID char (10) primary key,

_Description varchar (100),

CID char (20) references Customer (CID)

)

****************************************************************************

CREATE TABLE Product (

PID char (10) primary key,

PName varchar (50),

Price real,

Cat_ID char (10) references Category (Cat_ID)

)

*******************************************************************...

CREATE TABLE Product_Order (

Order_ID char (10)

PID char (10)

Primary key (Order_ID, PID)

)

****************************************************************************www.vustudents.ning.com

CREATE TABLE Invoice (

Inv_ID char (10) primary key,

_Description varchar (100),

Total_Amount real

Order_ID char (10) references _Order (Order_ID)

)

****************************************************************************

CREATE TABLE Category (

Cat_ID char (10) primary key,

CatName varchar (50)

) www.vustudents.ning.com

 

****************************************************************************

CREATE TABLE Vendor (

Ven_ID char (10) primary key,

_Name varchar (50),

Address varchar (100)

)

****************************************************************************www.vustudents.ning.com

                                

CREATE TABLE Product_Vendor (

PID char (10),

Ven_ID char (10),

Primary key (PID, Ven_ID)

)

 

sir is it tottally correct so that we amend and submit it....thanx..

But tariq bhai forieng key k liye jo joint lagay ga wo to yahan nahi mention.

sir ya jo brect mn (10) r (50) waera likhy jaty h wo ku likty ha? plz koi samjha day mujy

Fall2011_CS403_4_SOLUTION

See the attached file please

Attachments:

barcket men (10) or (50) is liye likha jata hy hm batay hen k kitny characters tk hm name waghra ya kisi b kisxm ka data enter kr skty hy bt us ki lenth agr 10 d gai hy tou 10 tk e accept kry ga or agr 50 to 50 tk he is sy zada koi character enter nai kia ja skta.

thankx

ok thnxxxxxxx emaan...mujhy yahe lgta tha per confirm ni tha tha

 

Thankx for the solution!

RSS

Today Top Members 

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service