SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 305 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 28 Nov 2017 My Price 10.00

someone help me with the E-R model and check my work

#Oracle SQL

Can someone help me with the E-R model and check my work ( I already wrote it in the Word file )

I was confused with the "Addition notes" ...

Please fix my mistakes and complete it :)

 

 

 

 

 

 

 

 

 

 

 

My work:

 

CREATE TABLE Criminals (

CRIMINAL_NAME CHAR(9),

ADDRESS CHAR(20),

PHONE_NUMBER NUMBER(10),

VIOLENT_OFFENDER_STATUS CHAR(1) DEFAULT 'N',

PROBATON_STATUS CHAR(1) DEFAULT 'N',

ALIASES CHAR(9))

 

CREATE TABLE Crimes (

CLASSIFICATION CHAR(11),

DATE_CHARGED DATE,

APPEAL_STATUS CHAR(2),

HEARING_DATE DATE DEFAULT SYSTEM,

APPEAL_CUTOFF_DATE DATE DEFAULT SYSTEM,

ARRESTING_OFFICERS NUMBER(2),

CRIMES_CODES NUMBER(9),

AMOUNT_OF_FINE NUMBER(7,2),

COURT_FEE NUMBER(7,2),

AMOUNT_PAID NUMBER(7,2),

PAYMENT_DUE_DATE DATE DEFAULT SYSTEM,

CHARGE_STATUS CHAR(11))

 

CREATE TABLE Sentencing (

START_DATE DATE DEFAULT SYSTEM,

END_DATE DATE DEFAULT SYSTEM,

NUMBER_OF_VIOLATIONS NUMBER(4),

TYPE_OF_SENTENCE CHAR(2) DEFAULT 'P')

 

CREATE TABLE Appeals (

APPEAL_FILING_DATE DATE DEFAULT SYSTEM,

APPEAL_HEARING_DATE DATE DEFAULT SYSTEM,

STATUS CHAR(1) DEFAULT 'P')

 

CREATE TABLE Police_officers (

OFFICER_NAME CHAR(9),

PRECINCT CHAR(4),

BADGE_NUMBER VARCHAR2(14), 

PHONE_CONTACT NUMBER(10),

STATUS CHAR(1) DEFAULT 'A')

 


Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 28 Nov 2017 02:11 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)