1)

2)

(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.

6. SQL queries, (show SQL codes and results)

a. List the total number of projects that has for each division, including division name

b. List the name of division that sponsors project web development

c. List the name of employee who works on web development

Given the following logical database design, draw a complete ER mode (including cardinalities) based of this design. (Note this is a "reverse" process of DB design) SCHOOL (school-code, school-name, dean) CLUBS (club-name, membership-Fee, director-name) STUDENT(SSN, name, birth-date, sex, school-code) Major (major-code, major-name) a. STUDENT_ MAJOR(SSN.major-code) MEMBERSHIP(ssn, club-name, starting-date) b. Explain the meaning of the cardinalit ies if the following rel ationship Play-for players teams