5) (a) Create data model that capture the information shown in the following tic

Question

5) (a) Create data model that capture the information shown in the following ticket. This model can be used as the preliminary design of a database that keeps track of traffic law violation

    (b) Covert your ER model into a set of tables. Type your tables.

WASHINGTON STATE PATROL CORRECTION NOTICE NAME Kroenke ADDRESS 5053 88 Ave SE ay Mecer Island STATE Wa 98040 Davrid M LAST FIRST ZIP DRIVERS LICENSE STATE BIRTH DATE HGT WGT EYES War 2/27466 165B VEHICLES LICENSE STATECOLOR YEAR TYPE AAA000 W 900 VIN REGISTERED OWNER ADDRESS MOLATION DATE DIST DETACH DAY LOCATION 7 Enuuckum ot SR410 MILES MOLATIONS Writing text while OFFICERS SIGNATURE S Scott NUMBER This is a waning, no further action is required. You are released to take this vehicle to a place of repair Continued operation on the roadway is not authorized. CORRECT VIOLATION(S IMMEDIATELY. Retum this signed card ance within 15/30 days. (if this box checked) DRIVERS SIGNAT

Explanation / Answer

create table film ( filmid integer, title varchar(50),

year integer director name varchar(50) not null,

language varchar(30),

primary key (filmid),

foreign key first name,

foreign key (leading actor) last name

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.