PRIMARY KEY based on data Data is maintained as shown to keep track of all the services performed on different properties. PropertyID PropertyName PropertyType Street P001 Eastlake Building Office 123 East Lake Ct. City Fairfax State Zip ServiceDate P002 Elm Street Apt Apartments 546 Elm Street P001 Eastlake Building Office 123 East Lake Ct. P003 Fairfax Arts Center Commercial 123 Main Plaza POGZ Elm Street Apt Apartments P004 Roberts Household Residential Herndon Fairfax Reston 546 Elm Street Herndon 456 Old Woods Road Burke VA 22129 VA 22099 VA 22029 VA 22153 VA 22099 VA 22015 Description 5/1/2011 Lawn Mow 5/6/2011 Lanscape 5/7/2011 Lawn Mow 5/3/2011 Garden Service 5/12/2011 Lawn Mow 5/12/2011 Garden Service Amount $90 $530 $60 $230 $80 $190 Each property is uniquely identified by PropertyID. As seen, the same property is serviced multiple times each on a different date. No property is serviced twice on the same date. Given the data and above information, which ONE would be best option for a primary key? ○ PropertyID O Composite of (PropertyID, Service Date) O Composite of (PropertyName, ServiceDate) ○ Amount

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Question
PRIMARY KEY based on data
Data is maintained as shown to keep track of all the services performed on different properties.
PropertyID PropertyName
PropertyType Street
P001
Eastlake Building
Office
123 East Lake Ct.
City
Fairfax
State
Zip
ServiceDate
P002
Elm Street Apt
Apartments 546 Elm Street
P001
Eastlake Building
Office
123 East Lake Ct.
P003
Fairfax Arts Center Commercial
123 Main Plaza
POGZ
Elm Street Apt
Apartments
P004
Roberts Household Residential
Herndon
Fairfax
Reston
546 Elm Street
Herndon
456 Old Woods Road Burke
VA 22129
VA 22099
VA 22029
VA 22153
VA 22099
VA 22015
Description
5/1/2011 Lawn Mow
5/6/2011 Lanscape
5/7/2011 Lawn Mow
5/3/2011 Garden Service
5/12/2011 Lawn Mow
5/12/2011 Garden Service
Amount
$90
$530
$60
$230
$80
$190
Each property is uniquely identified by PropertyID.
As seen, the same property is serviced multiple times each on a different date. No property is serviced twice on the same date.
Given the data and above information, which ONE would be best option for a primary key?
○ PropertyID
O Composite of (PropertyID, Service Date)
O Composite of (PropertyName, ServiceDate)
○ Amount
Transcribed Image Text:PRIMARY KEY based on data Data is maintained as shown to keep track of all the services performed on different properties. PropertyID PropertyName PropertyType Street P001 Eastlake Building Office 123 East Lake Ct. City Fairfax State Zip ServiceDate P002 Elm Street Apt Apartments 546 Elm Street P001 Eastlake Building Office 123 East Lake Ct. P003 Fairfax Arts Center Commercial 123 Main Plaza POGZ Elm Street Apt Apartments P004 Roberts Household Residential Herndon Fairfax Reston 546 Elm Street Herndon 456 Old Woods Road Burke VA 22129 VA 22099 VA 22029 VA 22153 VA 22099 VA 22015 Description 5/1/2011 Lawn Mow 5/6/2011 Lanscape 5/7/2011 Lawn Mow 5/3/2011 Garden Service 5/12/2011 Lawn Mow 5/12/2011 Garden Service Amount $90 $530 $60 $230 $80 $190 Each property is uniquely identified by PropertyID. As seen, the same property is serviced multiple times each on a different date. No property is serviced twice on the same date. Given the data and above information, which ONE would be best option for a primary key? ○ PropertyID O Composite of (PropertyID, Service Date) O Composite of (PropertyName, ServiceDate) ○ Amount
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON