Database Modelling and Information Management

Assignment Task

Task

1. Construct the information model. It is recommended that you use copies of the data dictionary work-sheets available.

a. List all entities on the Entity Data Dictionary worksheet. Record the name, a description and any aliases. The Occurrence column describes how the entity exists in the organisation. List any dependent entities and indicate in the occurrence which entity it depends on.

b. List all relationships on the Relationship Data Dictionary worksheet. Record the name, a description and any aliases. The Occurrence column describes how the relationship exists in the organisation

c. List all relationships and entities on the Relationship-Entity Data Dictionary worksheet. For each participating entity, give the multiplicity (both the participation and cardinality). If the relationship is greater than binary then list other entities on subsequent rows

d. For each identified entity and relationship, list its name and its attributes on the Attributes Data Dictionary worksheet. For all attributes, give a description, an indication of the data type, length and domain, whether it can be NULL (i.e. optional), and if it can be multivalued. If it can be multi-valued then list the range of values

2. Use your answer for (a) to draw up an Entity-Relationship Diagram (ERD). It should be at least A4 size. The important criteria are consistency with part (a), clarity and readability. Entities in the ERD should fully represent the information contained in the data dictionary. That is, include all the attributes and any other necessary information. It should also conform to the Unified Modelling Language specification discussed in lectures and the textbook. Using a different modelling language will result in a grade of Fail with a mark of 1, which allows for resubmission with a maximum mark. Using software that does not use UML is not an excuse.

This IT Computer Science Assignment Help has been solved by our IT Computer Science Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.