Scribd
Upload
7 views2 pages

Transport Ticket Booking Data Dictionary

The document outlines the data dictionary for a Transport Ticket Booking System project, detailing the structure of three tables: USER_TABLE, TRANSPORT_TABLE, and BOOKING_TABLE. Each table includes attributes such as USER_ID, TRANSPORT_ID, and BOOKING_ID, along with their types, formats, and whether they are required or referenced as primary or foreign keys. The project deadline is set for October 19, 2023, at 23:59.

Uploaded by

hasib.ahasanofficial
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Transport Ticket Booking Data Dictionary

The document outlines the data dictionary for a Transport Ticket Booking System project, detailing the structure of three tables: USER_TABLE, TRANSPORT_TABLE, and BOOKING_TABLE. Each table includes attributes such as USER_ID, TRANSPORT_ID, and BOOKING_ID, along with their types, formats, and whether they are required or referenced as primary or foreign keys. The project deadline is set for October 19, 2023, at 23:59.

Uploaded by

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

Database - Final Project – Step 2 – Data Dictionary – 5 points

Deadline: October 19 (Saturday) at 23:59


Team Member(s): Hasibul Ahashan Hasib 202412411
Project Topic: Transport Ticket Booking System with Seat Reservation and Fare Calculation

PK FK
Table Name Attribute Name Contents Type Format Range Required or Referenced
FK Table
Unique
XXXXXXXX
USER_ID identification Varchar(9) 0-9 Yes
X PK
of users
User’s first
FIRST_NAME Text Xxxxx Yes
name
User’s middle
MIDDLE_NAME Text Xxxx Yes
name
USER_TABLE
User’s last
LAST_NAME Text Xxxx Yes
name
E-MAIL User’s e-mail Varchar(9) xxxxxxxxx 0-9
User’s phone
PHONE_NUMBER Int 9999999999 Yes
number
Last update to
UPDATE_AT Date yyyy-mm-dd Yes
user’s profile
Unique XXXXXXXX
TRANSPORT_ID Varchar(9) 0-9 Yes Pk
identification X
Type of
VEHICLE_TYPE Varchar(9) Xxxxxxxxx 0-9 Yes
vehicles
Seats in the
TOTAL_SEATS Int 9999
vehicle
TRANSPORT_TABLE
Starting
DEPARTURE_LOCATION Text Xxxxx Yes
location
Ending
ARRIVAL_LOCATION Varchar(9) Xxxxxxxxx 0-15 Yes
location
Base fare for
FARE Decimal(10,2) 10/20 Yes
the transport
Unique XXXXXXXX
BOOKING_ID Varchar(9) 0-9 Yes Pk
identification X
USER_ID Unique Varchar(9) XXXXXXXX 0-9 Yes Fk User table
identification
X
of users
Unique XXXXXXXX
TRANSPORT_ID Varchar(9) 0-9 Yes Fk Transport table
identification X
BOOKING_DATE Date time Date yyyy-mm-dd Yes
BOOKING_TABLE
Confirmed or
STATUS Text xxxxxxxxx Yes
cancelled

You might also like