SQL Assessment

Preparation

Create and populate the DVD Rental database on your laptop using its database dump. The database dump contains SQL statements that will restore the database when the file is executed (e.g., by opening the file in pgAdmin’s Query Tool).

Review the schema of the DVD rental database, including its ER diagram, to familiarize yourself with it.

Complete the practice queries to prepare for the assessment.

Download the solution file to complete during the assessment.

Notes

Authorized resources during the assessment are as follows:

• DVD Rental database and corresponding ER diagram
• PostgreSQL and pgAdmin
• PostgreSQL documentation
• Solution file to record your answers
• Comp Sci 364 textbook

Your laptop’s wireless network connection must be turned off during the in-class assessment.

Submission Instructions

When you complete the assessment, do the following:

1. Save your solution file (save frequently throughout the assessment!)
2. Return the assessment to your instructor
3. Request permission from the instructor to enable your laptop’s wireless network connection
4. Upload your solution file to Blackboard

---

« Database Connectivity XML »