What four elements make up an expression in Microsoft access database? What is a good way to remember them? Why? Please give an example.

Database Question

Create two entities for Online Journalists business.

Each entity must have 5 attributes and explain the type of each attribute.

Please Provide the answers and Solution for this question.

Question One

The financial records of Manchester Corporation were destroyed by fire at the end of 2017. Fortunately, the controller had kept the following statistical data related to the income statement and the balance sheet in addition to the published balance sheet of the year 2017:

• The beginning merchandise inventory was $92,000 and decreased 20% during the current year.
• Sales discounts amount to $17,000.
• Interest expense was $20,000.
• The income tax is $106,000.
• Cost of goods sold amounts to $500,000.
• Administrative expenses are 18% of cost of goods sold but only 8% of gross sales.
• 4/5 of the operating expenses relate to sales activities.

During the year 2018, the company had the following transactions.                                                                                             

1. Manchester Corporation sold part of its investment portfolio for $15,000 and this transaction resulted in a gain of $3,400 for the firm. The company classifies its investments as non-trading equity.
2. A tract of land was purchased for $18,000 cash.
3. Long-term notes payable in the amount of $16,000 were retired before maturity by paying $16,000 cash.
4. An additional $20,000 in ordinary shares were issued at par.
5. Dividends totaling $8,200 were declared and paid to shareholders.
6. Depreciation expense of year 2018 is $11,000.
7. Land was purchased through the issuance of $30,000 in bonds.
8. At December 31, 2018, Cash was $32,000, Accounts Receivable (net) was $41,600, and Accounts Payable remained at $30,000.

The financial position statement of the year 2017.

Instructions:                                                                                  

1. Prepare an Income statement for 2018 and EPS.
2. Prepare a retained earnings statement for 2018.
3. Prepare a statement of financial position as it would appear at December 31, 2018.
4. Prepare a statement of cash flows for 2018.
5. Critically evaluate the rationale for the statement of financial position; income statement; and statement of cash flow.
6. What is the indication for EPS?

The financial records of Manchester Corporation were destroyed by fire at the end of 2017. Fortunately, the controller had kept the following statistical data related to the income statement and the balance sheet in addition to the published balance sheet of the year 2017:

• The beginning merchandise inventory was $92,000 and decreased 20% during the current year.
• Sales discounts amount to $17,000.
• Interest expense was $20,000.
• The income tax is $106,000.
• Cost of goods sold amounts to $500,000.
• Administrative expenses are 18% of cost of goods sold but only 8% of gross sales.
• 4/5 of the operating expenses relate to sales activities.

During the year 2018, the company had the following transactions.                                            

1. Manchester Corporation sold part of its investment portfolio for $15,000 and this transaction resulted in a gain of $3,400 for the firm. The company classifies its investments as non-trading equity.
2. A tract of land was purchased for $18,000 cash.
3. Long-term notes payable in the amount of $16,000 were retired before maturity by paying $16,000 cash.
4. An additional $20,000 in ordinary shares were issued at par.
5. Dividends totaling $8,200 were declared and paid to shareholders.
6. Depreciation expense of year 2018 is $11,000.
7. Land was purchased through the issuance of $30,000 in bonds.
8. At December 31, 2018, Cash was $32,000, Accounts Receivable (net) was $41,600, and Accounts Payable remained at $30,000.

The financial position statement of the year 2017.

Instructions:                                                                                                                                    

1. Prepare an Income statement for 2018 and EPS.
2. Prepare a retained earnings statement for 2018.
3. Prepare a statement of financial position as it would appear at December 31, 2018.
4. Prepare a statement of cash flows for 2018.
5. Critically evaluate the rationale for the statement of financial position; income statement; and statement of cash flow.
6. What is the indication for EPS?

A systems developer needs to provide machine-to-machine interface between an application and a database server in the production environment. This interface will exchange data once per day. Which of the following access control account practices would BEST be used in this situation?

A.Establish a privileged interface group and apply read -write permission.to the members of that group.

B.Submit a request for account privilege escalation when the data needs to be transferred

C.Install the application and database on the same server and add the interface to the local administrator group.

D.Use a service account and prohibit users from accessing this account for development work

A marketing director of a soft drink company wants to know what proportion of its potential U.S. customers have heard of a new brand. The company has access to a database with the mobile phone numbers of 10,000 U.S. college students. The director’s assistant asks a simple random sample of 50 students from this database whether they heard of the new soft drink brand, and constructs the sample proportion. 1 (a) What is the target population? (b) What is the sampled population? (c) Will the sample proportion be unbiased for the proportion in the sampled population? Explain. (d) Will the sample proportion be unbiased for the proportion in the target population? Explain.

A new hospital is preparing to open. They want to ensure that, when it is time to report on the national quality measures to The Joint Commission, the data flows properly.

Assist in creating the data dictionary for the following data elements to be reported by noting the correct format and allowable values.
Identify and use the appropriate source document for this information.
Admission date
Discharge disposition
Sex
Race
Hispanic
Payment source

Objective: Apply knowledge of database architecture and design

Assessment: Student will apply knowledge of database architecture and design by formatting a data dictionary to the standardization of internal and external forces to meet the needs of the enterprise.

1. These three terms all refer to the same part of a database: True or False

• Instance
• Row
• Field

  2. When compared to File Processing systems, select each of the following that are advantages of a database system. Note: there may be more than one right answer.

  Group of answer choices;

  A. Shorter development times.

  B. If the data structure changes, a program may not need to be changed.

  C. The data does not need to be duplicated.

  D. There is very little if any program-data dependence

• 3. Describe the difference between a logical data model and a physical data model.

(TCO F) A chain of fitness centers with 25 locations throughout the Southwest currently maintains several different operational databases. At corporate headquarters, the marketing department maintains a marketing database with information on advertising, e-mail promotions, and inquiries from prospective customers; and the accounting department maintains a financial database for budgets, accounts receivable, accounts payable, and general ledger. Each location maintains its own records of members, subscription payments, and member visits to the location. Propose at least three ways in which this organization could benefit from adopting an enterprise data warehouse.