Question: I'm lost on this, any help would be appreciated. Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign
I'm lost on this, any help would be appreciated.
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, position, and a number. Each soccer team has a team name and the date the team was started.
2. Each course has several 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).
3. A social media company has many members and wants to track how many of its members have seen certain ads. A customer has a name and a memberID and an ad has a description and an adID. A member may block ads (and not see any) or may see many. Similarly, an ad may be seen by many members.
4. A dentist may examine many patients at an office or clinic. A patient may see many different dentists, but typically only sees one. The system needs to track the dentist name, age, and number of years since receiving a license to practice. A patient has a name, address, age, phone number and one or many treatment descriptions.
5. A student may be part of several organizations. Each organization has many volunteers. A volunteer has a first name, last name, address, email, and phone number. Organizations provide a name, purpose, meeting place, and track the number of volunteers.
6. Sensing new opportunity, an OU student started a company that sells custom jewelry. Each piece of jewelry is original and custom made. The owner wants to create her own database to track each piece of jewelry she creates and who she sells if to. Although she plans to expand, for now, the owner only needs to keep track of each jewelry pieces description, type of anchor stone, weight and quality of the anchor stone, type of metal, weight and quality of metal, total weight, and total cost. The business owner also keeps track her customers and records the customer name, address, phone, email. When she sells a piece of jewelry, she creates an order with an order date and delivery date. Create the entity-relationship diagram (ERD) that captures all of the data the business owner needs.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
