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: 839

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

Profile Iconjennifer JBS, jenny ebol, Hamza Khaliq and 7 more joined Virtual University Desk
Dec 2
alvin bolo updated their profile
Nov 28
Waqas Ahmad updated their profile
Nov 16
+(✿◠‿◠)ŞƥąŗƘℓe Ƒąiŗɣ(✿◠‿◠)+ updated their profile
Nov 13
Jaun Elia (Ali) promoted Irha Butt's profile
Nov 11
Profile IconSaqlain abbas dogar, Perla Mary, at and 8 more joined Virtual University Desk
Nov 11
+ (Anisa)*BSCS* updated their profile
Sep 23
+ ★ HAMMAD ★ promoted Mehar Eng Shahzad(MCS)'s blog post Top 10 Health Benefits of Brown Rice
Sep 11




© 2018   Created by ʭIsmail Shahʭ.   Powered by

Badges  |  Report an Issue  |  Terms of Service