MIS602 - Data Modelling and Database Design - Modelling Report

Assignment Task

Summary

This assessment requires you to prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational database management system.

Task

1. Conceptual Data Model Design: A Conceptual Data Model serves as the blueprint for understanding and organizing data, focusing on the overarching structure without diving into database-specific implementations. It outlines business concepts, their interconnections, and the quality of the data tied to these concepts. To ensure a comprehensive and effective conceptual model for this assignment, you must include the following key components.

• Entities: Identify the primary data objects around which you'll be gathering data. These form the foundational building blocks of your model.

• Attributes: While a high-level conceptual model may not delve into the details of individual attributes, this assignment requires that you specify all critical attributes for each entity.

• Relationships: Clearly illustrate how different entities interact with each other. Specify the nature of each relationship, be it one-to-many, many-to-many, or otherwise.

• Cardinality and Multiplicity: Though these aspects may be optional in a rudimentary conceptual model, for the purposes of this assignment, they are mandatory. Include them to depict the quantity and variety of instances in which entities relate to each other.

• Relationship Names: Assign descriptive names to the relationships between entities to add context, ensuring the model can be readily understood by anyone reviewing it.

2. Logical (Relational) Model Design: In this task, you are required to transition from the high-level conceptual design to a more detailed logical or relational model. Your model should adhere to the Third Normal Form (3NF) to eliminate redundancy and improve data integrity. Below are the essential components your logical model should encompass:

• Entities and Attributes: Clearly specify all the fields or attributes for each Entity (table). This should be a detailed extension of what you have identified in the conceptual model.

• Primary Keys: Identify and indicate the primary keys for each table. These keys serve as unique identifiers for the records in your database.

• Foreign Keys: Specify the foreign keys that establish relationships between different tables. These keys are crucial for enforcing referential integrity.

This MIS602 – 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.