ER Diagram

1) Construct an ER Diagram for Patient-Doctor-Ward.
2) Construct an ER Diagram for Movie-Actor-Theatre.
3) Construct an ER Diagram Of Inventory Management System.
4) Suppose you are creating a database to help a university keep track of its course offerings. You might have the following entities in your database, since they are distinct items in real life that are related to each other in important ways: course, classroom, professor, and department. In the space below, draw an ER diagram with a box for each of these four entities and arrows between the boxes labeled with the relationships they denote.
5) Construct an ER Diagram for student can be involved in many projects and can work under the instruction of several teachers for any of these projects, and each teacher can instruct many students on any project.
6) The company you work for wants to digitize their time cards. You have been asked to design the database for submitting and approving time cards. Draw the database ER diagram with the following information:
• A timecard should have hours worked and date submitted
• Each timecard is associated with exactly one employee
• Each timecard should have a unique id
• Each timecard has a status: it is either approved, not approved, or pending
• Each employee has a unique id
• Each employee has a name and address.
• Each employee submits a time card every pay period. i.e. In 1 year, they will submit multiple time cards
• Each employee either has direct deposit or physical check as their method of payment
• Each employee is associated with exactly one manager
• Each manager has a unique id and a name
• Each manager is in charge of multiple employees
• Each manager approves time cards for multiple employees
If you feel that you must make some assumptions, please state them clearly so that they are easily understood by the graders. Remember to indicate the key for each entity, as well as the multiplicity of each relationship (e.g. one-to-many) using the appropriate notation.

7) Construct an ER Diagram Of Auction Management System.
8) Construct an ER Diagram for a company Department who sponsors 0 or many project to the employee, which is handle or monitor by employees.
9) Construct an ER Diagram Of Voting System.
10) Construct an ER Diagram for order which is placed to the customer in any location, customer pay the amount after receiving the order.