Tuesday, 7 May 2013
Question: [Marks 20]
In Task no. 3 of Assignment no. 1, you denormalized all one-to-one and many-to-many relationships; in this assignment you will denormalize all one-to-many relationships by taking into account the same Air Ticket reservation system, in order to optimize it further.
So, de-normalize all one-to-many relationships (left after Task no. 3 in assignment no. 1) using Pre-joining technique.
The pre-joined tables should:
· Contain no redundant columns (matching join criteria columns)
· Contain only those columns absolutely necessary for the application to meet its processing needs
Note:
You need to show the database resulted from the previous assignment (after denormalization) and the resultant database after performing pre-join denormalization in this assignment.
In Task no. 3 of Assignment no. 1, you denormalized all one-to-one and many-to-many relationships; in this assignment you will denormalize all one-to-many relationships by taking into account the same Air Ticket reservation system, in order to optimize it further.
So, de-normalize all one-to-many relationships (left after Task no. 3 in assignment no. 1) using Pre-joining technique.
The pre-joined tables should:
· Contain no redundant columns (matching join criteria columns)
· Contain only those columns absolutely necessary for the application to meet its processing needs
Note:
You need to show the database resulted from the previous assignment (after denormalization) and the resultant database after performing pre-join denormalization in this assignment.
