Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A long-term parking facility close to a major international airport serves both one-time customers, who use the facility from a few hours to several weeks

A long-term parking facility close to a major international airport serves both one-time customers, who use the facility from a few hours to several weeks and pay for one use at a time, and long-term customers, who pay a monthly or yearly fee to be able to park at the facility at any time without any additional cost. The long-term customers are always guaranteed to have a parking spot available, regardless of their time of arrival. The fees charged for the parking service can change at any point in time, but paying for a year in advance guarantees the price for that time period.

Currently, one-time customers cannot reserve a spot in advance, but they are able to look up the number of available spots online. At any point in time, the facility knows exactly which parking spots are in use because of a set of sensors that know when a particular spot is occupied; in addition, each spot has a camera, with which the facility can verify the license plate number of the vehicle parked in it.

Long-term customers currently need to come to the facility to buy and pay for a contract for long-term use of the facility. At the time of payment, they will receive an RFID-equipped card that gives them 24/7 access to the facility. Renewal payments need to be made at the facility. If the contract is not renewed, the card will stop working.

One-time customers get a ticket upon their arrival at the facility; if they are staying for more than a week, they will need to register at the facility service desk and give a key to their vehicle to the facility representative. At the time of vehicle pickup, the customers who stayed more than a week have to first check at the service desk the location of their vehicle and pay for the service before they are able to pick up their vehicle. Visitors with a short one-time visit are able to pay for their visit at the departure gate, based on their original ticket.

List the following elements of an ER diagram:

Entities, Attributes, Primary Keys, Foreign Keys, and Relationships with cardinality.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Databases Illuminated

Authors: Catherine M. Ricardo

1st Edition

0763733148, 978-0763733148

More Books

Students also viewed these Databases questions

Question

Distinguish between quartz and quartzite.

Answered: 1 week ago

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago