1. Define each of the following terms.(a) entity type(b) attribute(c) relationship type(d) relationship instance(e) composite attribute(f) multivalued attribute(g) derived attribute(h) key (no answer, just for question 3)

3.For each of the terms in Question #1 above, show how to represent it in an ER diagram using Chen notation, or if it cannot be represented using Chen notation, then say so.

4.What is the actual unit of storage used in most current databases (hint: it has rows and columns)? How do we envision the data inside of this unit? Give an example.

5.For each of the following entity types and associated lists of attributes, (i) Describe a reasonable domain for each attribute; (ii) Describe a bad choice of key for the entity type, and explain why; (iii) Describe a reasonable choice of key for the entity type; and (iv) Decide which attributes, if any, should actually have their own entity types.

(a) Car: make, model, year, color, vehicle identification number (VIN), license plate number, engine capacity, owner, date that the vehicle was last serviced.

(i)

(ii)

(iii)

(iv)

(b) Doctor: first name, last name, specialty area, office location, date medical degree was received.

(i)

(ii)

(iii)

(iv)