ERD Homework For the below two examples, identify the main entities and the related relationships A college runs many courses. A student can enrol on many courses. Each course has one course co-ordinator but may be taught by many lecturers. A car hire firm wants to introduce a computer system in order to keep track of its fleet of cars, its customers and details of car hirings. Each car belongs to a hire price band. A car remains in that price band for the duration of its life. The company would like to know which model of car is the most popular. ERD Exercise 3 Consider the following case study. Analyse the data and produce Conceptual Model using the Entity Relational Model. An estate agent consists of different branches. The staff in each branch collects information about properties for rent. Usually one branch is responsible for a number of properties. Information such as address, rent, and owner should be kept in the DB. The branch usually assigns one individual staff member as the contact person for a particular property. He/she arranges viewing the property with potential tenant. A prospective tenant refers to a particular branch office where he/she may ask to view various properties. Before a tenant is allowed to view any property, he/she has to register with the agency. A tenant is assigned a unique number across all branch offices. The agency also assigns a unique number for each property which is a unique number across all branch offices. The kind of property a prospective tenant is interested in (e.g. flat, house, maximum rent, etc.) is also recorded. The tenant could view one or more properties several times until he/she makes a decision As a policy of the Estate Agency Company, any branch must have on-going business by limiting the minimum number of rented and available properties (i.c. occupied and ready to rent properties). The minimum rented properties should not be less than 100 and the available unoccupied properties should not be less than 40. Any branch could face a closure if it goes below the above figures as it is not making any profit. a. Draw the Crow's Foot ERDs for this company. b. Identify all possible relationships. c. Identify the PK's d. Create the Logical Scheme e. Create the Physical Scheme 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, 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 May 11th 1999) and a conchas 4 to