1. Fortunately, once an application that accesses a database is tuned for optimal relational access to the data, there is never any performance degradation after that.

.True

.False

2 Monitoring a database system for performance management purposes means to watch the system as it runs, paying particular attention to statistics gathered by the RDBMS

. True

. False

3. RDBMS, in general, during normal operational use, use _______________ cache(s). Choose the best answer

a. exactly two

b. no

c. a number of

d. exactly one

4. Indexes can be used to avoid having the RDBMS sorted returned data.

. True

. False

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to 3 coaches (offensive, defensive, and physical training coaches). During the season, each team plays 2 games (home and visitor) against each of the other teams. Given those conditions, do the following:

• Draw the Chen and Crow’s Foot ERDs to represent the JCBC database.

• Draw the UML class diagram to depict the JCBC database.

Compare the strengths and weaknesses of SQL and NoSQL Databases.

1. What´s the meaning of each and how they work and store data. 2. In which scenarios is better to use one or the other. 3. What are the different types of SQL and NoSQL Databases. 4. What are the advantages of NoSQL over traditional SQL Databases. 5. When to use a NoSQL database instead of a relational database? 6. Which one is more scalable and flexible and in which scenarios. 7. Explain the use of transactions in SQL and NoSQL Databases. 8. Provide good examples on each. 9. Provide a good conclusion.

Perfect Pizza is a pizza delivery and pick up shop. They are hiring you to create a database designed to track their customers, employees, products, and orders. Their needs are outlined below. They want to use the customer’s telephone number to identify the customer. They are interested in households, not individuals. They need the street address and zip code for delivery. They only deliver to the following zip codes: 29572, 29575, 29577, 29578, 29579, and 29588. Since all zip codes are in the Myrtle Beach area, they would like that information auto filled for the city and state, but want the option to enter other cities and states due to pick up orders from tourists. They also need an order detail table to store the price charged. They need to be able to change the price charged for two reasons: it may be different than product price due to a discount or special allowance and it will keep a historic record of the price. That way, when they are updating a product in the product table, it doesn’t affect the prices charged in past sales.

1) Make a list of Entities you feel this database needs and give an explanation for your reasoning behind each one. 2) For each of the entities you listed above, list the attributes you feel need to be included in each of those entities. 3) Identify the attribute that would be designated as the primary key in each entity. 4) Make a list of questions you would ask to help you better design the database. (Must be at least 5 questions) 5) Make a list of suggestions for the pizza shop owners to improve the database. (Must be at least 3 suggestions)

Perfect Pizza is a pizza delivery and pick up shop. They are hiring you to create a database designed to track their customers, employees, products, and orders. Their needs are outlined below. They want to use the customer’s telephone number to identify the customer. They are interested in households, not individuals. They need the street address and zip code for delivery. They only deliver to the following zip codes: 29572, 29575, 29577, 29578, 29579, and 29588. Since all zip codes are in the Myrtle Beach area, they would like that information auto filled for the city and state, but want the option to enter other cities and states due to pick up orders from tourists. They also need an order detail table to store the price charged. They need to be able to change the price charged for two reasons: it may be different than product price due to a discount or special allowance and it will keep a historic record of the price. That way, when they are updating a product in the product table, it doesn’t affect the prices charged in past sales. 1) Make a list of Entities you feel this database needs and give an explanation for your reasoning behind each one. 2) For each of the entities you listed above, list the attributes you feel need to be included in each of those entities. 3) Identify the attribute that would be designated as the primary key in each entity. 4) Make a list of questions you would ask to help you better design the database. (Must be at least 5 questions) 5) Make a list of suggestions for the pizza shop owners to improve the database. (Must be at least 3 suggestions)

A local credit union offers car loans to customers on a regular basis. Unfortunately, the credit union ends up repossessing an average of 20 cars per month. Once the cars are repossessed, the credit union sells them to individual buyers to recoup some of their losses.

The cars are placed in a secure parking lot; where potential buyers are invited to inspect the cars. To find out which cars are available each month, potential buyers subscribe to a mailing list. If the car looks good, the buyer puts in a bid to the credit union via email. The highest bid wins the car.

The credit union has been doing the paperwork for these transactions by hand, but now want a computerized system. Because you have knowledge in database development and Microsoft Access, you have been hired to create a database for the monthly auction.

Using the database design rules covered in class, list each rule. Then provide specific details when appropriate as you develop the auction database. When you are finished, I should be able to see the tables, fields, datatypes, primary keys, foreign keys, and relationships.

Consider the following.

- When the bank repossesses a car, an employee records the year, make and model of the car, the mileage, color and VIN number

- Potential customer information is also recorded; name, address, gender, phone number and email address.

- Finally, the bank needs to have some way of recording the bids that come in. Customers send in their bids on specific cars. The bids are recorded and the date is noted.

Garda World Security Corporation has the following shares, taken from the equity section of its balance sheet dated December 31, 2020.

*All shares were issued during 2018.

During its first three years of operations, Garda World Security Corporation declared and paid total dividends as shown in the last column of the following schedule.

Required:
Part A
1. Calculate the total dividends paid in each year to the preferred and to the common shareholders.

Total Dividend 2018$ 170,000

2019 $410,000

2020 $570,000

2. Calculate the dividends paid per share to both the preferred and the common shares in 2020. (Round the final answers to 2 decimal places.)

Part B
1. Calculate the total dividends paid in each year to the preferred shares and to the common shareholders assuming preferred shares are cumulative.

Total for three years$1,150,000

Total Dividend 2018$ 170,000

2019 $410,000

2020 $570,000

2. Calculate the dividends paid per share to both the preferred and the common shares in 2020 assuming preferred shares are cumulative. (Round the final answers to 2 decimal places.)

On January 1, 2017, Bonduris Company leases warehouse space in Oakland, CA. The lease is for six years with payments to be made at the beginning of each year. The lease calls for Bonduris to pay $15,000 on January 1, 2017. The lease calls for subsequent rent payments to increase 10% per year. For example, the January 1, 2018 payment will be $16,500, and the January 1, 2019 payment will be $18,150. Bonduris has adopted early ASC 842 and has appropriately classified the lease as an operating lease. Bonduris has a calendar reporting year and an incremental borrowing rate of 7%. Bonduris uses straight-line amortization for its long-lived assets. Ignore current and non currrent classification for this exercise. Use tables (PV of 1, PVAD of 1, and PVOA of 1) (Use the appropriate factor(s) from the tables provided.)

Required:

1-What journal entries should Bonduris make at January 1, 2017, to record the effects of the lease?

2-Prepare Bonduris’s amortization table for the leased warehouse.

3-What is the balance of the lease liability on January 1, 2018, after Bonduris makes the rent payment?

4-What is the balance of the right-of-use asset on January 1, 2018, after Bonduris makes the rent payment?

A 0.1156g of an unknown compound C, H, and N compnd is analyzed by comubustion analysis and produces a 0.1638g CO2 and 0.1676g of water. In a separate experiment, the molar mass was determined to be 31 g/mol. What is its empirical formula and molecular formula?

The empirical formula of styrene is CH; the molar mass of styrene is 104.14 g/mol.
How many H atoms are present in a 4.825g sample of styrene?
___ H atoms
(Give your answer in e format. For example 12014 = 1.2014e+05)