KEMBAR78
2 PBL SQL | PDF | Data Management | Computing
Scribd
Upload
5 views8 pages

2 PBL SQL

The document outlines a series of user stories related to creating and managing database tables for passenger, train, and booking data. It includes specifications for table structures, data types, and constraints, as well as requirements for querying passenger information. The document serves as a guide for developers to implement the necessary database functionalities.

Uploaded by

Lovekush Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views8 pages

2 PBL SQL

The document outlines a series of user stories related to creating and managing database tables for passenger, train, and booking data. It includes specifications for table structures, data types, and constraints, as well as requirements for querying passenger information. The document serves as a guide for developers to implement the necessary database functionalities.

Uploaded by

Lovekush Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

SlNo Feature Story number

create a table for storing


1 US_SQL_001
passenger data

create a table for creating a


2 US_SQL_002
train table

create a table for storing


3 US_SQL_003
booking
4 Add Column US_SQL_004

Find the total number of male


5 US_SQL_005
passengers:

List passengers ordered by last


6 US_SQL_006
name in descending order

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 Business
Acceptance Criteria (Confirmation)
Estimate (SP) Priority

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


Sprint
Comments
Number

You might also like