Software Production Technology Project

Assignment - "Taxi Managment Application"

1. Create Cars table

Field Name	Data Type	Description
KodTaxi	Number	Unique Taxi Number
RegNomer	Short Text	Registration Number
Mark	Short Text	Brand Of The Car
Seats	Number	Number Of Seats For Passengers
Luggage	Yes/No	Space For Large Luggage (Yes/No)
Driver	Short Text	Name Of The Driver

2. Create Orders table

Field Name	Data Type	Description
NumOrd	Number	Order Number
KodTaxi	Number	Taxi Number
Address	Short Text	Address From Which The Order Was Placed
OrdTime	Date/Time	Time (Date And Time) Of The Order
Distance	Number	Distance Traveled (km)
Fare	Currency	Order Fee (BGN)

3. In the Cars table, fill in at least 5 entries with meaningful data in Bulgarian and Cyrillic, and in Orders -10.
4. Create a summary parametric query qryTotalOrders based on the Cars and Orders tables, which will show for orders placed before a date set by parameter:
   • the registration number and brand of the taxi;
   • the total amount of orders for each fee;
5. Create a menu bar for the information system with three points:
   • Input - to launch the forms
   • Reports – to launch the reports
   • Exit – to close the program
6. Create the following forms
   • frmCars based on the Cars table.
   • Orders subform based on the Orders table.
   • in frmCars form create a subform based on Orders subform so when in the main form, select fees, in the subform, only the executed ones should be displayed orders from him. The labels of the control elements should be in Bulgarian and Cyrillic.
7. Create 2 reports based on the Orders table and the parametric query. The inscriptions in reports to be in Bulgarian and Cyrillic.
8. You may use a database of your choice.
9. The project must be printed and well designed, have a conceptual, physical and logical database model, as well as use and class diagrams.

Project Development

The following programming languages were used for the development of the project:

1. C#
2. SQL

And the following tools:

1. Visual Studio 2022
2. Microsoft Access 2016

Contributors

Screenshots of the program execution

Cars Table

Orders Table

Main Menu

Add Taxi Form

Add Orders Form

First Query

Second Query