Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements: a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments. b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees). c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store. Design an ER (or EER) schema diagram for the above requirements. Make sure to specify primary key attributes and partial keys (if any). Also include relationship cardinality ratios (1:1, 1:N, M:N) as well as participation constraints. You must state any assumptions you make if you think that the requirements are not complete. However, your assumptions should be compatible with the given requirements.
Draw ER (or EER) diagram: A conceptual
needed. The following is a summary of the database requirements:
a) The chain has many different stores in various cities and states. Each STORE has unique
StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who
is an employee). Each store is organized into a number of departments.
b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’,
‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager
(who is an employee), and a number of SalesPersons (who are employees).
c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made
up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’,
‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for
a particular store.
Design an ER (or EER) schema diagram for the above requirements. Make sure to specify primary
key attributes and partial keys (if any). Also include relationship cardinality ratios (1:1, 1:N, M:N) as
well as participation constraints. You must state any assumptions you make if you think that the
requirements are not complete. However, your assumptions should be compatible with the given
requirements.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
