1. Relational Schema

2. SQL CREATE TABLE Statements

(netid History occupied Note: lid is lot id Person (timestamp date) special lot name) Space N Tid) Tocation N Vacant Decal (lat) Tong Assigned Note: vacant is true if the spot is currently vacant 1 dow can park in Zone from Allowed Time Period zname Zone type to Note: zname. Note: dow== day of week from and to are times denotes the type of zone / lot: Staft, Commuter East, Residential North, etc. Guest is the zone used by drivers without a decal 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. 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 be the database system should be included in your CREATE statements. Section l's relational schema must be in 3rd Normal Form (3NF) or higher. Primary keys and foreign keys must be identified. List your database relational schema in text format: Sailors (sid, sname, age, rating) Boats (bid, bname, color) When (day) Reserves (sid, bid, day) Foreign key to When Foreign key to Boats Foreign key to Sailors (netid History occupied Note: lid is lot id Person (timestamp date) special lot name) Space N Tid) Tocation N Vacant Decal (lat) Tong Assigned Note: vacant is true if the spot is currently vacant 1 dow can park in Zone from Allowed Time Period zname Zone type to Note: zname. Note: dow== day of week from and to are times denotes the type of zone / lot: Staft, Commuter East, Residential North, etc. Guest is the zone used by drivers without a decal 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. 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 be the database system should be included in your CREATE statements. Section l's relational schema must be in 3rd Normal Form (3NF) or higher. Primary keys and foreign keys must be identified. List your database relational schema in text format: Sailors (sid, sname, age, rating) Boats (bid, bname, color) When (day) Reserves (sid, bid, day) Foreign key to When Foreign key to Boats Foreign key to Sailors