Assignment #6

  (80 points)

  1. Read Chapter #6 "Database Administration and the Cloud".

  2. 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.

  3. 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.

  4. Upload both your review questions and modified database to YOUR-CLASS-WEBSITE.  Help

Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Answered the Review Questions at the end of the chapter. (2 points each) 50 0 25 0 __/50
2. Add the data validation rules (listed above) to the database. 30 0 15 30 __/30
Total points __/80