Requirements:
Using Draw.io and the attached “CN_StartingPoint” Draw.io file as your starting point, create an Entity Relationship Diagram (ie, data model) of the Chateau Noir business, as shown in the case above. Starting from the provided “starting point” diagram, completely and correctly specify all Entities, Relationships and Attributes as described in the lecture and lab materials on Entity Relationship Diagramming. Include all relevant facts from the case into the model, including primary keys, volume estimates, data-types for all fields, descriptive labels on relationships, and italicization of foreign key fields. Ensure that your relationship lines do NOT cross or overlay, as this makes them hard to read. There is no need to create or assume any new business entities or attributes other than those required for the case above. Your final model should have exactly TEN entities and, if printed (not required), should fit on ONE 8.5” x 11” page. NOTE: In the “starting point” diagram, the number of lines with ‘x’s indicates the total number of expected attributes (including all keys). Do NOT re-organize this diagram.
Recommended approach:
A) Produce an interim model, by reviewing the information provided in the Chateau Noir case above, concentrating on entities, primary keys, volumes, relationships and foreign keys. Include all relevant facts. Use good, consistent naming conventions. Label all entities, keys and relationships properly. You do not have to deliver this interim model.
B) Produce a final model by adding attributes to your interim model, taken from the case above. Because this work is BOTTOM-UP, there is a risk that attributes will be added to the “wrong” entities. Use normalization rules to ensure attributes are added to the “best” entities, including the creation of new entities if necessary. Use good naming conventions. Deliver this final model.
Marking Scheme:
Asgn B: DATA MODEL:
• Correct Entities (Well named, identified, volume estimates)
• Correct Relationships (Connected to correct entities, cardinalities (1-M? M-1?) correct, well described)
• Correct Attributes (Each in the correct entity, well named, correct data type, primary keys underlined and foreign keys italicized)
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|
