Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Using roles, create an ER diagram for a small company using the following words: phone number, id, name, manages, manager, worker, address, employee


    

1) Using roles, create an ER diagram for a small company using the following words: phone number, id, name, manages, manager, worker, address, employee 2.) Create an ER diagram that describes a retail store operation. Stores are managed by only one Manager and a Manager manages only one store. Employees work in the stores and may work in different stores in a small geographical area. Stores are staffed with many Employees. Employees have timecards that have a startTime and endTime. Timescards are determined by the start Time and the employee SSN. The endTime for the employee and the store id also appear on the timecard, and since the store has many employees, there are many timecards for each store. Each employee receives a payStatement that is determined by datePaid and the employee SSN. payStatements also include the amount paid.

Step by Step Solution

3.42 Rating (168 Votes )

There are 3 Steps involved in it

Step: 1

1 ER Diagram for a Small Company Employee Manager Worker id PK 1 0 id PK 01 0 id PK name name name phonenumber manages FK Worker phonenumber address a... 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_2

Step: 3

blur-text-image_3

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 management systems

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

3rd edition

72465638, 978-0072465631

More Books

Students also viewed these Programming questions