For source Code and Script you can use this Link: https://drive.google.com/file/d/1SJzq...
-----------------------------------------------------------------------------------------------------------------
Fleet Management System Relational Data Model (RDM)
Tables Name:
Delivery: Delivery_ID (PK), Description, Delivery_Date, Delivery_Type, Driver_ID (FK), Manager_ID (FK).
Driver: Driver_ID (PK), Driver_Name, Driver_License.
Manager: Manager_ID (PK), Name.
Technician: Technician_ID (PK), Name, Manager_ID (FK)
Vehicles: Plate_Number (PK), Model, Type, Transmission_Type, Fuel_Type, Technician_ID (FK).
Service: Service_ID (PK), Date, Manager_ID (FK).
Insurance: Insurance_Number (PK), Renewing_Date, Insurance_Date, Insurance_Company, Plate_Number (FK).
Registration: Registration_Number (PK), Export_Date, Renewing_Date, Plate_Number (FK).
Payment: Bill_ID (PK), Date, Price, Payment_Type, Description, Insurance_Number (FK).
For designing of Fleet Management System, I have accomplished all database requirement which we covered during our lecture in the class such us Normality and other specification.
As I wrote it above in RDM I identify the constraints key such us (PKs and FKs) on the database design as well I implemented according to this design.
I have implemented my database design in Oracle 18c database using SQL Developer, I have attached all Script file for creating of Tables and inserting of attributes as will with Altering of Primary key with Foreign key.
I have connected my database with Java Programming language via NetBeans IDE which I explained it in video.
Информация по комментариям в разработке