2. You have been asked to design a database to track data from Bender's Auto Body...

Transcribed Image Text:

2. You have been asked to design a database to track data from Bender's Auto Body Customer Satisfaction Survey (shown on the next page). Create a list of the attributes needed for tracking this data and the data type for each attribute. For text attributes, estimate the text length. What entity is the attribute belong to? What would you use for a primary key? Note, Yes No Comments: CNIT 180 Lab 8 Entity Discovery Name: Day Phone: Car Make: each entity will need a primary key. Bender's Auto Body Customer Satisfaction Survey ☐☐Were you satisfied with the services performed? Were you greeted quickly and professionally? Were you treated politely by all of our staff? Were the services you requested finished on schedule? Model: Survey #: 1456 Date of Repair THE Year: 2. You have been asked to design a database to track data from Bender's Auto Body Customer Satisfaction Survey (shown on the next page). Create a list of the attributes needed for tracking this data and the data type for each attribute. For text attributes, estimate the text length. What entity is the attribute belong to? What would you use for a primary key? Note, Yes No Comments: CNIT 180 Lab 8 Entity Discovery Name: Day Phone: Car Make: each entity will need a primary key. Bender's Auto Body Customer Satisfaction Survey ☐☐Were you satisfied with the services performed? Were you greeted quickly and professionally? Were you treated politely by all of our staff? Were the services you requested finished on schedule? Model: Survey #: 1456 Date of Repair THE Year:

Answer rating: 100% (QA)

To design a database to track data from Benders Auto Body customer satisfaction survey I would create the following entities Customer CustomerID primary key FirstName LastName DayPhone CarMake CarMode... View the full answer