Database Implementation
Budget: £20 – £250 GBP
Use Oracle Forms to create a database application. This application is based on the table types, with primary keys underlined and foreign keys in italics.
Design a relational database for the spreadsheet file shown below.
You should assume that the data shown in the spreadsheet is a typical snapshot of data for these records and demonstrates all the enterprise rules which apply, even though some rules may be simpler than those in reality.
Normalise this set of spreadsheet data into Third Normal Form showing the intermediary stages of First and Second Normal Form. Primary keys and foreign keys in all the three forms should be indicated clearly. You are expected to start the normalisation process by first choosing the customer code alone as a primary key. Your normalised tables should only include the attributes shown in the table fragment; do not add any new attribute.
Justify your solution to this problem.
Critically evaluate normalisation as a technique for database design. For each advantage or disadvantage identified, you should use the Product-4-U data to illustrate and explain it. You may extend these data in order to identify suitable examples to illustrate your point, however you should only do so if the current data do not provide for such examples.
The evaluation should not exceed 500 words (excluding the list of references).
References must be listed in the end and cited within your evaluation using a consistent format such as Harvard Refencing.
Learning Outcomes being assessed:
1. Implement a functional relational database, giving consideration to integrity and validation constraints, using ….appropriate database environment.
2. Apply and justify database design techniques for the construction of a conceptual data model.
3. Critically review work with respect to underpinning theories.
Design a relational database for the spreadsheet file shown below.
You should assume that the data shown in the spreadsheet is a typical snapshot of data for these records and demonstrates all the enterprise rules which apply, even though some rules may be simpler than those in reality.
Normalise this set of spreadsheet data into Third Normal Form showing the intermediary stages of First and Second Normal Form. Primary keys and foreign keys in all the three forms should be indicated clearly. You are expected to start the normalisation process by first choosing the customer code alone as a primary key. Your normalised tables should only include the attributes shown in the table fragment; do not add any new attribute.
Justify your solution to this problem.
Critically evaluate normalisation as a technique for database design. For each advantage or disadvantage identified, you should use the Product-4-U data to illustrate and explain it. You may extend these data in order to identify suitable examples to illustrate your point, however you should only do so if the current data do not provide for such examples.
The evaluation should not exceed 500 words (excluding the list of references).
References must be listed in the end and cited within your evaluation using a consistent format such as Harvard Refencing.
Learning Outcomes being assessed:
1. Implement a functional relational database, giving consideration to integrity and validation constraints, using ….appropriate database environment.
2. Apply and justify database design techniques for the construction of a conceptual data model.
3. Critically review work with respect to underpinning theories.