Last revision: 2026-2-26 13:00

Following naming convention taught in lecture.
If your SQL doesn't run, I will pause grading.
If your SQL is not neat, I may pause grading.
Include question number in your text submission. Do not include the original question.

Question 1: Castability (5 max)

Complete the castability chart. To submit, create a table named castability with 7 columns and 7 rows. I explained this question in class Lecture 10 on 2/19. Please re-watch recording.

If you use SELECT to check for castability, please include them in the answer in the text file submission. Writing SELECT is optional, but it's the easiest way to prove castability. Many, if not most, of the entries can be derived from common sense.

Visit https://tufts.pcorp.us/hw/HW1_Addendum.html for the layout of the castability table.


Question 2: Pizza (7 max)

Pizzas. The ubiquitous foodstuff that's perhaps the only one to be internationally known and eaten.

Let's say you're developing a menu for a pizzeria.

1. Create a spreadsheet as I did in class of students, except replace students with pizzas. What columns should be in a spreadsheet listing different kinds of pizzas. Use your imagination, tempered with a healthy dosage of common sense.

I would like to see at least one textual-ish column, at least one integer-ish column, at least one numeric column, and at least one boolean column. Spreadsheets don't have data types; you'll have to pretend they do. Label each column on the first row.

2. Create a table in PostgreSQL named pizzas, with aforementioned columns. Give me the SQL.

3. Data enter at least three pizzas into the spreadsheet, more if you'd like. Use SQL Insert command to add two rows to the pizzas table in PostgreSQL. We should see at least two rows in your table of pizzas. Give me the SQL.

4. Use the Import data feature to add the three or more pizzas from the spreadsheet to the PostgreSQL pizzas table. Now we should see at least five pizzas in the table. No text submission.

5. You should have a displayed price column. Then update this price to already include the meal and beverage tax. Use Massachusetts tax rate of 6.25%. Give me the SQL.

6. Delete one pizza from the menu, only one. Give me the SQL.

7. Add a new columns to indicate if the pizza is gluten free? Give me the SQL.