In response to question 4.2 from the textbook, demonstrate yourunderstanding of the differences in...

60.1K

Verified Solution

Question

Accounting

In response to question 4.2 from the textbook, demonstrate yourunderstanding of the differences in the design, applications, andusage of the relational database as compared to the use ofspreadsheets.
Question 4.2 Most DBMS packages contain data definition, datamanipulation, and data query languages. For each of the following,indicate which language would be used and why. A databaseadministrator defines the logical structure of the database. Thecontroller requests a cost accounting report containing a list ofall employees being paid for more than 10 hours of overtime in agiven week. A programmer develops a program to update thefixed-assets records stored in the database. The human resourcesmanager requests a report noting all employees who are retiringwithin five years. The inventory serial number field is extended inthe inventory records to allow for recognition of additionalinventory items with serial numbers containing more than 10 digits.A user develops a program to print out all purchases made duringthe past two weeks. An additional field is added to the fixed-assetrecords to record the estimated salvage value of each asset.

Answer & Explanation Solved by verified expert

4.3 Ratings (798 Votes)

Relational database is used in place where there is complexity in operation When multiple user has to use the same data relational database is helpful then spreadsheet Spreadsheet is for beginners or for small business Relational database is designed for large business whereas spreadsheet is designed for small business Relational database is for data subsets and complex queries also where repetitive data sequences are used Spreadsheet helps in data analysis and chart management and calculations Spreadsheet when gets bigger See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

In: AccountingIn response to question 4.2 from the textbook, demonstrate yourunderstanding of the differences in the...In response to question 4.2 from the textbook, demonstrate yourunderstanding of the differences in the design, applications, andusage of the relational database as compared to the use ofspreadsheets.Question 4.2 Most DBMS packages contain data definition, datamanipulation, and data query languages. For each of the following,indicate which language would be used and why. A databaseadministrator defines the logical structure of the database. Thecontroller requests a cost accounting report containing a list ofall employees being paid for more than 10 hours of overtime in agiven week. A programmer develops a program to update thefixed-assets records stored in the database. The human resourcesmanager requests a report noting all employees who are retiringwithin five years. The inventory serial number field is extended inthe inventory records to allow for recognition of additionalinventory items with serial numbers containing more than 10 digits.A user develops a program to print out all purchases made duringthe past two weeks. An additional field is added to the fixed-assetrecords to record the estimated salvage value of each asset.