Scribd
Upload
6 views2 pages

Traffic Management System Schema Design

The document outlines a project titled 'Traffic Management System' submitted by Maryam Khursheed. It includes a normalization schema detailing various tables such as Owner, Vehicle, Driver, Traffic Officer, Road, Checkpoint, Camera, Violation, Incident, and Vehicle Incident, each with specified attributes. This schema is designed to manage and organize data related to traffic management effectively.

Uploaded by

m.k50263456
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
6 views2 pages

Traffic Management System Schema Design

The document outlines a project titled 'Traffic Management System' submitted by Maryam Khursheed. It includes a normalization schema detailing various tables such as Owner, Vehicle, Driver, Traffic Officer, Road, Checkpoint, Camera, Violation, Incident, and Vehicle Incident, each with specified attributes. This schema is designed to manage and organize data related to traffic management effectively.

Uploaded by

m.k50263456
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

Submitted To Mam Farwa

Submitted By Maryam Khursheed


Reg No 24-UON-0389
Semester BSCS 3rd(M) B

Project Title: Traffic Management System

NORMALIZATION OF SCHEMA:
Onwer Table
Owner_ID Name Contact Address

Vehicle Table
Vehicle_ID Onwer_ID Type Model [Link]

Driver Table
Driver_ID Name Contact Address License_No.

Traffic_Officer Table
Officer_ID Name Contact Rank Station

Road Table
Road_ID Road_Name Area Speed_limit

Checkpoint
Checkpoint_ID Name Road_ID Officer_ID Area

Camera Table
Camera_ID Road_ID Location Type Is_active Resolution

Violation Table
Violation_ID Type Penalty_amount Description Category

Incident Table
Incident_ID Date Time Location Status

Vehicle_Incident Table
Vi_ID Vehicle_ID Driver _ID Incident_ID Remarks

You might also like