These problems give you a chance to practice writing basic SQL queries using techniques that you have learned, especially from Week 10.
Create a single plaintext file named homework06.sql that contains your queries. You should use plaintext editor to create and edit your file. SQL code does not contain any Greek letters, subscripts, or non-standard characters.
I should be able to read your file into SQLite using the .read command and see the results of your queries.
Use comments and blank lines to identify and separate the answers to the different problems. In SQL...Format your code in a reasonable fashion. You can mimic the style you've seen in class notes: Short commands can appear on a single line. Break longer commands into meaningful phrases across multiple lines. Indentation can help us read subqueries. lines
- Single-line comments begin with -- (two hyphens).
- Multi-line comments begin with /* and end with */ similar to Java and C.
This assignment uses the computer product database from Homework 4. It consists of four relations, with these schema:
Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price)
You may use this file, homework04.db, to test and debug your queries.
By the due time and date, submit your homework06.sql file using the electronic submission system.
Be sure to use the exact name specified for the file you submit! Otherwise, the autograder cannot find and execute your code.
If you need help or have any any questions, please ask promptly.