1. Given the following business rules, create the E-R diagram, incorporating each of the specified relationships:

• A company operates four departments.
• Each department in part (a) employs employees.
• Each of the employees in part b may or may not have one or more dependents.
• Each employee in part (c) may or may not have an employment history.

2. You have a friend who has asked you to design a database in order to keep track of her workout sessions and those of some of her club friends. Each person wants to be able to track the workout sessions they have as well as the various exercises they did during each workout. Prepare an E-R model that could be used to construct a database to track this information

3. Suppose you work for a small service-oriented company and you have been asked to prepare a simple entity-relationship diagram to model the characteristics of currently working employees (full- and part-time) and the positions they occupy within the company. Prepare this model.

4. A large hospital has just hired you to design a technical help desk database application. The hospital has just standardized their complement of network PCs by acquiring 500 Pentium III 400 MHz workstations. Each workstation has an appropriate range of applications software already loaded. The purpose of the helpdesk database is to track the problems that arise (hardware and software), the users who report them, and the person assigned to resolve the problem. The development of this helpdesk and the associated database was proposed to reduce response time, reduce paperwork, centralize problem resolution, and ensure appropriate follow-up. Provide a conceptual design for this database application by creating an entity-relationship diagram.

5. Design a database that tracks employee’s skills. Additionally, track various projects and the skills that are required to perform each project. Finally, the project must be appropriately assigned. Include also the employee’s supervisor, dependents, work history and employee benefits.

6. Farmer Fanny would like you to design a database for her numerous orchards, each of which have many species. However, an individual species exists in only one of her orchards. Over the past few years, she has been collecting information about tree diseases (signs and symptoms, consequences and treatment). Whenever she sees signs of any disease she wants to record the species that is affected, and the outcome that was shown upon treatment. Her regular business is to take orders for varieties of species of fruit throughout the year so that she can send them out when they’re ready. She needs to keep track of these purchases. Prepare an appropriate ER model for Fanny.