Seating capacity and cost trucks which have chassis number

Q1] Design a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles which have an engine number and cost; cars which have a chassis number, an engine number, seating capacity and cost; trucks which have chassis number, an engine number and cost.

Q3] Given the dependency diagram shown in the following figure, (the primary key attributes are underlined)
(i) Identify and discuss each of the indicated dependencies.

(ii) Create a database whose tables are at least in 3NF, showing dependency diagram for each table

C1		C2 represents a partial dependency-because C2 depends only on C1 rather

C1, C3

because C2, C4 and C5 depend on the primary key composed of C1 and C3

ii)

Normal Form: 3NF
Table 3
Primary Key: C4

TOUR