VUDESK

¤Virtual University Of Pakistan Network¤



Welcome Visitors to VUDESK Family .Join VUDESK For Free to Get more Access to study material and lot of infotainment stuff. Stay Connected!!

VUDESk ALL Subject CODES
Find Your Subject Code , Join Group And You Will Get ALL related Data
ACC - Fundamentals of auditing and business
ACC311ACC501
ACF - (Accounting And Finance Related)
ACF619ACFI619
BNK - (Banking Related)
BNK601BNK603BNK604BNK619BNKI619
BNK620BNKI620
COM - (Commerce Related)
COM619COMI619
CS - (Computer Sciences)
CS001 CS101 CS201 CS301 CS302 CS304 CS401 CS402 CS403 CS408 CS410 CS501 CS502 CS504 CS506 CS507 CS508 CS601 CS602 CS604 CS605 CS606 CS607 CS609 CS610 CS614 CS615 CS619 CS701 CS702 CS703 CS704 CS708 CS709 CS710CS712 CS716 CS718 CS720 CS723
CS724
ECO - (Economics Related)
ECO401 ECO402 ECO403 ECO404
ENG - (English Related)
ENG001 ENG101 ENG201 ENG301 ENG401
ETH201 - Ethics (for Non-Muslims)
ETH201
FIN - (Finance Related
FIN611 FIN621 FIN622 FIN623 FIN624 FIN625 FIN630 FIN619FINI619
HRM - (Human Resources Related)
HRM611 HRM619 HRMI619HRM620 HRM623 HRM624 HRM625 HRM627 HRM628HRM619 HRMI619HRMI620
ISL201 - Islamic Studies
ISL201
IT - (Info Tech Related
IT000IT0001IT430IT619ITI619
MCM - (Mass Media Related
MCM101 MCM301 MCM304 MCM310 MCM311 MCM401 MCM404 MCM411 MCM431 MCM501 MCM511 MCM514 MCM515 MCM516 MCM517 MCM520MCM531 MCM532 MCM601 MCM604 MCM610 MCM619 MCMI619
MGMT - (Management Related)
MGMT510 MGMT611 MGMT623 MGMT625 MGMT627 MGMT628 MGMT629 MGMT630
MGT - (Finance And Management Related)
MGT101 MGT111 MGT201 MGT211 MGT301 MGT401 MGT402 MGT411 MGT501 MGT502 MGT503 MGT504 MGT510 MGT520 MGT601 MGT602 MGT603 MGT604 MGT610 MGT611 MGT613 MGT619 MGTI619MGT620 MGTI620
MIS - (Project And Internship Report)
MIS619 MISI619MIS620 MISI620
MKT - (Marketing Related)
MKT501 MKT530MKT610 MKT611 MKT621 MKT624 MKT625 MKT630 MKT619MKTI619MKT620MKTI620
MTH - (Maths Related)
MTH001 MTH101 MTH202 MTH301 MTH302 MTH401 MTH501 MTH601MTH603
PAD - (Public Administration Related)
PAD619 PADI619
PAK301 - Pakistan Studies
PAK301PAK302
PHY - (Physics Related)
PHY101 PHY301
PSC201 - International Relations
PSC201PSC401
PSY - (Psychology Related)
PSY101 PSY401 PSY402 PSY403 PSY404 PSY405 PSY406 PSY407 PSY408 PSY409 PSY502 PSY504 PSY505 PSY510 PSY511 PSY512 PSY513 PSY514 PSY515 PSY610 PSY619 PSY631 PSY632 PSYI619
SOC - (Socialogy Related)
SOC101 SOC401
STA - (Statistics and Research)
STA301 STA630
URDU - (Urdu Related)
URD101

BS(CS)

Assignment No. 04 Semester Fall 2011 Database Management Systems-CS403

Assignment No. 04
Semester Fall 2011
Database Management Systems-CS403

Total Marks: 20

 

Due Date:

09 – 01 – 2012

 

 

Objective

To understand the SQL Commands to physically create the Database Tables.

 

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit if:

 

  • The assignment is submitted after due date.
  • The submitted assignment does not open or file is corrupt.
  • The assignment is copied (from other student or copy from handouts).
  • The assignment is in the format other than MS Word (doc).
  • Student ID is not mentioned in the assignment File or name of file is other than student ID.

 

For any query about the assignment, contact at cs403@vu.edu.pk

 

GOOD LUCK

 

 

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)                                                                         

 

 

Tags: 04, 2011, Assignment, Database, Fall, Management, No., Semester, Systems-CS403

Views: 72

Replies to This Discussion

Advertise Here


BS(CS)Permalink Reply by Nosheen on January 3, 2012 at 7:25pm

Idea Solution coming soon

Permalink Reply by Yasmeen(S.admin) on January 7, 2012 at 1:23pm

idea 

Download Documents

RSS

Super Active Members 

1 PRINCE ZORRO

PRINCE ZORRO
2 +**♥Ϊηαм ќђαη ♥**+ߢ§ ²

+**♥Ϊηαм ќђαη ♥**+ߢ§ ²
3 +*PŔĨŃČĔŚŚ*+

+*PŔĨŃČĔŚŚ*+
4 SiLeNt MooN(Admin)

SiLeNt MooN(Admin)
5 Duaa

Duaa

*Member OF Week*

1. PRINCE ZORRO

Lahore, Pakistan

Participation Shortcuts

=======================

Popular Social Events

=======================

+ Member of the Day

+ Member of the Week

+ Member of the Month

+ Member of the Year

+ Miss VU

+ Mr VU

+ Gold Members

+ Vote for Miss VU

+ Vote for Mr VU

+ Members Points Table

+ Profile Points Allocation

+ Competition Corner

+ Our Fans Club

+ Certificate Winners

---------------------------------------

௵ Scholars Of Desk

௵ Gold Members

௵ MR VU,S

௵ MISS VU,S

௵ Members Of Month

௵ Team Members

௵ Moderators 

௵  ADMINS

ʭ☀Administration☀ʭ

Senior Admin : Yasmeen

VUDESK Owner : Ismail Shah

DMCA.com

VUDESK GROUPS

© 2013   Created by ʭIsmail Shahʭ.

Badges  |  Report an Issue  |  Terms of Service

-->