Vehicle theft incident.

Vehicle theft incident.

  • Imagine you are a participant in an information systems project to design a vehicle theft database for a state law enforcement agency. This 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.
  • Write your response in a Word document and include a one-paragraph response for each bullet point below.
  • · Identify 6 data attributes you would capture for each vehicle theft incident. Explain why each of these are important. 
  • · Which data attribute would you designate as the primary key?  Explain why.
    •  OK – what is a primary key in a database?  I had a hard time finding an explanation of the term that wasn’t overly technical.  Hope this helps –  A data table’s primary key is a special field in a table. Every table created in a Database (like Access – which you may or may not be familiar with, though that doesn’t matter for this assignment) you create should have a primary key field.  
       
    • Why and what is a primary key field?
  • · Each record in the table needs a piece of data that is unique to that record. No other record can have the same information – think “social security #” or a patient ID in a medical situation” – no two people will have the same value for those items.
  • · In a database, the role of the primary key field allows the data to uniquely identify each record. For example, in your Customer database table, the Customer Number (or you might call it Customer ID) would be the primary key — there is only one customer number 1, one customer number 2, and so on. Here’s part of a data table for “Spouses”….to tell one record from another a field was created called Spouse ID – no two people would have the same value for this field.
  • · You can’t use an address because more than one customer might live in the same town, state or even have a street # that is the same.  So, one field of each record needs to be totally unique – no other record can have the same data.  It could be a social security number, an employee ID number or something of that nature.
  • · Nerds pitch a fit if your database doesn’t have at least one primary key field…. yes, you can have more than one field that is unique for each record, but you only need to identify one for this assignment
  • · Predict one problem you might encounter wit

Don't use plagiarized sources. Get Your Custom Essay on
Vehicle theft incident.
Just from $7/Page
Order Essay
Calculate your paper price
Pages (550 words)
Approximate price: -
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Order your essay today and save 16% with the discount code SUMMERFEST20