Assignment #5

  (80 points)

  1. Read Chapter #5 "Database Design".

  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 Art Courses Database. As shown in the video SQL Review (CC) add the following 5 SQL query statements to your database.

    1. Display all courses costing more than $350 from the COURSE table.
    2. Insert a new course into the COURSE table.
    3. Update the firstname of "Jeffrey" to "Jeff" in the CUSTOMER table.
    4. Create a new table called SEMINAR.
    5. Insert a new record into the SEMINAR table.

  4. Upload your review questions and your 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. Successfully created the 5 SQL statements shown in the video and listed above. 30 0 15 30 __/30
Total points __/80