We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>


Looking For Something at vustudents.ning.com? Click Here to Search

Objective:
The assignment has been designed to develop your ability to apply De-Normalization Techniques to normalized data/tables.
Instructions:
Please read the following instructions carefully before solving & submitting assignment:

1. The assignment will not be accepted after due date.
2. Zero marks will be awarded to the assignment that does not open or the file is corrupt.
3. The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
4. Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
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 CS614@vu.edu.pk
Do not post queries related to assignment on MDB.

GOOD LUCK

Question 1 [15 Marks]

The four tables given below are in the normalized form you are required to de-normalize these tables and to combine them to a single table if possible using Collapsing Tables technique.

Renter_ID Name Address Salutation ID
1 Amanat Ali 8th Street plot no 5 1
2 Aleem Ahmed 2nd Street 24 2
3 Aleem Ahmed 8th Avenue 2

Salutation ID Salutation
1 Ms.
2 Mr.

Renter_ID Car_ID
1 1
1 2
2 3
2 4
3 2

Car_ID Car Category
1 Mehran 1000cc
2 Coure 1000cc
3 Corolla 1600cc
4 Civic 1600cc

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 4997

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Attachments:

Replies to This Discussion

yeeee thk haaa imran bahii yaaa M.tariq malik wala tablee thj haa

Muhammad Bilal mere hisab se tou yeh wala thek he. Baki aap dekh len jo aap ko zayada logical lagay, aap waisy he kr len.

mery khyal sy ap wala thk haa solution bcz k id ho gii to pta chly gaa naa to sir ka ha wo dirct car show kar reha haa naa k uski id yaa etc kuch b nehi kar reha ........................................

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

ufff tooo mch easy assignment don't know why students are unable to solve 

solution for cs614..  

cs614 is opposite of cs403 4th assignment of spring2015,...

Attachments:

thanks Dr. sb

Renter ID

Name

Address

Salutation ID

Salutation

Car ID

Car

Category

1

Amanat Ali

8th Street plot no 5

1

Ms.

1

Mehran

1000 cc

1

Amanat Ali

8th Street plot no 5

1

Ms.

2

Coure

1000 cc

2

Aleem Ahmed

2nd Street 24

2

Mr.

3

Corrola

1600 cc

2

Aleem Ahmed

2nd Street 24

2

Mr.

4

Civic

1600 cc

3

Aleem Ahmed

8th Avenue

2

Mr.

2

Coure

1000 cc

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Collapsing Tables
One of the most common and safe denormalization techniques is combining of One-to-
One relationships. This situation occurs when for each row of entity A, there is only one
related row in entity B. While the key attributes for the entities may or may not be the
same, their equal participation in a relationship indicates that they can be treated as a
single unit. For example, if users frequently need to see COLA, COLB, and COLC
together and the data from the two tables are in a One-to-One relationship, the solution is
to collapse the two tables into one. For example, SID and gender in one table, and SID
and degree in the other table.
In general, collapsing tables in One-to-One relationship has fewer drawbacks than others.
There are several advantages of this technique, some of the obvious ones being reduced
storage space, reduced amount of time for data update, some of the other not so apparent
advantages are reduced number of foreign keys on tables, reduced number of indexes
(since most indexes are created based on primary/foreign keys). Furthermore, combining
the columns does not change the business view, but does decrease access time by having
fewer physical objects and reducing overhead.

table 1 and table 2 mi rows same nahi hain rows kesy adjust hongi in demoralization algorithm ????? different rows are confusing ......

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service