Answered step by step
Verified Expert Solution
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...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