Question
Easy Parking is a company managing many car parks in big cities in Australia. The company is developing an online platform for customers to book
Easy Parking is a company managing many car parks in big cities in Australia. The company is developing an online platform for customers to book and pay their parking's via a mobile app. A customer can register an account on the platform with details of mobile number, credit card detail or bank account, address, email, and car registration number; after registration, a customer can book parking lot in advance at car park or enter a car park and start a parking session on the mobile app and stop the parking session when exit the car park. The parking rate is various depending on the location of the car park and the time of parking, for example early bird rate, hourly rate, daily rate and night rate. Customers will be charged once the parking session is over.
After interviews with Easy Parking, you have come up with the following business rules:
- Easy Parking has many car parks at different cities and location to manage.
- Each car park has its capacity, for example 120 cars.
- Each customer can only have one mobile number.
- Each customer can have more than one car.
- Each customer must nominate a valid credit card or bank account details.
- Each car park can have one or more rates, depending on the time of parking and location
You are given the task to model the database to support the parking management platform and draw a corresponding ER diagram for the database. Please note:
- You can decide the names for entities, attributes and relations, but you should use UPPERCASE to name your entities and use capitalization to name attributes of entities [6 marks]
- Underline all primary key (PK) attributes and put (FK) next to all foreign key attributes
- Clearly indicate participation and cardinalities between entities.
- Provide any assumptions made.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Database Model for Easy Parking Entities CUSTOMER PK CustomerID attributes MobileNumber CreditCardDetailsBankAccountDetails Address Email CarRegistrationNumber CAR PK CarID attributes CustomerID CarPl...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started