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

.

+ 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

Dear colleagues,

Your comments regarding the above assignment would be highly appreciated!

Thanks for joining the discussion in advance.

is it ryt answer?????

anyone knws

ya phir hr table ko phly de normalize krna hai then final table banna hai :(

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.

Note: In the above question we have to focus on the underlined word also!

Because as per definition on handout page 44, "the data from the two tables are in a One-to-One relationship, the solution is to collapse the two tables into one"

It seems right as per de-normalization

Now i think you need to normalize only those tables, which are having one-to-one relation and then collapse two tables into one table.

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

  Cs614 Assignment No. 1

                                                                  Graded

Cs614

Solution

 

 

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

 

Assignment No.1

 

                                       

 

                           Cs614

 

                                                                                    

 

 

Question:

Denormalize the Tables;

 

Answer:

 

 

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

 

seems faulty answers
columns do not hav atomic values

De-normalization techniques can be classified into following prevalent strategies for de-normalization which are:

 

1. Collapsing Tables.

- Two entities with a One-to-One relationship.

- Two entities with a Many-to-Many relationship.

2. Pre-joining.

3. Splitting Tables (Horizontal/Vertical Splitting).

4. Adding Redundant Columns (Reference Data).

5. Derived Attributes (Summary, Total, Balance etc).

Attachments:

RSS

Latest Activity

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

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