Why business rules are important for a good database design? Give 3 examples of business rules in academic environment.

The use of cloud technology is increasing especially in health care. How does cloud technology relate to database management?

Introdyction to database

Topic SQL

Q2) what is the purpose of following statements?

SELECT DISTINCT

SELECT

DESC

AND

ORDER BY

AS

SQL is our language for relational databases - do you think it's an adequate "language" for database creation and manipulation?

SQL is our language for relational databases - do you think it's an adequate "language" for database creation and manipulation?

Which of the following is an example of an accural error?

a. failure to adjust Prepaid insurance to its proper balance at year end

b. failure to adjust Inventory to its proper balance at year end

c. failure to record depreciation at year end

d. none of the above

Please explain how you got the answer.

October 1, 2011, MarCo signs a one-year, 8% note payable for $10,000 with principle and interest due on Oct 1, 2012. It is Marco's only note outstanding. On October 1, 2012 when the note is paid, Marco debits Notes Payable and credits %10,800, the sum of principle and interest. The error is likely to be found because...

a. the bank reconciliation will be out of balance when the check clears

b. the trial balance will be out of balance by $800

c. the trial balance will show a balance in notes payable that is not normal

d. interest expense will be understated

Please explain how you got the answer.

While writing a check for $2,000 on April 25, 2012 for a computer purchased on December 25, 2011, you discover that when the purchase was made in December, the $2,000 had been credited to Notes Payable instead of Accounts Payable. If the books are closed, what single entry could you make?

a. Notes Payable 2000 (debit)

              Accounts Payable 2000 (credit)

b. Notes Payable 2000 (debit)

                Cash 2000 (credit)

c. Accounts Payable 2000 (debit)

                 Cash 2000 (credit)

d. Accounts Payable 2000 (debit)

               Notes Payable 2000 (credit)

Please explain how you got the answer.

1. The following table stores details on employees and the projects they have worked on and the hours they spent on the project each week:                                      [15 Marks]

1. Explain why the above table is not in 2^nd normal form. Then normalise it to 2^nd normal form.
2. Once the table is in 2^nd normal form, test if the result is in 3^rd normal form and explain why you think it is or is not in 3NF.

What is good data? What is meant by bad data? A term that you may have already encountered is "GIGO". This term refers to Garbage In, Garbage Out. In other words, if incorrect/bad data is entered into a database, the same useless data will be extracted. This results in poor decisions, lost revenue, and unhappy customers. Have you ever been the victim of bad data?

Discuss the importance of queries and good/bad data as they relate to database reports. Describe the impact on business of erroneous reports generated by bad data or faulty queries.

You have been tasked to design a database to support your new business. This business could be one of many possibilities such as a car dealership, Internet Sales, Graphic Design, Fitness counselor or anything you can imagine.

Describe the entities and their attributes that might be required for this application, the type of database processing required, and the application software needed.  

Pick something unique for you. Note: this doesn't have to be complex. A few entities and attributes will suffice. Just be sure, the entities make sense for your application.

Describe your business.