These problems give you a chance to practice writing basic SQL queries using techniques that you have learned, especially from Week 9.
Create a single plaintext file named homework05.sql that contains your queries. You may should use plaintext editor to create and edit your file. SQL code does not contain any Greek letters, subscripts, or non-standard characters.
Use comment 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 homework05.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.