Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this java project. Create a database Called ParkTickets. Create a table for ParkedCar, ParkingTicket, ParkingMeter. The parking meter should be assigned

I need help with this java project.

Create a database Called ParkTickets. Create a table for ParkedCar, ParkingTicket, ParkingMeter. The parking meter should be assigned a unique id, and PoliceOfficer. The fields for the tables should be the same ones as created for each object in the classes.

Here the actual project. I just dont know how to create the database in java project.

Class Project - Parking Ticket Simulator

Design a set of classes that work together to simulate a police officer issuing a parking ticket. Design the following classes:

The ParkedCar Class: This class should simulate a parked car. The classs responsibilities are as follows:

To know the cars make, model, color, license number, and the number of minutes that the car has been parked.

The ParkingMeter Class: This class should simulate a parking meter. The classs only responsibility is as follows:

To know the number of minutes of parking time that has been purchased.

The ParkingTicket Class: This class should simulate a parking ticket. The classs responsibilities are as follows:

To report the make, model, color, and license number of the illegally parked car To report the amount of the fine, which is $25 for the first hour or part of an hour that the car is illegally parked, plus $10 for every additional hour or part of an hour that the car is illegally parked

To report the name and badge number of the police officer issuing the ticket

The PoliceOfficer Class: This class should simulate a police officer inspecting parked cars. The classs responsibilities are as follows:

To know the police officers name and badge number

To examine a ParkedCar object and a ParkingMeter object, and determine whether the cars time has expired

To issue a parking ticket (generate a ParkingTicket object) if the cars time has expired .

Create a database Called ParkTickets. Create a table for ParkedCar, ParkingTicket, ParkingMeter. The parking meter should be assigned a unique id, and PoliceOfficer. The fields for the tables should be the same ones as created for each object in the classes.

Create an input screen to enter data for the ParkedCar into the ParkedCar table

Create an input screen to enter ParkingTicket data into this table. When entering this data, validate the Car against the ParkedCar table. In other words, if ParkedCar record does not exist, issue a valid error message.

Create an Input screen to input records for each entity in your database.

Write a program that demonstrates how these classes and databases collaborate

Analysis:

(Describe the problem including input and output in your own words.)

Design:

(Describe the major steps for solving the problem.)

Submit the following items:

Submit the UML Class diagram for all classes and their relationships

Source code for your program and classes

Submit the databases created for your project

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

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

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

Create a summary of experience

Answered: 1 week ago

Question

1. What are the peculiarities of viruses ?

Answered: 1 week ago

Question

Describe the menstrual cycle in a woman.

Answered: 1 week ago