How they relate to the key concepts of database

Assignment Help Other Subject

Reference no: EM133676405

Database Design and Management

Assessment - Case Study Analysis and Design

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.

Reference no: EM133676405

Questions Cloud

What is the role of a product vision in an agile project : What is the role of a product/project vision in an Agile project? What are some characteristics of a good product/project roadmap?

Describe a systematic process for decision making : Describe a systematic process for decision making, such as identifying the problem, gathering information, generating alternatives.

Romantic movement challenge traditional notions : How did the Romantic movement challenge traditional notions of artistic expression and cultural identity, particularly in the context of political revolutions

Demonstrate importance of preparing business plan : MNGT 323- Demonstrate importance of preparing business plan and conducting feasibility study in organized fashion identifying elements of competitive advantage.

How they relate to the key concepts of database : 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

Describe the cardinal signs of parkinsons disease : Describe the cardinal signs of Parkinson's disease. Know the drugs to treat PD (BALSA acronym), and nursing interventions.

We speak about marriage practices : We speak about marriage practices after the closure of the Council of Trent

What percent of all native americans live in five states : Five States with the Largest American Indian Population: What percent of all Native Americans live in these five states?

Discuss three inaccurate things : Discuss three inaccurate things you learned about America's history during your K-12 years.

User Account

All Pages