The picture is roughly what the answer should be formatted like!

Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Apply all 4 ERD rules.

1. Soccer teams have many players, but teams cannot exist without players. A player may only play on one team or can be a free agent and not play on any team. Each player has a name and a number. Each soccer team has a team name. (10 points)

2. Sections may require several textbooks (or none at all). A textbook can be used in many sections. A textbook has an ISBN, a title and an author. A section has a term and a course number (CRN). (10 points)

3. A volunteer may be part of several organizations. Each organization has many volunteers. A volunteer has a name, city, state, and phone number. Organizations have an organization name, founders name, and founding year. We want to know the date and length of time individuals volunteer for an organization. (15 points)

4. A therapist may examine many patients at a hospital or clinic. A patient may see many different therapists, but typically only sees one. A therapist has a name, age and where they performed their residency. A patient has a name, age and notes. We want to know the date a therapist sees a patient. (15 points)

5. A ride hailing company may hire several drivers that have a name and age but needs at least one driver. A driver drives a single vehicle with a make and model and often works for many companies at the same time. Vehicles may have several drivers. We want to know the date, time, and number of passengers each time a driver works for a company. (25 points)

6. An OU student has just opened a custom furniture shop. The owner wants to create her own database to track each piece of furniture she sells. Currently, she doesnt plan to sell anything other than tables, chairs, and cabinets and each one is handmade and unique. For now, the owner only needs to keep track of each pieces ID number, main material type (maple, oak, steel), length, height, weight, cost, and price. She only keeps track of the customers first name, last name, address, and email. She also keeps track of an orders date, but calculates the total price of each order from each piece. Create the entity-relationship diagram (ERD) that represents furniture, customers, and orders. (25 points partial credit given)

HW#2-ERD MIS 2113 Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Apply all 4 ERD rules. durality 1. Soccer teams have many players, but teams cannot exist without players. A player may only play on one team or can be a free agent and not play on any team. Each player has a name and a number. Each soccer team has a team name. (10 points) I Playen team IPA Name p/ plager ID IR Team ID for has 'Number 11 Team NAME 2. Sections may require several textbooks (or none at all). A textbook can be used in many sections. A textbook has an ISBN, a title and an author. A section has a term and a course number (CRN). (10 points) section Textbook) 3. A volunteer may be part of several organizations. Each organization has many volunteers. A volunteer has a name, city, state, and phone number. Organizations have an organization name, founders name, and founding year. We want to know the date and length of time individuals volunteer for an organization. (15 points) 4. A therapist may examine many patients at a hospital or clinic. A patient may see many different therapists, but typically only sees one. A therapist has a name, age and where they performed the residency. A patient has a name, age and notes. We want to know the date a therapist sees a pati points) HW#2-ERD MIS 2113 Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Apply all 4 ERD rules. durality 1. Soccer teams have many players, but teams cannot exist without players. A player may only play on one team or can be a free agent and not play on any team. Each player has a name and a number. Each soccer team has a team name. (10 points) I Playen team IPA Name p/ plager ID IR Team ID for has 'Number 11 Team NAME 2. Sections may require several textbooks (or none at all). A textbook can be used in many sections. A textbook has an ISBN, a title and an author. A section has a term and a course number (CRN). (10 points) section Textbook) 3. A volunteer may be part of several organizations. Each organization has many volunteers. A volunteer has a name, city, state, and phone number. Organizations have an organization name, founders name, and founding year. We want to know the date and length of time individuals volunteer for an organization. (15 points) 4. A therapist may examine many patients at a hospital or clinic. A patient may see many different therapists, but typically only sees one. A therapist has a name, age and where they performed the residency. A patient has a name, age and notes. We want to know the date a therapist sees a pati points)