Consider the following relational database that describes a car racing league. Driver(DriverID, DriverName, City, Bdate, TeamID)...

 

Transcribed Image Text:

Consider the following relational database that describes a car racing league. Driver(DriverID, DriverName, City, Bdate, TeamID) Team(TeamID, TeamName, Team Manager) Race(RaceID, Title, City, Date) Participation(RaceID, TeamID, DriverID, pointsEarned) a) Identify the Domain of each attribute. b) Identify the primary key of each relation. c) Identify the foreign keys and referential integrity constraints. Show them pictorially d) For each relation, do the following operations . Populate the relation with a few sample tuples that violate no schema-based or model-based constraints. Insert at least 3-4 tuples in each table. Give an example of an insertion in the Participation relation that violates the referential integrity constraint. Give an example of an insertion in the Race relation that violates the Entity integrity constraint. e) Give three semantic constraints for the above schema. Consider the following relational database that describes a car racing league. Driver(DriverID, DriverName, City, Bdate, TeamID) Team(TeamID, TeamName, Team Manager) Race(RaceID, Title, City, Date) Participation(RaceID, TeamID, DriverID, pointsEarned) a) Identify the Domain of each attribute. b) Identify the primary key of each relation. c) Identify the foreign keys and referential integrity constraints. Show them pictorially d) For each relation, do the following operations . Populate the relation with a few sample tuples that violate no schema-based or model-based constraints. Insert at least 3-4 tuples in each table. Give an example of an insertion in the Participation relation that violates the referential integrity constraint. Give an example of an insertion in the Race relation that violates the Entity integrity constraint. e) Give three semantic constraints for the above schema.