Construct an entity relationship model

Assignment Help Database Management System

Reference no: EM134032855

Database Design and Management

Assessment - Case Study Design and Analysis

Task

For this assessment, you will construct 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. You may also refer to Database Management DBMS resources for a better understanding of relational database concepts.

Assessment Description

This assessment evaluates your ability to construct an Entity Relationship Model (ERM) for a real-world organisation that uses a relational database based on Crow's Foot notation using MySQL Workbench. Also, it evaluates your understanding of database relationships, keys, cardinalities, and the application of business rules in database design.

Learning outcomes:

LO1: Investigate the use of Relational Database Management Systems in organisations.
LO2: Construct database models.

Assessment Instructions

You are required to complete the following tasks:

Choose a real-world 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.

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.

Construct 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. If you need additional background, you can review PL SQL concepts alongside database modelling techniques.

Provide a detailed, step-by-step explanation of the process you followed to create the ERM diagram, including the screenshot of the diagram during the four major construction steps (listed as the construction steps in item 7 below).

Your report should follow a professional report format. You can refer to resources in the MyKBS academic success centre regarding a professional report format. Click here to learn more about the professional format for this assessment.

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 8) of the necessary business rules for your case study that govern the organisation's operations and data management. 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.
Construction steps: Provide step-by-step details of the ERM construction process and necessary explanation of the steps.
Entities: Initial diagram with entities and descriptions.
Attributes: Updated diagram with attributes.
Relationships: Updated diagram that shows added relationships.
Final ERM: The complete final ERM diagram.

Your report should include at least 4 academic sources to support your arguments. Your ERM should demonstrate your understanding of the key concepts of database relationships, keys, and cardinalities covered in the first three weeks of the course.

Reference no: EM134032855

Questions Cloud

Basis of employment discrimination lawsuit : An employer presents evidence of a legitimate, non-discriminatory reason for the action that formed the basis of an employment discrimination lawsuit.

What are the key phrases mentioned : What can Raian do in the future to prevent this? What are the key phrases mentioned in the case study?

Describe 4 different types of claimsmakers : Identify and describe 4 different types of claimsmakers (people or groups that make claims about social conditions).

Marketing and product development marketing : Marketing and product development marketing and product development drop zone empty. advocacy advocacy drop zone empty.

Construct an entity relationship model : Construct an Entity Relationship Model (ERM) for a real-world case study of an organisation and outline the business rules governing its operations and data

When does a culture become threatening enough to legislate : Do you think countries should try to control which languages and cultures are expressed? When does a culture become threatening enough to legislate against it?

Why might couples seek to live in a single househod : Why might couples seek to live in a single household? Why might intra-household inequalities arise when couples live in a single household?

Do a american women have same access to mental health care : Do a American women have the same access to mental health care? If you think things are different for different groups of women, please explain.

Wha is it about life choices that impacts their homelessness : Using examples from the film discuss how different events in the lives of the film's participants have impacted their homelessness and addiction.

User Account

All Pages