Vehicle Theft Database

• 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 with keeping the data current? Explain what you would do to prevent this from occurring.

.awasam-promo {
background-color: #9ED5EA;
color: white;
text-align: center;
padding: 10px;
}

.button {
background-color: #4CAF50;
border: none;
color: white;
padding: 10px 20px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 2px;
cursor: pointer;
border-radius: 10px;
}

.awasam-alert {
color: red;
}

The post Vehicle Theft Database appeared first on Savvy Essay Writers.

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational