Plzzzz helllp meeeee my sql need RE WITH MY SQL HEN REPITE Database..!!! Project
ID: 3717862 • Letter: P
Question
Plzzzz helllp meeeee
my sql
need RE WITH MY SQL HEN REPITE
Database..!!! Project Description The ministry of transport would like to build a system that tracks the traffic common transportation vehicles which include busesand metros. The system is used by: The passenger who can: 1. Book a seat by providing: departure station, destinationstation and time and vehicle type. 2. Cancel a booking 3. Buy a ticket. 4. List all available vehicles departing/arriving from/to a specific station. The administrator who can: 1. Add/delete/edit a station with an address, a name and a GPS coordinates. 2. Add/delete/edit a vehicle with a type (bus or metro), seats number. 3. Add/delete/edit a connection which is characterized by a departure station, arrival station, departure time, arrival time, ticket price 4. Attach/detach a vehicle from a connection. Build the system.Explanation / Answer
ANS:-
Given that,
home / study / engineering / computer science / computer science questions and answers / database ... !!! project description the ministry of transport would like to build a system ...
Question: Database ... !!! Project Description The ministry of transport would like to build a syste...
Database ... !!!
Project Description
The ministry of transport would like to build a system that tracks the traffic common transportation vehicleswhich include busesand metros. The system is used by:
The passenger who can:
1. Book a seat by providing: departure station, destinationstation and time and vehicle type.
2. Cancel a booking.
3. Buy a ticket.
4. List all available vehicles departing/arriving from/to a specific station.
solution:-
To build a database for all above requirements, you need to create following database objects:
1. Tables:
2. Stored Procedures:
Booking related:
General:
Show all available vehicles as per the date selected
Admin role:
Leave in comments if you need the help with scripts
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.