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
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
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
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…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON