Er diagram of the normalised relations

Assignment Help Basic Computer Science

Reference no: EM13935001

You are required to perform the process of normalising the data shown in Appendix A and B to first (1NF), second (2NF) and third (3NF). Ensure you clearly outline the process you went through to create the database in 3NF and identity the appropriate primary and foreign keys.

Activity

1: Put data in First Normal Form: Remove Repeating Elements or Groups of Elements in Data Activity

2: Put data in Second Normal Form: Remove Partial Dependencies on a Concatenated Key in Data Activity

3: Put data in Third Normal Form: Remove Dependencies on Non-Key Attributes / Final Database Design Activity

4: Create an ER diagram of the normalised relations derived from activities 1 to 3. Show the attributes for each entity, identifier attribute(s) and the correct relationships that exist between the entities taking care to show the correct relationship cardinalities. Evidence You should provide a report section that contains diagrams and brief written explanations providing evidence on the normalisation process for each normal form (1st, 2nd and 3rd ) was applied to the table in Appendix B. For activity 4 you also need to produce an ER diagram showing your normalised entities.

Reference no: EM13935001

Questions Cloud

Add a label control to the form : add a Label control that shows the path to the file being processed.add a Label control that shows the path to the file being processed.

Wha primary difference between passive and active transport : Imagine that you are a pediatrician and one of your patients is a newborn who may have a lysosomal storage disease. You remove some cells from the patient and examine them under the microscope. What would you expect to see? Design a series of test..

Develop a system that is both more responsive to clients : Develop a system that is both more responsive to clients and helpful to technicians. He would like to see a system that allows clients to directly enter their service requests.

What were some of the causes of sectionalism : Besides the Missouri Compromise, what were some of the causes of sectionalism in this early period? What were the different proposals and political maneuvers that eventually led to the Missouri Compromise? What was the final outcome

Er diagram of the normalised relations : You are required to perform the process of normalising the data shown in Appendix A and B to first (1NF), second (2NF) and third (3NF). Ensure you clearly outline the process you went through to create the database in 3NF and identity the appropri..

Use visual interdev as an editing tool to create the app : Use Visual InterDev as an editing tool to create the application. Visual InterDev is available as part of the MSDN.

Determine the version by launching each application : determine the version by launching each application,Be sure to list your installed version for all of these required applications:

How the organisation will implement total quality management : You are required to write a 3000 word short report to the owner of the business that describes how the organisation will implement Total Quality Management.

List the common interface feature : List the common interface features seen in this applications versions of each of the following office applications installed on a computer. List installed version for all of these required applications:

User Account

All Pages