Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help creating this ERD diagram using the following excel sheet and information provided The ZegMart Data worksheet. ZegMart has 5 regions and 10

i need help creating this ERD diagram using the following excel sheet and information provided
image text in transcribed
image text in transcribed
The ZegMart Data worksheet. ZegMart has 5 regions and 10 stores located throughout various regions. Each store has employees assigned, and each employee has a specific job description. The ZegMart Data worksheet shows the current data. The data sheet at the bottom shows an example of regions, stores, employees and positions. The number of regions and stores, employees and positions and their data are irrelevant. They are just included to show an example. The business rules and tasks follow. Business Rules - A Region can have many Stores, but a Store is in only one Region. A Region can have no Stores, such as a new Region before a new store is built. - A Store can have many Employees but an Employee can work in only one Store. A Store can have no Employees, such as when a new store is being built. - A Job can be assigned to many Employees, but an Employee has only one Job. A new job can be created even when no employee holds it, such as the case when the job is newly created and has not yet been assigned to an employee. Tasks - View the ZegMart Data worksheet. - Identify the various entities. - Identify Weak entities (those that can't exist without the parent tables PK as an FK). - Assign relevant attributes to each entity from those shown in the worksheet. - Assign a unique attribute (PK) to each entity. - Assign other attributes as follows; one additional composite attribute for a Region one additional composite attribute to Store one additional multivalued attribute and one derived attribute for Employee Make employee name a composite attribute. one additional attribute of any kind to Job - Determine the relationship(s) among entities (parents and children); 1:1,1:M, M:N - Determine the participation between related entities; mandatory versus optional. - Construct the complete ERD of entities and attributes reflecting primary keys, attributes, as well as relationships and participation. The ZegMart Data worksheet. ZegMart has 5 regions and 10 stores located throughout various regions. Each store has employees assigned, and each employee has a specific job description. The ZegMart Data worksheet shows the current data. The data sheet at the bottom shows an example of regions, stores, employees and positions. The number of regions and stores, employees and positions and their data are irrelevant. They are just included to show an example. The business rules and tasks follow. Business Rules - A Region can have many Stores, but a Store is in only one Region. A Region can have no Stores, such as a new Region before a new store is built. - A Store can have many Employees but an Employee can work in only one Store. A Store can have no Employees, such as when a new store is being built. - A Job can be assigned to many Employees, but an Employee has only one Job. A new job can be created even when no employee holds it, such as the case when the job is newly created and has not yet been assigned to an employee. Tasks - View the ZegMart Data worksheet. - Identify the various entities. - Identify Weak entities (those that can't exist without the parent tables PK as an FK). - Assign relevant attributes to each entity from those shown in the worksheet. - Assign a unique attribute (PK) to each entity. - Assign other attributes as follows; one additional composite attribute for a Region one additional composite attribute to Store one additional multivalued attribute and one derived attribute for Employee Make employee name a composite attribute. one additional attribute of any kind to Job - Determine the relationship(s) among entities (parents and children); 1:1,1:M, M:N - Determine the participation between related entities; mandatory versus optional. - Construct the complete ERD of entities and attributes reflecting primary keys, attributes, as well as relationships and participation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

4th Edition

0615231047, 978-0615231044

More Books

Students also viewed these Databases questions