1. Create a relational schema for the database design shown in the ER diagram. Refine the schema using normalization techniques. All of your relations must be in 3rd Normal Form (3NF) or higher.

2. Create the database tables from your schema using SQL. List a set of CREATE TABLE statements for your database. Any constraints (primary key, foreign key, cardinality constraints, participation constraints) that can be enforced by the database system should be included in your CREATE statements.

netid History occupied Note: lid is lot id (timestamp 1 Person lot name Space (special N Tid Tocation N Vacant Decal lat) long Assigned Note: vacant is true if the spot is currently vacant 1 1 dow can park in Zone From Allowed Time Period Zone zname type to Note: dow== day of week from and to times Note: zname denotes, the type of zone / lot: Staft, Commuter East, Residential North, etc. Guest is the zone used by drivers without a decal