Last revision: 2026-3-21 10:31

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.
Make sure that you watch the video from 3/24 before submission and before asking questions. If you submit something that was explained in the video, I'll ask you to watch the video before resubmission.

Q1: Pizza Pizza Pizza (5 Points)

Below are three pizzas waiting to be inserted into a table that you'll create.

Create the table, choose appropriate data types, type modifiers, and NOT NULL constraints to accommodate the three records.

Add constraints:

	Two Check:
		The price should be reasonable.
		A pizza is either round, Sicilian, or artisanal.

	One Unique:
		A restaurant should not offer the exact pizza twice.

	One Default constraint of your choice.
	
	Don't forget the NOT NULL constraint.

	Don't forget the Primary Key

Execute the three INSERT commands below:

INSERT INTO pizzas (pizza_name, restaurant, location, price, diameter)
VALUES ('The Giambotta', 'Regina Pizzeria', 'Boston North End', 25.99, 10);

INSERT INTO pizzas (pizza_name, restaurant, location, price, length, width)
VALUES ('Original Cheese', 'Galleria Umberto', 'Boston North End', 24.00, 12, 24);

INSERT INTO pizzas (pizza_name, restaurant, location, price, artisanal)
VALUES ('Cannabis Pizza with Psychedelic Mushrooms', 'High Time Pizza', 'Portland Downtown', 20.25, TRUE);

Remark:
The two Boston pizzas are real and famous. A Sicilian pizza is rectangular. For all pizza dimensions, unit is inches.
Oregon is a state where psilocybin mushrooms are now legal. Portland is the capital of Oregon.
An artisanal pizza does not have a fixed shape, much like the flabby clocks in The Persistence of Memory by Salvador Dali.


Q2: Light Petting Zoo (5 Points)

Below is the table of animals in your petting zoo with a few additional columns added from class.

Zoo Table with the following information:

Name of animal.
Species of the animal.
Gender of the animal.
Endangered status.
Birth date of the animal.
Is it a mammal?
Does it live on land or water? (Petting zoos often have dolphins.)

Create table(s) to accommodate above information. Add appropriate constraints. Establish relationship.