Identify the key entities with suitable names

Assignment Help Database Management System

Reference no: EM133662112

Data Modelling and Database Development

Entity Relationship Diagram (ERD) Case Study

Assesment Objectives:
This assessment aims to assess students' knowledge about Entity Relationship Diagrams (ERDs) for a business case study and transform the ERD to third normal form (3NF) relations.

Assesment Description:

Case Study:

Bayside Council, Australia, is conducting inspections of the restaurants in the region to maintain the quality of their kitchens. The council has access to information about the proprietors of kitchens along with the kitchens' details. Each proprietor is assigned a unique Proprietor ID (identifier). Additionally, a proprietor has a Family Name, Given Name, Address (Street, City, State, Post Code) and Phone Number. Kitchens are categorized, and for each kitchen, details such as Kitchen ID, Business Name, Address (Street, City, State, Post Code), and Phone Number are maintained.

The council has employed inspectors who carry out these inspections. The system maintains the Names and Phone numbers of the inspectors. Each inspection is scheduled on a specific Date. If any violations of quality standards are detected in a kitchen, they are recorded with a Description, Required action, and a Due date to fix them. Moreover, violations are categorized into different levels, and each level has a Description and Number of days to fix the violation. When a business fixes the violation, the proprietor contacts the council so that the inspector can check on it and update the system with the fixed date.

Draw an ERD for the above case study and include the following requirements:
Identify the key entities with suitable names.
Include their attributes with suitable naming standards and mark the primary keys.
Model the relationships between the entities.
Indicate the related minimum and maximum cardinality constraints for each of the relationships (optional/mandatory one/many).

Describe your ERD in words (in natural language).

Map the ERD into a set of relations and transform each relation to 3NF.

Reference no: EM133662112

Questions Cloud

Making simplistic judgments can be harmful to stakeholders : Making simplistic judgments can be harmful to stakeholders. How are you raising your awareness of implicit bias on a regular basis?

How do you feel about the current demographics : Think about an organization in which you are very familiar with. how do you feel about the current demographics?

Theory of human motivation : A Theory of Human Motivation by Maslow 2. What does this article suggest about human needs?

Transition into new job responsibilities : When considering the individual development of staff and their transition into new job responsibilities,

Identify the key entities with suitable names : MBIS403 Data Modelling and Database Development, Canterbury Institute of Management - Identify the key entities with suitable names. Include their attributes

Merit evaluations and performance-based evaluations : The difference between merit evaluations and performance-based evaluations lies in their focus and application within an organization.

Optimizing the supply chain for particular product : Introduction The previous lesson discussed optimizing the supply chain for a particular product.

Opportunity law protects employees religious rights : Briefly discuss how the Equal Employment Opportunity Law protects employees' religious rights.

Balance in both task and relationship traits : I agree that having a balance in both task and relationship traits will make a most effective leader, because although relationships are important,

User Account

All Pages