Reference no: EM133904802 , Length: word count:1500
Database Design and Management
Task
For this assessment, you will describe an Entity Relationship Model (ERM) for a real-world case study of an organisation and outline the business rules governing its operations and data management. Additionally, this assessment will allow you to demonstrate the concepts of database relationships, keys, and cardinalities covered in the first three weeks of the subject.
Assessment Description
This assessment evaluates your ability to describe an Entity Relationship Model (ERM) for a real- world organisation that uses a relational database based on Crow's Foot notation using MySQL Workbench. It also evaluates your understanding of database relationships, keys, cardinalities, and the application of business rules in database design.
Learning outcome 1: Explain the use of Relational Database Management Systems in organisations.
Learning outcome 2: Describe a database model that demonstrates the association of entities and their relationships.
Assessment Instructions
You are required to complete the following tasks:
Choose an organisation that uses a relational database as part of its operations. This could be a business, government agency, non-profit organisation, or other type of entity. Expert help in every subject - get assignment help with just a click.
Research and identify the business rules that govern the organisation's operations and data management. Additionally, Identify the types of data that are stored in the database, the relationships between the different data sets, and any key terminology or concepts that are relevant to the organisation's use of the database.
Describe an Entity-Relationship Model (ERM) for the organisation's database based on the Crow's Foot notation using MySQL Workbench. The Entity-Relationship Model Diagram (ERM) must be fully labelled and implementable by including all necessary components, such as entities, relationships, cardinalities, and constraints. Each entity should have essential attributes, including primary keys (PKs), foreign keys (FKs), and other necessary attributes.
Your report must include the following sections:
Introduction: Provide a brief overview of the chosen organisation, its operations, and its use of a relational database.
Business Rules: Identify and provide a detailed description of the business rules. You need to identify (at least 6) of the necessary business rules. You must include at least two constraints within the business rules.
Entity Relationship Model Design: Present your ERM design, using appropriate notation and symbols to represent the data relationships and structures. Explain the design choices you made and how they relate to the key concepts of database relationships, keys, and cardinalities.