Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Celling, a large retail company that owns many mails, needs a database to manage the information of all the malls it owns. Your company won
Celling, a large retail company that owns many mails, needs a database to manage the information of all the malls it owns. Your company won the contract to build this database with the following requirements: There can be any number of stores in each mall. The store will have a unique id number, room number and name. All malls must have at least one store. Each store will have one manager. The database should record the name, SSN, salary, and start date of each manager. Each store will have one owner and we have to record the name, SSN, address and phone number of each owner. An owner can own more than one store. The unique name, address, and url of the webpage of each mall should also be recorded. Draw the ER diagram for the Ceiling Company identifying the key attribute for each entity types. The Ceiling company now wants to record additional information on their database: Each store has at least one employee. The SSN, name, and phone number of each employee must be recorded by the database. An employee can work in more than one store. Since all employees are paid hourly, the number of hours each employee worked on each store must also be recorded. Extend the ER diagram into an EER diagram: Include the additional requirements. Generalize the entity types Employee, owner, and manager? Provide the cardinality ratio constraints
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