In the following exercises, you will use the data in the Alexamara Marina Group database...

In the following exercises, you will use the data in the Alexamara Marina Group database shown in Figures 1-20 through 1-24. (If you use a computer to complete these exercises, use a copy of the original Alexamara database so your data will not reflect the changes you made in Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. If not, explain how you would use SQL to obtain the desired results. Check with your instructor if you are not certain about which approach to take.

Ensure that the following are foreign keys (that is, specify referential integrity) in the Alexamara database.

a. MarinaNum is a foreign key in the MarinaSlip table.

b. OwnerNum is a foreign key in the MarinaSlip table.

c. CategoryNum is a foreign key in the ServiceRequest table.

d. SlipID is a foreign key in the SerivceRequest table.

Reference: