SlNo Feature Story number
1 create a table for storing passenger data US_SQL_001
2 create a table for creating a train table US_SQL_002
3 create a table for storing booking US_SQL_003
4 Add Column US_SQL_004
5 Find the total number of male passengers: US_SQL_005
List passengers ordered by last name in
6 descending order
US_SQL_006
7 Display booking information US_SQL_007
Description (Card)
As a developer, I want to create tables so that I
can store passenger data.
As a developer, I want to create tables so that I
can store train data.
As a developer, I want to create tables so that I
can store booking data.
As a developer
I want to add additional columns to the table -
passenger
As a developer
I want to Find the total number of male passengers
the table - passenger
As a developer
I want to List passengers ordered by last name in
descending order - passenger
As a developer
I want to display the passengers' first name, last
name, train id, train name, starting location and price
of booking based on the train id
Initial Size Estimate
Acceptance Criteria (Confirmation)
(SP)
PassengerID: Unique identifier for each passenger.
-FirstName and LastName: Non-null fields to store the passenger's name.
-Age: Integer field to store the passenger's age. It must be greater than or
equal to 0.
-Gender: Single character field ('M', 'F', or 'O' for Other). A check constraint
ensures only these values are accepted.
-TicketNumber: Unique ticket number for each passenger.
-BoardingDate: Date field to store the date when the passenger boards.
- train_Id as an integer primary key.
- train_name as a non-null string (up to 255 characters).
- start_location as a non-null string (up to 255 characters).
- end_location as a non-null string (up to 255 characters).
- status as a string with a check constraint limiting values to 'Active' or
'Inactive
- booking_id as an integer primary key
- passenger_id as Foreign key references
'Passenger' table
- train_id as an integer (foreign key referencing `train` table)
- price as a decimal number (10 digits, 2 after the decimal point)
- journey_date as a date.
- Link train_id to train_Id in the train table
Add the below columns to the table-passenger
SeatNumber: A variable character field to store the seat number of the passenger.
The result should be the count of passengers who are male.
The result should be a list of passengers ordered by last name in descending
alphabetical order
The result should be a display details of the passengers' first name, last name,
train id, train name, starting location and price of booking based on the train id
Business Sprint
Comments
Priority Number
