Design an erm for the organisations database

Assignment Help Database Management System

Reference no: EM133669802 , Length: word count:1500

Your Task

This assessment is to be completed individually. In this assessment, you will design an Entity Relationship Model (ERM) for a real-world case study of an organisation that uses a relational database, focusing on the key concepts of database relationships and normalisation.

Assessment Description

This assessment requires you to design an Entity Relationship Model (ERM) for a real-world case study of an organisation that uses a relational database as part of their operations. You will need to focus on the key concepts of database relationships and normalisation covered in the first four weeks of the course. You will need to demonstrate your ability to apply these concepts to a real-world scenario and create an ERM that accurately represents the data relationships and structures of the chosen organization's database.

Assessment Instructions

You are required to complete the following tasks:

Choose an organisation that uses a relational database as part of their operations. This could be a business, government agency, non-profit organization, or other type of entity.

Research the organisation and their use of a relational database. 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.

Design an ERM for the organisation's database, using appropriate notation and symbols to represent the data relationships and structures. Your ERM should demonstrate your understanding of the key concepts of database relationships and normalisation covered in the first four weeks of the course.

Write a report that explains the design choices you made in creating the ERM and how they relate to the key concepts of database relationships and normalisation. Your report should be submitted in Word Document or PDF format and include the following sections:

Introduction: Provide a brief overview of the chosen organisation and their use of a relational database.
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 and normalisation.
Application in the Chosen Organisation: Analyse the organisation's use of a relational database, including the types of data stored, the relationships between data sets, and any key terminology or concepts that are relevant to their use of the database. Discuss how your ERM design reflects and supports the organisation's use of a relational database.
Conclusion: Summarise the key points of your report and provide recommendations for how the organization could improve their use of a relational database. A summary of your design decisions and any limitations of your database design.
The report should be no more than 1500 words and should include at least 8 academic sources to support your arguments. You must use KBS referencing and citation to acknowledge the sources of your information.

Reference no: EM133669802

Questions Cloud

Estimating the needs of health-related groups or communities : Explains the role of the change agent in the process of estimating the needs of health-related groups or communities.

Submit campus improvement plan highlight areas of curriculum : EDL 6200- Submit a Campus Improvement Plan highlighting the areas of Curriculum and Finance showcasing the execution of the SCHOOL IMPROVEMENT experience.

Confidentiality of students learning progress records : How do you ensure the confidentiality of students' learning progress records? You can refer to the Confidentiality Policy and Procedure

Explain the pharmaceutical benefits scheme : Please explain the Pharmaceutical Benefits Scheme - this should include what it is, its purpose and how it operates.

Design an erm for the organisations database : TECH1400 Database Design and Management - Assessment - Case Study Analysis and Design - Design an ERM for the organisation's database, using appropriate

How you would educate the mother in regards to diet : How you would educate the mother in regards to diet, especially since she is breastfeeding?

Differences and similarities between race and ethnicity : What are the differences and similarities between race and ethnicity? How does race affect career choice and career options?

Create a communications plan for hosting a sports event : Create a communications plan for hosting a sports event of your choice. Use bullet points in your response to a timeline to include pre-event communications.

Differences between indian culture and the american culture : Discuss at least three differences between Indian culture and the American culture in health-related topics.

User Account

All Pages