1. Draw the entity–relationship diagram for a company that has departments and employees. In this company, a department must have at least one employee, and company employees may work in only one department. Describe parts of your diagram.
2. Draw the entity–relationship diagram for a grocery store customers and the process of checking out grocery items. Describe parts of your diagram.
3. You work at a warehouse. You gather information on CUSTOMER ORDER, CUSTOMER, ITEM(S) ORDERED, ITEMS SHIPPED, and SALESPERSON. Develop a table for the entity ORDER TRACKING. Decide on the primary keys and/or foreign keys that you want to use for each entity. A database diagram is needed in addressing this question.
4. You are working at a doctor’s office. You gather data on the following entities: PATIENT, PHYSICIAN, PATIENT DIAGNOSIS, and TREATMENT. Create a table for the entity, PATIENT VISIT. Decide on the primary keys and/or foreign keys that you want to use for each entity. You need to develop a database diagram for this question.