Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting...

  

Transcribed Image Text:

Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting up a database to record sellers and their products. This requires recording the following information: • For each seller, their name, contact email, and postal address. For each product, its ID, name, price, and number available. Which product is from which seller. Draw an entity-relationship (ER) diagram that represents this information. Make sure to capture the constraints on the relationships involved, and designate appropriate primary keys for the entities. Q2) Convert the following ER Diagram from the current notation to the min-max notation: Vehicle M Owns 1 Person Introduction to Database Systems ER Diagram Worksheet #2 Lecture of Thr 02-12-2021 Q1: Suppose you are given the following requirements for a simple database for national soccer teams: Each team has a name, ID, logo, city, coach, and a set of players. One of the players would serve as a captain of the team. The system should keep track of the start date of the team captain. A player has an ID, name, position, DoB, and nationality. A player belongs to only one team. A game (match) is played between two teams and we should keep track of the results, match date, stadium, and the city. • Draw the ER of the above requirements. • Extract at least one example of the following: 1. Simple attribute 2. 1:1 relationship 3. 1:M relationship 4. M:N relationship. 5. A relationship attribute. 6. An entity type. • Weak entity type. • Identifying entity type. • Partial key Composite key 7. Total participation constraint. 8. Partial participation constraint. Q2: Define and discuss one example of the following: Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting up a database to record sellers and their products. This requires recording the following information: • For each seller, their name, contact email, and postal address. For each product, its ID, name, price, and number available. Which product is from which seller. Draw an entity-relationship (ER) diagram that represents this information. Make sure to capture the constraints on the relationships involved, and designate appropriate primary keys for the entities. Q2) Convert the following ER Diagram from the current notation to the min-max notation: Vehicle M Owns 1 Person Introduction to Database Systems ER Diagram Worksheet #2 Lecture of Thr 02-12-2021 Q1: Suppose you are given the following requirements for a simple database for national soccer teams: Each team has a name, ID, logo, city, coach, and a set of players. One of the players would serve as a captain of the team. The system should keep track of the start date of the team captain. A player has an ID, name, position, DoB, and nationality. A player belongs to only one team. A game (match) is played between two teams and we should keep track of the results, match date, stadium, and the city. • Draw the ER of the above requirements. • Extract at least one example of the following: 1. Simple attribute 2. 1:1 relationship 3. 1:M relationship 4. M:N relationship. 5. A relationship attribute. 6. An entity type. • Weak entity type. • Identifying entity type. • Partial key Composite key 7. Total participation constraint. 8. Partial participation constraint. Q2: Define and discuss one example of the following:

Answer rating: 100% (QA)

Answer QUESTION 2 WEAK ENTITY TYPE In a relational database a weak entity is an entity that cannot be uniquely identified by its attributes alone therefore it must use a foreign key in conjunction wit... View the full answer