question 1

1. (25 pts.) Design the ER diagram for a database to keep information about products. Each product has a description, a price and a supplier. Suppliers have addresses, phone numbers, and names. Each address is made up of a street address, a city, and a zip code. 2. (25 pts.) Design the ER diagram for a university database. You need only show the entity sets and the relationships between. The attributes are not required. This university consists of a number of departments. Each department offers several courses. A number of modules make up each course. Students enroll in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students. 3. (25 pts.) Design an ER diagram for an insurance company. Each employee has an employee number, a name, and a salary. Some of the employees are hired to sell insurance policy. Each policy has a policy number, owner name, insured amount, and name of the beneficiary. 4. (25 pts.) Design an ER diagram for a simple database for the National Hockey League (NHL): The NHL has many teams Each team has a name, a city, a coach, a captain, and a set of players Each player belongs to only one team Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records (each has an id and the injury description) A team captain is also a player A game is played between two teams (referred to as host_team and guest_team) and has a date (such as July 4, 2016) and a score (such as 4 to 2) (Hint: Include a weak entity set in your design