Question: Vehicle Theft Database
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, SUVs, 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.
Review Questions
1. Identify 10 data attributes you would capture for each vehicle theft incident. How many bytes should you allow for each attribute?
2. Which attribute would you designate as the primary key?
Critical Thinking Questions
1. Should the database include data about the status of the theft investigation? If so, what sort of data needs to be included?
2. Can you foresee any problems with keeping the data current? Explain.