Demonstrate the concepts of database relationships

Assignment Help Database Management System

Reference no: EM133739882 , Length: word count:1500

Assessment - Case Study Design and Analysis

Your 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.

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 outcome 1: Investigate the use of Relational Database Management Systems in organisations.
Learning outcome 2: 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.

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 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.
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: EM133739882

Questions Cloud

Assumptions not enough information : Cindy is or has been a company employee. Follows from the Assumptions Does Not Follow from the Assumptions Not Enough Information

Company customer acquisition cost by marketing channel : The company's CEO requests that you deliver a data report on the company's customer acquisition cost by marketing channel

Data request for dashboard presenting viewer engagement : A data analyst at a streaming video content company receives a business data request for a dashboard presenting viewer engagement.

Data report on company customer acquisition cost : You are a data analyst working for a small startup company. The company's CEO requests that you deliver a data report on the company's customer acquisition

Demonstrate the concepts of database relationships : Demonstrate the concepts of database relationships, keys, and cardinalities covered in the first three weeks of the subject

Expectations for higher data information access : The demands and expectations for higher data information access, integration, and storage capacity are the initial causes of worry for mobile access

Your behavioral activation plan objective : Your Behavioral Activation Plan Objective: To identify and plan activities that align with your values and contribute to positive emotional experiences.

Develop a python program that calculates an employees income : Develop a Python program that calculates an employees income based on the provided data and includes deductions for income tax and superannuation

How chaos theory applies to your strategic opportunities : how chaos theory applies to your strategic opportunities. A final systems thinking diagram that focuses on strategic project opportunities for your organization

User Account

All Pages