1) Using roles, create an ER diagram for a small company using the following words: phone...

    

Transcribed Image Text:

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. 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.