Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Lectures On Public Economics

Authors: Anthony B. Atkinson, Joseph E. Stiglitz

1st Edition

0691166412, 978-0691166414

Students also viewed these Databases questions