Question
Based on the narratives, draw the following ERDs. in lucidchart Make sure you have the following components in the ERDs for each diagram. Apply all
Based on the narratives, draw the following ERDs. in lucidchart Make sure you have the following components in the ERDs for each diagram. Apply all 5 ERD rules. entity names verbs that represent the relationship all attributes cardinality primary keys (marked as PK) foreign Keys (marked as FK) associative entity 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.
2
A volunteer may be part of several organizations. Each organization has many volunteers. A volunteer has a city, state, and phone number.
Organizations have number of volunteers, an organization name and a founder.
3
A ride hailing company may hire several drivers that have 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
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.
5
Each course has sections and each section 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).
6
One of the UMB students 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 doesn't 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 piece's ID number, main material type (maple, oak, steel), length, height, weight, cost, and price. She only keeps track of the customer's first name, last name, address, and email. She also keeps track of an order's date, but calculates the total price of each order from each piece. Create the entity-relationship diagram (ERD) that represents furniture, customers, and orders.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started