Understanding of the key concepts of database relationships

Assignment Help Other Subject
Reference no: EM133671195 , Length: word count:1500

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.

This assessment aims to achieve the following subject learning outcomes:

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.
Please refer to the assessment marking guide to assist you in completing all the assessment criteria.

Reference no: EM133671195

Questions Cloud

Researchers have been studying green anacondas : Researchers have been studying green anacondas (Eunectes murinus) in South America for the past two decades
Explain steiners significant supporting claims : Explain Steiner's significant supporting claims. Explain each in detail, give examples, illustrate your interpretation with one or more quotations.
Describe service lifecycle for a company : TECH2300 Service and Operations Management in IT Perform a SWOT & Porter's Five Forces analysis on a company. Describe service lifecycle for a company
What blood types are possible in their children : If a person with type AB blood marries a person with type O blood, what blood types are possible in their children?
Understanding of the key concepts of database relationships : Relational database as part of their operations. This could be a business, government agency, non-profit organization, or other type of entity
Patient with poorly controlled blood sugar levels experience : A 50 year old diabetic patient with poorly controlled blood sugar levels experiences a decline in kidney function.
Discuss the characterization of the main characters : Discuss the characterization of the main characters. How do their personalities contribute to overall narrative? How performers bring the characters to life.
Which are deep fried collections of corn kernels : An elderly man chokes on corn nuggets which are deep fried collections of corn kernels. He did not realize they contained small pieces of corn
Identify the fad diet : Read the descriptions and identify the fad diet it applies to. Developed by a Japanese philosopher, George Ohsawa, in the 1920s to avoid food containing

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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