In: Computer Science
Define the four main types of relational constraints and use the example relational database (Figure 1) to illustrate each of these constraints.
Figure 1
House(MLS, Addr, NumRooms, NumBedRooms, SellID, OfficeID, Price)
Seller(SellID, Name)
PotentialBuyer(BuyID, Name)
REOffice(OffID, Name, Addr, Phone)
Agent(AgID, OffID, Name)
Showing(AgID, MLS, BuyID, Date)