Figure 6 A relational model of the relationship ReservedBy between the relations BookedAddOn and Client.

B) Convert the relational representation shown in Figure 6 to appropriate SQL Data Definition Language statements to create tables representing the same data requirements.

In the table above the AddOnID is the identifier for each additional item. You can assume that the referenced domains have already been defined in SQL as: AOID, EID, CID and NameString, and that the SQL INTEGER datatype is available.

Relation >> BookedAddon Attributes - AddOnID: AOID primary key - EventID: EID primary key - Quantity: Integer Foreign Keys Name(ReservedBy) Clienti References Client Constraints - 1: Quantity must be between 1 and 20 - 2: Quantity not allowed null> - 3: ClientID not allowed null Relation> Client Attributes - ClientID: CID primary key> - Name: Name String Constraints - 1: Name not allowed null