Question

In: Accounting

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

In response to question 4.2 from the textbook, demonstrate your understanding of the differences in the design, applications, and usage of the relational database as compared to the use of spreadsheets.

Question 4.2 Most DBMS packages contain data definition, data manipulation, and data query languages. For each of the following, indicate which language would be used and why. A database administrator defines the logical structure of the database. The controller requests a cost accounting report containing a list of all employees being paid for more than 10 hours of overtime in a given week. A programmer develops a program to update the fixed-assets records stored in the database. The human resources manager requests a report noting all employees who are retiring within five years. The inventory serial number field is extended in the inventory records to allow for recognition of additional inventory items with serial numbers containing more than 10 digits. A user develops a program to print out all purchases made during the past two weeks. An additional field is added to the fixed-asset records to record the estimated salvage value of each asset.

Expert Solution

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 and complex, relational database is the best option.

DBMS Package

Data defination language: data defination language (DDL) is the language that builds the data dictionary, creates the database, describes logical views, and specifies record or field security constraints.

Data manipulation language: Data manipulation language (DML) is the language that changes database content including data element creations, insertion, updation and deletion.

Data query language(DQL) : Data query language is a language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and display data.

Language for the following option:

A database administrator defines the logical structure of the database.

Data defination language (DDL)- the data dictionary has to be build and the database has been created.

The controller requests a cost accounting report containing a list of all employees being paid for more than 10 hours of overtime in a given week.

Data query language (DQL)- here the data for employees who are paid for more than 10 hours overtime has to be retrived sort and then display.

A programmer develops a program to update the fixed-assets records stored in the database.

Data manipulation language (DML)- data of fixed asset has to be updated and stored

The human resources manager requests a report noting all employees who are retiring within five years.

Data query language (DQL)- data has to be sort for employee retiring within five years.

The inventory serial number field is extended in the inventory records to allow for recognition of additional inventory items with serial numbers containing more than 10 digits.

data manipulation language- the existing field has been modified by updating the inventory serial number field for having inventory with serial numbers more than 10 digits.

A user develops a program to print out all purchases made during the past two weeks.

Data query language- as the data of past two week has to retrieve and then display and print.

An additional field is added to the fixed-asset records to record the estimated salvage value of each asset.

Data defination language - an additional database has been created

ekkarill92 answered 1 year ago

This discussion question will have you demonstrate your knowledge of the medical terms, understanding of the...

This discussion question will have you demonstrate your knowledge of the medical terms, understanding of the use of nouns, pronouns, and verbs, by creating a scenario of a patient. Research a medical disease and write 2-3 paragraphs to your classmates describing your patient’s condition using 20 of the words in Section 1, 2, and 3 of the textbook under “Medical Spelling.” You must highlight these words in yellow. You will also need to highlight at least ten nouns, ten pronouns,...

1) Information for this question: You are required to demonstrate your understanding of risk and how...

1) Information for this question: You are required to demonstrate your understanding of risk and how these impact companies and therefore returns for investing in these companies. You will demonstrate your understanding of systematic and unsystematic, business and financial risks in this question. Tasks: Write your discussions in the text box provided and address the following questions. • Contrast the difference between systematic and unsystematic risks and provide an example for each. You can use a company you are familiar...

Discuss the differences between repetitive and selective statements. Use segment codes to demonstrate your understanding. Explain...

Discuss the differences between repetitive and selective statements. Use segment codes to demonstrate your understanding. Explain why you are choosing one of the following three statements in your code: a) for statement, b) while statement, c) do-while statement. Provide examples.

Answer each question by defining the term in your own words to demonstrate an understanding. Cite...

Answer each question by defining the term in your own words to demonstrate an understanding. Cite any pertinent Internal Revenue Code sections or Regulations when possible. 1. Applicable Credit Amount 2. Crummey Power 3. Unified Credit 4. Annual Exclusion 5. Net Gift 6. Disclaimer 7. Marital Deduction

The goal of this exercise is to demonstrate your understanding of the characteristics that influence the...

The goal of this exercise is to demonstrate your understanding of the characteristics that influence the choice of business ownership formation. RT Taxes: After years of preparing taxes for his extended family, Ronald began a tax consultant business from his home office. He hires assistants as needed but does all of the management and main services himself. Pet Perfect: John with an expertise in sales, and Francine, with an expertise in management, opened a pet shop together, sharing profits and...

Question Objectives: The objectives of this lab exercise are to: Demonstrate an understanding of the concept...

Question Objectives: The objectives of this lab exercise are to: Demonstrate an understanding of the concept of operator precedence in Python expressions and statements. Take simple problem descriptions and produce small but complete Python programs that solve these problems. Give you some practice in using simple Python interactive input and output capabilities. Give you some practice in the simplest Python decision statement (if). Give you some practice in the simplest Python loop statement (while). Specifications: This is a four-part exercise....

Understanding the basis of infection is essential when working in a healthcare environment. Demonstrate your understanding...

Understanding the basis of infection is essential when working in a healthcare environment. Demonstrate your understanding of the following terminology (in 20-40 words each) Terminology a. Colonisation b. Infection c. Disease

Answer the thematic question below to demonstrate your understanding of factor market structures.The table below shows...

Answer the thematic question below to demonstrate your understanding of factor market structures.The table below shows starting salaries by sports in the USA. Explain what the likely cause(s) of the observed differences in pay for men and women : Unions, discrimination, or immigration? Use your economics. Year Soccer, Women Soccer, Man NBA NFL MLB NHL 2011 0.00 32,600 442,114 375,000 414,000 500,00 2012 0.00 33,750 452,588 390,000 480,000 525,000 2013 6,000 35,125 473,604 405,000 490,000 525,000 2014 6,842 36,500 490,180...

Use this assessment as an opportunity to demonstrate the breadth of your knowledge and understanding of...

Use this assessment as an opportunity to demonstrate the breadth of your knowledge and understanding of experimental design.Respond to the following question in essay format. Approximately, three to four paragraphs or 500-550 words. G. has just completed a study that shows a correlation between the amount of time children watch television and their attention spans. Assume the correlation was r = -.34. State an experimental hypothesis based on this finding and devise a simple procedure for testing it.

Que: This question asks you to demonstrate an understanding of the work of Karl Marx as...

Que: This question asks you to demonstrate an understanding of the work of Karl Marx as covered You are to take the side of the proletariat and argue the reason(s) why a fast-food worker SHOULD be paid $15.00 per hour and You are to take the side of the bourgeoisie and argue the reason(s) why a fast food worker SHOULD NOT be paid $15.00 per hour. (The Answer need to be in soft copy only)