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. 4 Graded Semester Spring 2015 Database Management Systems – CS403 Total Marks: 15 Due Date: Friday 7th Aug 2015

Assignment No. 4

Graded

Semester Spring 2015
Database Management Systems – CS403

 

Total Marks: 15

 

Due Date:  Friday 7th Aug 2015

 

Objective:

The assignment has been designed to develop your ability to Normalize the un-normalized tables. 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                                                                                                                              [15 Marks]

 

Suppose Rent a car business is being run with a database without any normalization, all information is stored in one table as shown below.

Name

Address

Car Rented

Salutation

Category

Amanat Ali

8th Street plot no 5

Mehran,

Coure

Ms.

1000cc,1000cc

Aleem Ahmed

2nd Street 24

Corolla,

Civic

Mr.

1600cc,1600cc

Aleem Ahmed

8th Avenue

Coure

Mr.

1000cc

 

Now you are required to apply normalization forms 1st Normal Form, 2nd Normal Form and 3rd Normal Form on the above table step by step and write the resultant tables against each normal form stated earlier.

 

 

 

Views: 274

Download Documents

Replies to This Discussion

Advertise Here

Check and enjoy

Download Documents

RSS

Sponsers

VUDESK GROUPS

 

Top Content Today

© 2018   Created by ʭIsmail Shahʭ.   Powered by

Badges  |  Report an Issue  |  Terms of Service