SQL ER Diagrams

For the scenario below:

Create an ER diagram, illustrating the entities, their attributes, the relationship among entities, and the cardinalities of the entities

Translate the ER diagram into a set of tables, indicating clearly the attributes of each table, the primary key of each table, and the foreign keys that are used to implement the relationships.

Time Cards

The company wants to digitize their time cards. You are asked to design the database for submitting and approving time cards.

Each timecard should have a unique id, hours worked, date submitted, and status. The status is either approved, not approved, or pending.

Each employee has a unique id, name and address, and method of payment: either direct deposit or physical check.

Each employee submits a time card every pay period (i.e., in 1 year, they will submit multiple time cards).

Each employee is associated with exactly one manager; each manager is in charge of multiple employees.

Each manager has a unique id and a name.

Each manager approves time cards for multiple employees; the manager approves timecards only for which the manager is in charge.