Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions