ACC - Fundamentals of auditing and business
ACF - (Accounting And Finance Related)
COM - (Commerce Related)
ECO - (Economics Related)
ECO401 ECO402 ECO403 ECO404
ENG - (English Related)
ENG001 ENG101 ENG201 ENG301 ENG401
ETH201 - Ethics (for Non-Muslims)
ISL201 - Islamic Studies
IT - (Info Tech Related
MIS - (Project And Internship Report)
MIS619 MISI619MIS620 MISI620
PAD - (Public Administration Related)
PAD619 PADI619
PAK301 - Pakistan Studies
PHY - (Physics Related)
PHY101 PHY301
PSC201 - International Relations
SOC - (Socialogy Related)
SOC101 SOC401
STA - (Statistics and Research)
STA301 STA630
URDU - (Urdu Related)
FB Group

APPLY NOW  | SIT (STEP IN SECURITY) | Ghrapical Password | Smart ETL Tool | SMS BLOCKER

Assignment No. 3


Semester Spring 2015
Database Management Systems – CS403


Total Marks: 20


Due Date:  Friday 31st July 2015



The assignment has been designed to develop your ability to create the tables in SQL Server and define the attributes of a relation and implement the constraints. Please carefully see all the highlighted instructions and tasks.


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


  1. 1.      The assignment will not be accepted after due date.
  2. 2.      Zero marks will be awarded to the assignment that does not open or the file is corrupt.
  3. 3.      The assignment file must be an MS Word file format. Assignment will not be accepted in any other format.
  4. 4.      Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
  5. 5.      Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.


For any query about the assignment, contact only at

Do not post queries related to assignment on MDB.





Question 1                                                                                                                              [20 Marks]






Important things to consider before doing this assignment: 



  1. This Assignment is the continuation of second Assignment. Taking in consideration the Entity Relationship Diagram (ERD) of Orchid Textile as given above in Q1


  1. Now you have to complete your next phase of the Database Development Process and write a SQL query in Query Analyzer. In this assignment you will focus only on the tasks given below:



Task Description:


  1. Open the Query Analyzer/SQL Server Management Studio (Helping Tutorial of Query Analyzer/SQL Server Management Studio is available in download section of VULMS for installation).
  2.  Create a new database with the name of your “Student id” like BC15020XXXX.
  3. You are required to transform all entities given in the above ER diagram into tables through SQL query in Query Analyzer.
  4. You have to transform all entity attributes into columns through SQL query in Query Analyzer.
  5. Define appropriate data types of each attribute.
  6. Apply entity integrity constraints by defining primary key, and foreign key of each entity.
  7. You have to insert rows (at least two) in “Employee” table by writing an SQL query in Query Analyzer with one entry containing your VU ID in “ID” column and your Name in “Name” column of the “Employee” table.
  8. Take screenshots of your work (against each SQL query showing the result) and paste these in your solution file (.DOC file). (For taking snapshot please use print screen button (PrtScn) on your keyboard.




All snapshots of SQL Queries with result should be pasted  in your solution file (.DOC file)

Your VU student ID and name entered in the “Employee” table must be clearly shown in a screen shot otherwise your marks will be deducted.




Views: 824

Download Documents

Replies to This Discussion

Advertise Here

 main ne kr li assig

to hamen kon btaye ga....

rubi upload b kr

abi time to aany do bta b du gi or upload b

kr do na yar piz...

rubi sis gandi bachi...


Latest Activity

Excuse updated their profile
Jun 28

ʭIsmail Shahʭ and Nadeem Khn are now friends
Jun 13
Profile IconLaraib Komal and blade2 joined Virtual University Desk
Jun 13
Raja Azam updated their profile
Jun 7
Profile IconIsha Ali, Khalid Ali and Museera joined Virtual University Desk
Jun 6
Profile IconABDUL MAJID MEHBOOB, Huma Mughal, Raja Sajjad and 2 more joined Virtual University Desk
Jun 4

Anam joined ʭIsmail Shahʭ's group
Jun 2
Sonu Mughal joined Nosheen's group
May 29




Top Content Today

© 2018   Created by ʭIsmail Shahʭ.   Powered by

Badges  |  Report an Issue  |  Terms of Service