TASKS 1. Using LucidChart, prior to completing task 2 (the normalisation), prepare an initial conceptual model (Entity Relationship Diagram) for Run Monash (RM). For this initial conceptual model,...

TASKS
1. Using LucidChart, prior to completing task 2 (the normalisation), prepare an initial
conceptual model (Entity Relationship Diagram) for Run Monash (RM). For this initial
conceptual model, only include what you see as identifiers (keys) for each entity , do not
include other attributes at this stage. Surrogate keys must not be added to this model.
Participation and connectivity for all relationships must be shown on the diagram . (10
marks)
2. Perform normalisation to the 3NF for each set of data depicted in Appendix A - E.
Consolidate all the found 3NF relations into a final set of relations.
During normalisation:
a. You must not add surrogate keys to the normalisation.
b. Clearly identify the Primary Key in all relations.
c. Clearly identify the partial and transitive dependencies (if they exist) in all 1NF
relations. You may use a dependency diagram or use your own notation (see the
week 5 sample solution for a possible alternative representation). (30 marks)
3. Using your initial conceptual model and the result from your normalisation, prepare a
logical level design for the RM database. The logical model must be drawn using the
Oracle Data Modeler. The information engineering or Crow’s foot notation must be used in
drawing the model. All attributes must be commen ted in the database. Sequences must
be used to generate primary key and check clauses must be applied to attributes where
appropriate. Be sure to include the legend as part of your model. (50 marks)
4. Generate the schema for the database in Oracle Data Modeler and use the schema to
create the database in your Oracle account. The only edit you are permitted to carry out to
the generated schema file is to add header comment/s containing your details (student
name/id) and drop sequence commands. Capture the output of the schema statements
using the spool command. Ensure your generated script includes drop table statements.
Name the schema file as rm_schema.sql. (10 marks)