Data Modeling Assignment Scenario $2$

IST$7000$: Data Management

Assignment Title: Parking Lot Management System

Description: Design a database for managing a parking lot. The parking lot has multiple levels,

each with a specific number of parking spaces. Vehicles, both cars, and motorcycles, can be

parked in these spaces. Each vehicle has a license plate, vehicle type, and entry timestamp.

Consider the following requirements:

$$ Parking Lot Levels: Identify the levels in the parking lot. Each level has a unique identifier

and a certain capacity for parking spaces.

$$ Parking Spaces: Define the parking spaces on each level. Each space has a unique number, a

status $($occupied or vacant$),$ and the vehicle parked $($if occupied$).$

$$ Vehicles: Capture information about each vehicle entering the parking lot, including the

license plate, vehicle type $($car or motorcycle$),$ and entry timestamp.

$$ Transactions: Record transactions related to vehicles entering and leaving the parking lot.

Include details such as the entry timestamp, exit timestamp, and the calculated parking fee.

$$ Parking Rates: Store information about the parking rates for cars and motorcycles. Consider

factors such as hourly rates, daily rates, and any discounts.

Your task is to create an entity$-$relationship diagram $($ERD$)$ for this parking lot management

system, identifying entities, relationships, and attributes. Additionally, provide a brief

explanation of your design choices, including any assumptions you made.

Submission:

$1.$ Create a third normal form $(3$NF$)$ physical ERD for the online bookstore database.

$2.$ After creating your ERD, you will use either a Webcam Video or Screencast to provide a

brief explanation of your design choices, addressing how you handled relationships, any

assumptions made, and why certain attributes were included. Ensure that both you and your

ERD are visible in the recording throughout the presentation.

$3.$ Lastly, submit the following two items to the assignment module:

$(1)$ Your ERD.

$(2)$ Your ERD explanation recording.