Assignment #5
(80 points)
- Read Chapter #5 "Database Design".
- 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 Art Courses Database.
As shown in the video
SQL Review
(CC)
add the following 5 SQL query statements to your database.
- Display all courses costing more than $350 from the COURSE table.
- Insert a new course into the COURSE table.
- Update the firstname of "Jeffrey" to "Jeff" in the CUSTOMER table.
- Create a new table called SEMINAR.
- Insert a new record into the SEMINAR table.
- Upload your review questions and your modified database to YOUR-CLASS-WEBSITE.
Help
|