Question

Prepare a 400 words essay:

You are a participant in an information systems project to design a vehicle theft database for a state law enforcement agency. The database will provide information about stolen vehicles (e.g., autos, golf carts, SUV, and trucks), with details about the vehicle theft as well as the stolen vehicle itself. These details will be useful to law enforcement officers investigating the vehicle theft.

- Identify 10 data attributes you would capture for each vehicle theft incident. How many bytes should you allow for each attribute? Give an example of the data you would store in each field.

- Specify which attribute from your list you designate as the primary key

- Discuss briefly: should the database include data about the status of the theft investigation? If so, what sort of data needs to be included?

- Discuss briefly: Can you foresee any problems with keeping the data current? Explain

Please new answer, about 400 words.

Answer 1