Question: Create a Referential Integrity constraint. Using the class example database (SQLFUN): Create a Referential Integrity constraint between the valid_phone_numbers table and the L_employees table. (This

Create a Referential Integrity constraint.

Using the class example database (SQLFUN):

  • Create a Referential Integrity constraint between the valid_phone_numbers table and the L_employees table. (This validates the phone_number value whenever a new row is added to the L_employees table.)
  • Add one more value to this table: 4707.
  • Create a new table, valid_phone_numbers, containing the phone numbers for all the employees. (Get this list of valid values from the phone_number column of the L_employees table.)

Goal: Use the date functions. Construct and use a table of constants.

  • Find the number of days between December 21, 2020 (winter solstice), and March 21, 2021 (spring equinox).

Put both dates in a table of constants, so they both have a datatype of date.

Starting points:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!