Pleae help me answer the RED CIRCLE question

60 THE RELATIONAL MODEL OF DATA !! d) A manufacturer of a processor speed. must also make a lonton with at least as great. . laptop must !e) If a laptop has a larger also have a higher price than the PC. memory than a PC, then the laptop 10 algebra. The xercise 5.2: Express the following constra constraints are based on the relations of the $ constraints in relational algebra, 12s of Exercise 3.2: country, numGuns, bore, displacement) Classes (class, type, counts: Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) 1ating an ex- 1011 may write your constraints either as pression to the empty set. For the data of E to your constraints. aints either as containments or by equating a vercise 4.3, indicate any violation (a) No class of ships may have a S may have guns with larger than 16-inch bore. ns, then their bore must be no laro D) If a class of ships has more than 9 guns, the than 14 inches. C) No class may have more than 2 ships. !d) No country may have both battleship No country may have both battleships and battlecruisers. ip having **) No ship with more than 9 guns may be in a battle with a ship havine fewer than 9 guns that was sunk. ! Exercise 5.3: Suppose R and S are two relations. Let C be the referen. tial integrity constraint that says: whenever R has a tuple with some value U1, U2, ..., vn in particular attributes A1, A2, ..., An, there must be a tuple of S that has the same values v1, v2, ..., 0, in particular attributes B1, B2,...,B. Show how to express constraint C in relational algebra. ! Exercise 5.4: Another algebraic way to express a constraint is E = E. where both Ef and Ea are relational-algebra expressions. Can this form of constraint express more than the two forms we discussed in this section? 6 Summary * Dato Models: A data model is a notation for describing the structure of the data in a database, along with the constraints on that data. The data model also normally provides a notation for describing operations on that data: queries and data modifications. 60 THE RELATIONAL MODEL OF DATA !! d) A manufacturer of a processor speed. must also make a lonton with at least as great. . laptop must !e) If a laptop has a larger also have a higher price than the PC. memory than a PC, then the laptop 10 algebra. The xercise 5.2: Express the following constra constraints are based on the relations of the $ constraints in relational algebra, 12s of Exercise 3.2: country, numGuns, bore, displacement) Classes (class, type, counts: Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) 1ating an ex- 1011 may write your constraints either as pression to the empty set. For the data of E to your constraints. aints either as containments or by equating a vercise 4.3, indicate any violation (a) No class of ships may have a S may have guns with larger than 16-inch bore. ns, then their bore must be no laro D) If a class of ships has more than 9 guns, the than 14 inches. C) No class may have more than 2 ships. !d) No country may have both battleship No country may have both battleships and battlecruisers. ip having **) No ship with more than 9 guns may be in a battle with a ship havine fewer than 9 guns that was sunk. ! Exercise 5.3: Suppose R and S are two relations. Let C be the referen. tial integrity constraint that says: whenever R has a tuple with some value U1, U2, ..., vn in particular attributes A1, A2, ..., An, there must be a tuple of S that has the same values v1, v2, ..., 0, in particular attributes B1, B2,...,B. Show how to express constraint C in relational algebra. ! Exercise 5.4: Another algebraic way to express a constraint is E = E. where both Ef and Ea are relational-algebra expressions. Can this form of constraint express more than the two forms we discussed in this section? 6 Summary * Dato Models: A data model is a notation for describing the structure of the data in a database, along with the constraints on that data. The data model also normally provides a notation for describing operations on that data: queries and data modifications