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.

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.

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.

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.

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.

Case Study 1 (Hundreds of millions of social media accounts compromised by data breach) Published on August 18, 2020.

Security researchers have discovered an exposed database online which contains scraped data from the social media profiles of nearly 235m social media users. For those unfamiliar with the practice, web scraping is an automated technique used to gather data from websites that is often employed by analytics firms who use it to create large databases of user information. Although the practice is legal, it is strictly prohibited by social media companies as it puts the privacy of their users and their data at risk.

Comparitech's lead researcher Bob Diachenko discovered three identical copies of the exposed database online at the beginning of August. After examining the database, Diachenko and his team learned that it belonged to a company called Deep Social which has shut down its operations. When the team reached out to the now-defunct company, its request was forwarded to a Hong Kong based firm called Social Data. While Social Data denied having any connection to Deep Social, the firm did acknowledge the breach and was able to secure the exposed database with a password.

Q1. While scraping user data from social media sites is not illegal, failing to secure this data after it has been collected poses a serious risk to the affected users as cybercriminals could use the information from the database to target them online. What are your recommendations to the online risk policy makers as you think it is a breach of PII (Personal Identifiable Information). Justify your answer. Explain the need for cybersecurity experts in such a case scenario. [5 marks + 4 marks + 1 mark for Referencing Style = 10 marks]

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)

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

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?

An unknown compound contains 38.7 % calcium, 19.9 % phosphorus and 41.2 % oxygen. What is the empirical formula of this compound?

A. Ca2PO4

B. Ca3PO6

C. Ca4P2O4

D. Ca3P2O8 (or Ca3(PO4)2)

E. CaPO4