Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started