Relational database as part of its operations

Assignment Help Database Management System
Reference no: EM133796203 , Length: word count:1500

Database Design and Management

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.

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. Book your online assignment help today!

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

Questions Cloud

How can you provide care for a patient who does not see : How can you provide care for a patient who does not see or understand that they have a condition that needs to be addressed?
Which finding would be most consistent with this diagnosis : During a physical examination of a patient suspected of having Graves' disease, which finding would be most consistent with this diagnosis?
How to mitigate the effects of homicide : Provide your own insights or perspectives on how to mitigate the effects of homicide and sexual victimization and improve the support systems for victims.
Which is contraindicated for use with bulima patient : She has started psychotherapy and would like to start taking a medication as well. Which is contraindicated for use with bulima patient?
Relational database as part of its operations : Relational database as part of its operations. This could be a business, government agency, non-profit organisation, or other type of entity
Identify the five specific strategies that they discussed : Identify the five specific strategies that they discussed. In this section are the authors introducing original strategies for culturally responsive classroom?
What does it mean to be american : In what ways can someone be an American? Compare and contrast what "being American" might mean to members of different groups living in the U.S.
Which agents would be appropriate : The patient would like to try a pharmacological option. The client has no significant medical history. Which agents would be appropriate?
Which myth about offenders-policies surprised you the most : Which myth about sex crime, offenders, or policies surprised you the most? Also, what research would you find most persuasive for debunking a particular myth?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd