Scribd
Upload
5 views4 pages

TravelX Data Dictionary Overview

The document describes a data dictionary for a travel management system with tables for employees, customers, and ride details including column names and data types. It also includes an entity-relationship diagram and data flow diagrams showing the system workflow.

Uploaded by

aishwarya saji
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 views4 pages

TravelX Data Dictionary Overview

The document describes a data dictionary for a travel management system with tables for employees, customers, and ride details including column names and data types. It also includes an entity-relationship diagram and data flow diagrams showing the system workflow.

Uploaded by

aishwarya saji
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

AISHWARYA SAJI &

SNEHAL PACHUNDKAR
SY BCA

DATA DICTIONARY FOR TRAVELX


COLUMN NAME DATA TYPE CONSTRAINT TYPE

E_ID INTEGER PRIMARY KEY


NAME INTEGER FOREIGN KEY WITH
INFO
DOB INTEGER

ADDRESS VARCHAR2

DOJ VARCHAR2

Employee (driver)
customer
COLUMN NAME DATA TYPE CONSTRAINT TYPE

C_NO INTEGER PRIMARY KEY


NAME VARCHAR2
TYPE VARCHAR2
LOCATION VARCHAR2
DATE INTEGER
ID INTEGER FOREIGN KEY WITH
INFO
ride details
COLUMN NAME DATA TYPE COSTRAINT TYPE
R_NO INTEGER PRIMARY KEY
TYPE VARCHAR2
LOCATION DATA
ENTITY -RELATIONSHIP DIAGRAM
CONTEXT-LEVEL DIAGRAM

request(s) submission(s)

Working of the DRIVER


CUSTOMER
fright system

Response from service


driver
Data flow diagram

Login
Username/password details
login login

ride assign Ride details


Ride Fright
assign confirmed

driver

Payment
payment
Online/offline completed
payment

Queries/complaints
Response
interaction
feedback

You might also like