Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Information Systems

Authors: Ralph Stair, George Reynolds

13th edition

1305971779, 978-1305971776

More Books

Students also viewed these Databases questions

Question

What is search engine optimization, and how is it accomplished?

Answered: 1 week ago