Explain relational database management systems

Assignment Help Database Management System

Reference no: EM133583691

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.

Learning outcome 1: Explain Relational Database Management Systems and their application within organisations.

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: EM133583691

Questions Cloud

How you would diagnose and treat the children : The boys' mothers are worried it might be something terrible. In your SOAP notes, be sure to address questions that you would ask and how you would diagnose

Explain why it is important for allied healthcare profession : List the source that you found which covers the importance of medical terminology related to the human body. Explain why it is important for allied healthcare

How should the company improve the utilities provided : Are some easier to market than others? How should the company improve the utilities provided by its offer to better meet prospective customer needs?

Identify controlling activity or processes you would engage : Identify 3 controlling activities or processes you would engage in to ensure product quality, cost, schedule, and risk run according to plan.

Explain relational database management systems : Explain the design choices you made and how they relate to the key concepts of database relationships and normalisation

Provide a strategy you have learned from the experience : Respond to the post above by offering suggestions of additional resources and strategies for searching, applying, and/or interviewing for positions.

Explain how this research could apply to your capstone : Describe similarities and differences in initiatives presented in the articles. Draw conclusions about the impact of the articles and the findings.

What cognitive function does singer identify as indicator : What cognitive function does Singer identify as the indicator of genuine death? The permanent cessation of conscious experience. The permanent cessation

How often should you pursue continuing education : How often should you pursue continuing education? Mentoring can be exchanged for a certain amount of continuing education units. Why is it so important to "pay

User Account

All Pages