Database processing chapter 6 writers state Patrol case ques

Database processing chapter 6 writer\'s state Patrol case questions... convert this data model to a database design, specify tables primary keys and foreign keys

Solution

Solution:

Writer’s Patrol traffic citation consists of five entities they are owner, card_details, violation details, officer_details and punishment.

Owner:

Licenseid varchar (25) primary key,firstname varchar(20),lastname varchar(20),address varchar(20),City varchar(20),code varchar(20),date_0f_birth time date, height decimal(10,10),weight decimal(10,10),eyes time date.

Cardetail:

Vehicle_id varchar(20) primary key,color varchar(20),year int,make varchar(20),type varchar(20),state varchar(20),registered varchar(20),address varchar(20),owner varchar(20).

Violationdetail:

Driverlicenseid varchar(20) primary key,date int,month int,year int,time timedate,distance decimal(10,10),location varchar(20),act varchar(20),detach varchar(20).

Officer detail:

Personelno varchar(20) primarykey,signature varchar(20).

Punishment detail:

Driversign varchar(20) primary key,punishment varchar(20).