Designing Databases:

Design an E-R model for a small Tire Company, think about Firestone. Your tire company has clients, products, employees

1- What information do you need to create a model of your business? (5 points)

2- What entities do you need? (15 points)

a. Give their names

b. Their attributes

c. The kind of data of each attribute

d. The key field

3- Create a relationship among the different entities pointing to the keys and foreign keys. Show the cardinality in the relationship (15 points)

4- How would you navigate the entities if you need to know the kind of tires that X person bought? (15 points)