Using LucidChart, prepare an INITIAL conceptual model (Entity Relationship Diagram)… 1 answer below »

Moodle Part A Submission:

1. Using LucidChart, prepare an INITIAL conceptual model (Entity Relationship Diagram) for

Monash Cabins (MC).

? For this initial conceptual model, include what you see as identifiers (keys) for each

entity only (other attributes are not required) and all relationships.

? Surrogate keys must not be added to this model. Participation and connectivity

for all relationships must be shown on the diagram.

This initial conceptual model must be submitted to Moodle as Assignment 1 Part A

by 5 PM Monday of week 6. If this submission is not made by this date you will not be

able to submit Assignment 1 Part B.

No marks are awarded for this submission, your tutor will provide feedback and guidance

based on your submitted initial model which should be integrated into your continuing work

in Part B (which is graded).

Moodle Part B Submission:

2. Perform normalisation to 3NF for the data depicted in the sample Cleaning Running Sheet

(Document A) and the sample Contract History (Documents B and C – note that documents

B and C are two samples of the same document).

During normalisation, you must:

? Not add surrogate keys to the normalisation.

? You should include all attributes (not remove any attribute as derivable)

? Clearly show UNF, 1NF, 2NF and 3NF.

? Clearly identify the Primary Key in all relations.

? Clearly identify the partial and transitive dependencies (if they exist) in all 1NF

relations. You may use a dependency diagram or alternative notation (see the

normalisation tutorial sample solution for a possible alternative representation).

Your attribute names as used in your normalisation and those on your conceptual/logical

models must be consistent i.e. the same name used on each for the same property.

3. Using LucidChart, prepare a FULL conceptual model (Entity Relationship Diagram) for

Monash Cabins (MC).

? For this FULL conceptual model, include what you see as identifiers (keys) for each

entity, all required attributes and all relationships. This full model will be based on

your feedback from your Part A submission, the normalisation above and further

reading of the case study. It may be necessary to revise/update this model while

developing your logical model in part 4 below.

? Surrogate keys must not be added to this model. Participation and connectivity

for all relationships must be shown on the diagram.

Page 4 of 8

4. Based on the final full version of your conceptual model, prepare a logical level design for

the Monash Cabins 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 entities depicted must be in 3NF

? All attributes must be commented in the database.

? Sequences must be used to generate numeric primary keys and check clauses

must be applied to attributes where appropriate.

? Be sure to include the legend as part of your model.

5. 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 script includes drop table and sequence statements at the start of the

script.

? Name the schema file as mc_schema.sql.

Looking for a similar assignment? Get help from our qualified experts!

"Our Prices Start at $9.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Order a Similar Paper Order a Different Paper