How to connect java with Oracle database
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.
On this page of the site you can watch the video online How to connect java with Oracle database with a duration of hours minute second in good quality, which was uploaded by the user Abdul Waris Sherzad 01 January 1970, share the link with friends and acquaintances, this video has already been watched 52 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
