Story
SlNo Feature Description (Card)
number
Storing User Data(Master As a developer, I want to create tables so
1 US001
table) – SQL that I can store user details.
As a developer I should be able to add user
2 Register User - SQL US002
and store user data to the table
As a developer I should be able to login
3 Log in User - SQL US003
based on the roles.
As a developer I need to create a table to
4 Storing Booking Data – SQL
store the booking information
As a developer I should be able to view the
5 Retrieve the user information
necessary details of user based on userID
As a developer I need to store the booking
6 Booking Service
information to the corresponding table
As a developer I should be able to view the
7 Invoice Details
invoice for the booking done
As a developer I need to view the latest ten
Tracking status – Customer/
8 bookings done by the customer sorted in
Officer
descending order of booking
As an officer I should be able to search the
9 Pickup/ Drop update - Officer
booking details based on Booking ID
As an officer I should be able to update the
10 Pickup/ Drop update - Officer Pick and Drop Date time based on booking
ID
As an officer I should be able to update the
11 View delivery details - Officer
Delivery Status of the Parcel
As an officer I should be able to update the
12 Delivery Update
Delivery Status of the Parcel
As a Customer, I should be able to view the
13 Booking History - Customer
booking details of specific user
As an officer I should be able to view the
booking history of a particular user with in
14 Booking History - Officer
date range in descending order of the
Booking Date
Acceptance Criteria (Confirmation)
* The table(tbl_UserProfile) should have columns for UserID, FullName, Email, MobileNumber, and
Password.
- User_ID
- FullName
- Rec_Address
- Email (Unique)
- MobileNumber
- Password
- Role
* Set the UserID column as the primary key.
* Create the table script as an .sql file.
* Save it as a users.sql file.
Prepare a SQL query to add data to the User Table
- User_ID (Auto generated)
- FullName
- Address
- Email
- MobileNumber
- Password
- Role
* Insert 5 users' information to this table. Create the insert script for the same. Also save it as a
users.sql file.
* This should validate the constrains
Prepare a SQL query which validate the user credentials from the corresponding user table and return
a boolean flag with Role.
Input
* User Name
* Password
Output (if Exists)
* Role
* User Name
* Password
Prepare a SQL query to create table to store the booking information
- Booking_ID
- User_ID
- Rec_Name
- Rec_Address
- Rec_Pin
- Rec_Mobile
- Par_Weight_Gram
- Par_Contents_Description
- Par_Delivery_Type
- Par_Packing_Preference
- Par_PickupTime
- Par_DropoffTime
- Par_ServiceCost
- Par_PaymentTime
- Par_Status
Prepare a SQL query to fetch the details based on the userID
-Name
-Address
-Contact details
Prepare a SQL query which inserts the booking details into the table.
- User_ID
- Rec_Name
- Rec_Address
- Rec_Pin
- Rec_Mobile
- Par_Weight_Gram
- Par_Contents_Description
- Par_Delivery_Type
- Par_Packing_Preference
- Par_PickupTime
- Par_DropoffTime
- Par_ServiceCost
- Par_PaymentTime
These information need to save to the DB and BookingID need to be auto generated.
Prepare an SQL query to fetch the information based on the booking ID
-Booking ID
-Receiver Name
-Receiver Address
-Receiver Pin
-Receiver Mobile
-Parcel Weight(g)
-Parcel Contents Description
-Parcel Delivery Type
-Parcel Packing Preference
-Parcel Pickup Time
-Parcel Dropoff Time
-Parcel Service Cost
-Parcel Payment Time
Prepare an SQL query which result the ten latest booking by a particular user, below fields need to be
resulted
Booking ID | FullName | Address | Rec_Name | Rec_Address | Date of Boooking |Par_Status
Prepare SQL query to retrieve the below details based on the Booking ID.
Booking ID | FullName | Address | Rec_Name | Rec_Address | Date of Boooking |Par_Status |
Par_PickupTime | Par_DropoffTime
Prepare SQL query to update the Pick and Drop time based on the Booking ID.
Prepare SQL Query to retrieve the delivery status of the Parcel based on the Booking ID and display the
below items
Booking ID | FullName | Address | Rec_Name | Rec_Address | Date of Boooking |Par_Status |
Prepare SQL Query to update the delivery status of the Parcel based on the Booking ID
Prepare a SQL query to retrieve the below booking history information
Customer ID | Booking ID | Booking Date | Receiver Name | Delivered address | Amount |Status
Prepare and SQL query to retrieve the below booking history information
Customer ID | Booking ID | Booking Date | Receiver Name | Delivered address | Amount |Status
Based on the Customer ID and Date Range
Initial Si Business P
Sprint NuComments
