Question 1) We plan to construct a database for the FAU parking service shstem. The FAU has many parking-lots which can accommodate many vehicles. Each parking-lot has id, name, and location. A parking-lot consists of many parking spaces (or spots) and each parking space (or spots) has a unique number. Every student has School_ID and name. A student can purchase more than one parking-permit. A vehicle has id, brand, and color. A student can own multiple vehicle.
Question 1) We plan to construct a
Each parking-lot has id, name, and location. A parking-lot consists of many parking spaces (or spots) and each parking space (or spots) has a unique number.
Every student has School_ID and name. A student can purchase more than one parking-permit.
A vehicle has id, brand, and color. A student can own multiple vehicle.
Each parking permit has no. and price. A parking-permit allows a vehicle to park in dedicated parking spaces (or spots).
The FAU maintains a time table and uses it to record when a student parks a vehicle at a dedicated parking space (or spot) at a specific time-slot in the time- table.
A time-table has id, date, and hour.
Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Question 2) Write DDL statements to create the tables for the ER diagram of Question1.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
