Questions
1.Which of the following is NOT correct regarding​ browser-based database​ applications? A.​Browser-based applications are​ thin-client applications....

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

In: Computer Science

The IT Director at the Regional Economic Studies Institute (RESI), an economic and policy analysis/research group...

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.

In: Computer Science

You are volunteering for a local children's softball league. They asked you to create an app...

You are volunteering for a local children's softball league. They asked you to create an app or a Web application to help in their operations. You decide to create a database. The league consists of several teams. Players are assigned to teams at the start of the season. It also collects parents' contact information, and charges season and optional equipment rental fees. League volunteers include officials, referees, coaches, and first aid attendants. Parents also volunteer to help at individual practices and games. The teams meet for regular practices at several ballparks at public parts; practices are scheduled, and permits are obtained from the city. Regular season and playoff games are scheduled at some or all of these ballparks; results and player statistics are collected.

For the first draft of your system:

1) Identify business rules your design will capture.

2) Identify entities, keys, and constraints. Create an ER diagram (format and software package up to you). You can also design your database directly in terms of DB tables. (one possible tool: https://sqldbm.com/Home/ ).

3) Based on ER model, design a database (skip this step if your design is already in DB-specific terms). Suggest foreign key constraints and indexes.

4) Is your design in 3rd Normal Form. If so, explain. If it is not, revise your design until it is in 3NF.

5) Generate or write SQL DDL statements that create your database objects.

In: Computer Science

which of the following would not be an appropriate use case name? a)Make Appointment b)Create Account...

which of the following would not be an appropriate use case name?

a)Make Appointment

b)Create Account

c)Update master file

d)Subtract Deductions from Gross pay.

In: Computer Science

Gen. Robert E. Lee's Boyhood Home is for Sale The historic Virginia home that Confederate Gen....

Gen. Robert E. Lee's Boyhood Home is for Sale

The historic Virginia home that Confederate Gen. Robert E. Lee grew up in hit the market (in April 2018) for $8.5 million. (Trapasso, C.)

Robert E. Lee's father Henry rented the home in 1812, according to The Washington Post. The family lived there for over 80 years, including Robert E. Lee from age five to when he went to West Point in 1825. He again visited five years after the Civil War ended, The Post reported. (Leayman, E.)

The home's other claim to fame is that President George Washington also dined and lodged there before the Lee family moved in. (Trapasso, C.)

Built in 1795, the brick house was listed on the National Register of Historic Places in 1986. (Trapasso, C.)

The home had been used as a residence until 1966. The Stonewall Jackson Memorial Foundation purchased the home and opened it to the public. Unable to make ends meet, the foundation sold the home in 2000 to Mark and Ann Kington for $2.5 million. (Trapasso, C.)

The boyhood home of Robert E. Lee in Alexandria was listed on the market with a significant price drop. Previously priced at $8.5 million, the six bedroom is available for $6.2 million (March 2019). (Leayman, E.)

  1. Calculate the annual compound growth rate of the house price since the house was sold to Mark and Ann Kington (since 2000) until the house was listed for sale at a reduced price in 2019. (Round the number of years to the whole number). Please show your work.
  2. Assume that the growth rate you calculated in question #1 remains the same for the next 30 years. Calculate the price of the house in 30 years after it was listed at a reduced price in 2019. Please show your work.
  3. Assume that the growth rate you calculated in question #1 remains the same since Robert E. Lee's father Henry rented the home in 1812. Calculate the price of the house in 1812. (Round the number of years to the whole number). Please show your work.
  4. Assume the growth rate that you calculated in #1 prevailed since 1795. Calculate the price of the house in 1795. (TIP: To get the answer correctly you need to use the price of the house in your calculations in dollars with all zeros). Please show your work.
  5. You were using the time value of money concept to answer question #4. Think about the time line for that problem. What is the time point 0 in that problem? Please explain your answer.
  6. In April 2018, the listed price of the house was $8.5 million. Calculate the annual compound growth rate of the house price since the house was sold to Mark and Ann Kington (since 2000) until the house was listed for sale in 2018. Compare with your answer to the question #1.
  7. Using the growth rate from question #6, calculate the price of the house in 1812. (Round the number of years to the whole number). Please show your work. Compare with your answer to the question #3.

In: Finance

Gen. Robert E. Lee's Boyhood Home is for Sale The historic Virginia home that Confederate Gen....

Gen. Robert E. Lee's Boyhood Home is for Sale

The historic Virginia home that Confederate Gen. Robert E. Lee grew up in hit the market (in April 2018) for $8.5 million. (Trapasso, C.)

Robert E. Lee's father Henry rented the home in 1812, according to The Washington Post. The family lived there for over 80 years, including Robert E. Lee from age five to when he went to West Point in 1825. He again visited five years after the Civil War ended, The Post reported. (Leayman, E.)

The home's other claim to fame is that President George Washington also dined and lodged there before the Lee family moved in. (Trapasso, C.)

Built in 1795, the brick house was listed on the National Register of Historic Places in 1986. (Trapasso, C.)

The home had been used as a residence until 1966. The Stonewall Jackson Memorial Foundation purchased the home and opened it to the public. Unable to make ends meet, the foundation sold the home in 2000 to Mark and Ann Kington for $2.5 million. (Trapasso, C.)

The boyhood home of Robert E. Lee in Alexandria was listed on the market with a significant price drop. Previously priced at $8.5 million, the six bedroom is available for $6.2 million (March 2019). (Leayman, E.)

  1. Calculate the annual compound growth rate of the house price since the house was sold to Mark and Ann Kington (since 2000) until the house was listed for sale at a reduced price in 2019. (Round the number of years to the whole number). Please show your work.
  2. Assume that the growth rate you calculated in question #1 remains the same for the next 30 years. Calculate the price of the house in 30 years after it was listed at a reduced price in 2019. Please show your work.
  3. Assume that the growth rate you calculated in question #1 remains the same since Robert E. Lee's father Henry rented the home in 1812. Calculate the price of the house in 1812. (Round the number of years to the whole number). Please show your work.
  4. Assume the growth rate that you calculated in #1 prevailed since 1795. Calculate the price of the house in 1795. (TIP: To get the answer correctly you need to use the price of the house in your calculations in dollars with all zeros). Please show your work.
  5. You were using the time value of money concept to answer question #4. Think about the time line for that problem. What is the time point 0 in that problem? Please explain your answer.
  6. In April 2018, the listed price of the house was $8.5 million. Calculate the annual compound growth rate of the house price since the house was sold to Mark and Ann Kington (since 2000) until the house was listed for sale in 2018. Compare with your answer to the question #1.
  7. Using the growth rate from question #6, calculate the price of the house in 1812. (Round the number of years to the whole number). Please show your work. Compare with your answer to the question #3.

In: Finance

Good                    Quantity              Price in 1999      

  1. Good                    Quantity              Price in 1999                     Price in 2000

X                            10                          $5                                         $6

Y                            20                          $10                                      $10

Z                            5                            $6                                         $10

Assume year 2000 is the base year.

  1. Calculate the market basket value for each year. What is the consumer price index in 1999?
  2. What is the inflation rate between 1999 and 2000?

Show all calculations please.

In: Economics

Combustion of 135.2 g of a compound produces 440.0 g CO2 and 135.0 g H2O. The...

Combustion of 135.2 g of a compound produces 440.0 g CO2 and 135.0 g H2O. The molar mass of the compound is 270 g/mol. Determine the empirical and molecular formula of the hydrocarbon (show all work)

In: Chemistry

A 0.7221g sample of a new compound has been analyze and found to contain the following...

A 0.7221g sample of a new compound has been analyze and found to contain the following masses of elements : Carbon 0.2990g, hydrogen 0.05489g, nitrogen 0.2318g, and Oxygen 0.1328g.
call ate the empirical formula of the compound

In: Chemistry

Use the empirical rule to solve the problem. The amount of jen's monthly phone bill is...

Use the empirical rule to solve the problem. The amount of jen's monthly phone bill is normally distributed with a mean of $55 and a standard deviation of $12. What percentage of her phone bills are between $19 and $9?

In: Statistics and Probability