1. (25 pts.) Design the ER diagram for a database to keep information about products. Each...

Transcribed Image Text:

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. O 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 4th, 2016) and a score (such as 4 to 2) [Hint: Include a weak entity set in your design] . . . . II ● ● 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. O 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 4th, 2016) and a score (such as 4 to 2) [Hint: Include a weak entity set in your design] . . . . II ● ●

Answer rating: 100% (QA)

1 ER diagram for a product database Product ProductID Description Price SupplierID Supplier Suppli... View the full answer