Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design And Implementation

Authors: David M. Kroenke

5th Edition

B000CSIH5A, 978-0023668814

More Books

Students also viewed these Databases questions