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

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

Assignment No. 3

Graded

Semester Spring 2015
Database Management Systems – CS403

 

Total Marks: 20

 

Due Date:  Friday 31st July 2015

 

Objective:

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.

Instructions:

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 CS403@vu.edu.pk

Do not post queries related to assignment on MDB.

 

GOOD LUCK

 

 

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.

 

 

Note:

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

fulll file 

Download Documents

Solution...

Download Documents

RSS

Latest Activity

Excuse updated their profile
Jun 28

Founder
ʭ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

BS(CS)
Anam joined ʭIsmail Shahʭ's group
Jun 2
Sonu Mughal joined Nosheen's group
May 29

Sponsers

VUDESK GROUPS

 

Top Content Today

© 2018   Created by ʭIsmail Shahʭ.   Powered by

Badges  |  Report an Issue  |  Terms of Service