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?

Assume that the population of a town obeys Malthusian growth. Assume that the size of the population was 2000 in year 1900, and 50 000 in year 1950.

(a) Find the value of the growth constant k.
(b) How long does it take for the population to grow by 20%?
(c) How big was the population in year 2000?
(d) What was the rate of change of the population in year 2000?
(e) Calculate the size of the population in year 2001, and from that the actual change in population during the one year, from 2000 to 2001.
(f) Explain why the two values calculated in (d) and (e) above do not necessarily have to be the same.

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.

1.Which of the following is NOT correct regarding​ browser-based database​ applications?

A.​Browser-based applications are​ thin-client applications.

B.​Browser-based applications are​ thick-client applications.

C.JavaScript is the standard language for​ user-side processing.

D.Languages like​ C# and Java are used for​ server-side processing.

E.​Forms, reports, and queries are displayed and processed using html.

2.When the data model is converted to a​ database, which object on the model will become a column or fields in the​ table?

A.Attributes

B.Identifier

C.Integrity constraint

D.Record

E.Entity

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.

The IT Director at the Regional Economic Studies Institute (RESI), an economic and policy analysis/research group at Towson University, learned that you are taking a database management system class this fall, and she decided to hire you as a DBA. They would like to design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., ‘Texas’, ‘New York’, ‘California’) and include the Region of the state (whose domain is {‘Northeast’, ‘Midwest’, ‘Southeast’, ‘Southwest’, ‘West’}). Each CONGRESS_PERSON in the House of Representatives is described by his or her Name, plus the District represented, the Start_date when the congressperson was first elected, and the political Party to which he or she belongs (whose domain is {‘Republican’, ‘Democrat’, ‘Independent’, ‘Other’}). The database keeps track of each BILL (i.e., proposed law), including the Bill_name, the Date_of_vote on the bill, whether the bill Passed_or_failed (whose domain is {‘Yes’, ‘No’}), and the Sponsor (the congressperson(s) who sponsored—that is, proposed—the bill). The database also keeps track of how each congressperson voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}). Your first task is on the job is to draw an ER diagram for this application. State clearly any assumptions you make.