Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ROUTES: RouteID - > Route Name, RouteDescription ROUTESSTOPS: RouteID, StopID - > StopSequence STOPS: StopID - > StopName , Address, Latitude, Longitude PAYMENTHISTORY: PaymentID -
ROUTES: RouteID Route Name, RouteDescription ROUTESSTOPS: RouteID, StopID StopSequence STOPS: StopID StopName Address, Latitude, Longitude PAYMENTHISTORY: PaymentID PassengerID ToStopID, FromStopID, ScheduleID, PaymentMethod, AmountPaid, PaymentDate PAYMENTS: PaymentID PassengerID ScheduleID, CardNumber, Card HolderName, PaymentAmount, BusID, PaymentMethod, RouteID, ExpiryDate, PaymentDate PASSENGERS: PassengerID FirstName LastName, PhoneNumber, Email FEEDBACK: FeedbackID PassengerID Comment, Submission Date, Rating, ScheduleID, RouteID, BusID SCHEDULES: ScheduleID RouteID BusID, DriverID, DepartureTime, ArrivalTime TRIPSTATUS: TripStatusID BusID ScheduleID, CurrentStopID, Status, Arrival TimeEstimate DRIVERS: DriverID FirstName LastName, LicenseNumber BUSSES: BusID BusNumber DriverID, Capacity BUSLOCATION: BusID Latitude Longitude, Timestamp i did something like this and i need to improve it: FUNCTIONAL DEPENDENCIES UNNORMALISED FORM FIRST NORMAL FORM SECOND NORMAL FORM THIRD NORMAL FORM
ROUTES: RouteID
Route Name, RouteDescription
ROUTESSTOPS: RouteID, StopID
StopSequence
STOPS: StopID
StopName Address, Latitude, Longitude
PAYMENTHISTORY: PaymentID
PassengerID ToStopID, FromStopID, ScheduleID, PaymentMethod, AmountPaid, PaymentDate
PAYMENTS: PaymentID
PassengerID ScheduleID, CardNumber, Card HolderName, PaymentAmount, BusID, PaymentMethod, RouteID, ExpiryDate, PaymentDate
PASSENGERS: PassengerID
FirstName LastName, PhoneNumber, Email
FEEDBACK: FeedbackID
PassengerID Comment, Submission Date, Rating, ScheduleID, RouteID, BusID
SCHEDULES: ScheduleID
RouteID BusID, DriverID, DepartureTime, ArrivalTime
TRIPSTATUS: TripStatusID
BusID ScheduleID, CurrentStopID, Status, Arrival TimeEstimate
DRIVERS: DriverID
FirstName LastName, LicenseNumber
BUSSES: BusID
BusNumber DriverID, Capacity
BUSLOCATION: BusID
Latitude Longitude, Timestamp
i did something like this and i need to improve it:
FUNCTIONAL DEPENDENCIES
UNNORMALISED FORM
FIRST NORMAL FORM
SECOND NORMAL FORM
THIRD NORMAL FORM
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started