Assignment #6
(80 points)
- Read Chapter #6 "Database Administration and the Cloud".
- Answer 25 Review Questions at the end of the chapter.
Your answers must include the page number(s) of where the topic is
introduced in the textbook. To provide you an example, I have
answered the first question in the link above.
- Download the database Clinic.
As shown in the video
Data Validation
(CC)
add the following
data validation rules to this database.
- Limit Gender to either "F" or "M" in the PATIENT table.
- Limit the City to only letters in the PATIENT table.
- Limit the TherNumber in the PATIENT table to values between 0 and 50.
- Ensure that the endDate is more recent than the
startDate in the THERAPIST table.
- Upload both your review questions and modified database to YOUR-CLASS-WEBSITE. Help
|