Question
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
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.
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?
3. Should the database include data about the status of the theft investigation? If so, what sort of data needs to be included?
4. Can you foresee any problems with keeping the data current? Explain.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started