Investigate and identify data requirements for case study

Assignment Help Database Management System

Reference no: EM133541682

Database Systems

Overview
You are required to investigate and identify data requirements in the given case study.
In doing so, you are required to

(1) develop an Entity Relationship Diagram,
(2) design relational schema (including Unique identifier, relationships and all attributes), and
(3) Derive a physical design from the logical design.

Note: This is an individual assignment carrying 10% of the total mark in this unit. The submission deadline is end of the week of session 5.

Objectives
This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve students' skills to analyze organization database requirements, develop a data model to reflect the organization's business rules. This assessment covers the following LOs.

1. Synthesize user requirements/inputs and analyse the matching data processing needs, demonstrating adaptability to changing circumstances;

2. Develop an enterprise data model that reflects the organization's fundamental business rules; refine the conceptual data model, including all entities, relationships, attributes, and business rules.

3. Derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements; further use of data manipulation language to query, update, and manage a database

1. Understand and investigate requirements.
2. Identify entities and required attributes for each entity.
3. Appropriately select any Unique identifier for each entity.
4. Identify relationship among entities.
5. Develop entity relationship diagram.
6. Derive a physical design and provide enough description of each table, primary keys, and attributes of each entity.

CASE STUDY - Great Ocean Road Rental Company (GORRC)

Task 1

• Investigate and identify data requirements for the given case study.
• Provide (i) a list of required entities and (ii) a list of attributes for each entity identified in (i).
• Identify the Unique identifier for each entity.

Task 2

Develop an Entity-Relationship (ER) data model for the given scenario showing as many as possible the following:
• Entities and unique identifier for each entity.
• Relationships between entity types, including relationship constraints. For each relationship, indicate the degree of constraint such as ‘One to Many', ‘Many to Many' or ‘One to One'.
• Attributes: You are required to identify all necessary attributes. Assign all attributes to entity types and underline all unique identifier attributes.
You may choose any modelling notation. State any necessary assumptions you have made, with the understanding that they do not contradict the given scenario.

Task 3

In this task, you are required to

• Derive a physical design having details of tables, primary key, foreign keys, and brief details about all essential columns of tables.
o Provide detail information like requisite, atomic, type of value, key or non-key and constraint for all data columns of each table.

Attachment:- Database Systems.rar

Reference no: EM133541682

Questions Cloud

What ways did the columbian exchange impact the americas : In what ways did the Columbian Exchange impact the Americas, Europe, and Africa? The Puritans of Massachusetts Bay fled an established church and religious

Western methods of mental health provision : It is a common research finding that western methods of mental health provision do not fit Indigenous communities or people. Another common finding

How did manifest destiny impact european relations with : how did Manifest Destiny impact European relations with Native Americans? Do you think the atrocities of the past should be addressed today?

How does this differ from ftcs expectations under section 5 : How does this differ from FTC's expectations under Section 5? What do you see as issues with a "reasonable" standard when applied to data security practices.

Investigate and identify data requirements for case study : Database Systems - Develop an enterprise data model that reflects the organization's fundamental business rules; refine the conceptual data model

What is the potential social implication : How do they compare to each other? How are they different, and what is the potential social implication?

Discuss the role each plays in quality patient care : Explain the relationship between the three and discuss the role each plays in quality patient care in the scenario.

What are your thoughts on the modern native american : what are your thoughts on the modern Native American boarding schools? Obviously, they were historically horrific. Should we avoid them now? Why or why not?

List one thing you would do for nike and for kelloggs : List one thing you would do for Nike and one thing you would do for Kellogg's to improve their aperture opportunity. Explain why you think this would help.

User Account

All Pages