Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started