Consider the database of a car rental company that contains three tables drivers, cars and reservation tables.

Drivers:                                           Reservation:                              Cars:

1. Write DDL statements to create the tables

Drivers(Dno, Dname, age)

Reservation(Dno, Cno, Day)

Cars(Cno, Cmake, Color)

Where:

• no field could be empty except the age of the Driver.
• The company does not own more than one car from one maker     
• the colors of the cars should not be other than the following group (blue, white, red , green)

2. Write Queries for the following:
   1. Insert the sample data shown above into the tables

3. Write Queries for the following:
   1. Find the names of drivers who have reserved car no 103.
   2. Find the names of Drivers who have reserved red or Green cars.( use IN, UNION, =SOME/=ALL, and JION    each in separate query)For this segment, 4 responses are required, using the operations shown in parentheses
   3. Find the driver Dno of drivers with age over 20 who have not reserved a read car.
   4. Find the names of drivers who have reserved all cars.
   5. List the name of the drivers along with the day they rent cars in descending order
   6. List the name of the drivers whom rent more than 3 times along with the number of the times.
   7. Change the age of Alice to 18 years old
   8. Delete the information of the drivers younger than 20 years old

Python/Thonny - In an office chair store, 3 types are sold: basic, standard and luxury. In addition there are normal customers and frequent customers. The price of the chairs is: Basic $ 700.00 each Standard $ 900.00 each Luxury $ 1,500.00 each The store owner has decided to give a 20% discount to frequent customers. In addition, it has decided to apply the following wholesale discount policy to normal customers: If your purchase is> = $ 10,000 and <$ 20,000 a 10% discount if your purchase is> = $ 20,000 a 15% discount Write a program that asks the type of chair, the type of customer and the quantity to buy (suppose that only one type of chair is to be purchased) and calculate and show: the price before applying discount, the amount of money granted by discount and The total to be paid by the customer.

CASE #1: COCA COLA

The Coca-Cola company started 110 years ago as a small, insignificant one man business. Since then, it has grown into one of the largest companies in the world. The first chairman of the company was Dr. John Pemberton and the current chairman is Muhtar Kent. The demand for this product has made this company into a 50 billion dollar business.

Coca-Cola was invented by Dr. John Pemberton, an Atlanta pharmacist. He concocted the formula in a three legged brass kettle in his backyard on May 8, 1886 by mixing lime, cinnamon, coca leaves, and the seeds of a Brazilian shrub. (Things Go Better With Coke 14). Coca-Cola, as he called the beverage, made its debut in Atlanta's largest pharmacy, Jacob's Pharmacy, as a five cent non- carbonated drink. Later on, the carbonated water was added to the syrup to make the beverage that we know today.

Coca-Cola was named by Frank Robinson, one of Pemberton's close friends. Pemberton, in a state of poor health and in debt, was forced to sell a portion of the company to Asa Candler. In time, Candler acquired the whole company for $2,300.

Candler achieved a lot during his time as owner of the company. On January 31,

1893, the famous Coca-Cola formula was patented. He aggressively advertised Coca-Cola in newspapers and on billboards. In the newspapers, he would give away coupons for a free Coke at any fountain. Coca-Cola was sold to Ernest Woodruff in 1919 for 25 million dollars. He gave control of Coca-Cola to his son, Robert Woodruff, who would be president for six decades.

Woodruff introduced the six bottle carton in 1923. He also made Coca-Cola available through vending machines in 1929. That same year, the iconic Coca- Cola bell glass was made available. He started advertising on the radio in the 1930s and on television in 1950.

Currently Coca-Cola is advertised on over five hundred TV channels around the world. Often considered the best known trademark in the world, Coca-Cola is sold in about one hundred and forty countries to 5.8 billion people in eighty different languages. This is why Coca-Cola is the largest soft drink company in the world. Coca-Cola is worth more than 58 billion dollars on the stock market (Coca-Cola, The Coca-Cola Company 232).

For more than 65 years, Coca-Cola has been a sponsor of the Olympics. One way to see all of the achievements of the Coca- Cola company is to visit the World of Coke in Atlanta. It houses a collection of memorabilia, samples of the products, exhibits, and many other interesting items.

Cost of production of coke is very low because it is nothing but water mixed with some sweetener and color. Demand for coke is growing. Rich and poor, young and old, everyone likes Coca Cola.  

CASE #2: EXXON MOBIL CORPORATION

Over the last 125 years ExxonMobil has evolved from a regional marketer of kerosene in the U.S. to the largest publicly traded petroleum and petrochemical enterprise in the world. Today it operates in most of the world's countries and is best known by the familiar brand names: Exxon, Esso and Mobil. The company makes the products that drive modern transportation, power cities, lubricate industry and provide petrochemical building blocks that lead to thousands of consumer goods.

Exxon Mobil Corporation engages in the exploration and production of crude oil and natural gas, and manufacturing of petroleum products, as well as transportation and sale of crude oil, natural gas, and petroleum products. The company manufactures and markets petrochemicals, including olefins, aromatics, polyethylene and polypropylene plastics, and other specialty products. It also has interests in electric power generation facilities.

As of December 31, 2011, the company operated 37,692 gross and 31,683 net operated wells. Exxon Mobil Corporation has a strategic agreement with the Rosneft Oil Company for investment into oil and gas fields in the Russian

Federation. The company has operations in the United States, Canada, South America, Europe, Africa, Asia, and Australia/Oceania. Exxon Mobil Corporation was incorporated in 1882 and is based in Irving, Texas.

Finding, drilling, refining, shipping and selling to customers all contribute to the cost of gasoline. It is costly to produce and supply.

Gasoline is the main product that Exxon Mobil markets throughout the world, and is very important for the modern world. In addition to being used by cars, trucks, tractors, ships, planes, and many other vehicles, it is also used to run many mills and factories, and in many power plants to generate electricity. We know that we have limited supplies of oil and one day we shall run out of the gasoline derived from it. Yet, we pay roughly the same price for a liter of gasoline as we pay for a liter of coca cola.

As far as demand for petrol goes, most of the petrol is used to run cars. In order to own and run a car there are some restrictions. A driver has to be an adult and must have a driving license. Petrol is also sold from specially designed petrol pumps which are costly to build and operate. In contrast, Coke is sold everywhere and can be bought by anyone. One does not have to be an adult or owner of a car to buy coke.

Comparative Questions

What is the price elasticity of demand for gasoline? Is it elastic or inelastic? How about carbonated beverages?

What is the Income Elasticity of demand for carbonated beverages and gasoline? Which one has the higher elasticity?

A suburban hotel derives its revenue from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. Below is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income and number of rooms occupied.

1. Choose the scatter diagram that best fits the data.

• Scatter diagram 1

• Scatter diagram 2

• Scatter diagram 3

2. Determine the coefficient of correlation between the two variables. (Round your answer to 3 decimal places.)

Pearson correlation _____

1. c-1. State the decision rule for 0.01 significance level: H₀: ρ ≤ 0; H₁: ρ > 0. (Round your answer to 3 decimal places.)

Reject H0 if T> _____

1. c-2. Compute the value of the test statistic. (Round your answer to 2 decimal places.)

Value of the test statistic _________

1. c-3. Is it reasonable to conclude that there is a positive relationship between revenue and occupied rooms? Use the 0.01 significance level.

______ H0, it ______ reasonable to conclude that there is a positive relationship between revenue and occupied rooms.

4. What percent of the variation in revenue in the restaurant is accounted for by the number of rooms occupied? (Round your answer to 1 decimal place.)

_____ % of the variation in revenue is explained by variation occupied rooms.

prepare the following journal entries:

1) The company sold (5) payroll service packages, covering 6 months of fully automated payroll service for $6,000 each. The regular price was $6,500 each, but the customers received a discount for paying for the service up front. Each company will receive 2 payroll runs per month. One on the 15th and one on the 30th of each month.

2) The company provided $5,600 of tax consulting services to clients on account.

3) The company ran its first payroll service for two of the companies. The other three companies were not yet ready to begin running payroll.

4) The company paid $2,100 cash for two weeks salary earned by two employees.

5) The company purchased $950 for October advertising on account.

6) The company provided $8,200 of tax services to clients and received payment.

7) The company paid a $687 electic bill for October utilities.

8) The company collected $2,000 from clients that were provided service on account on the 13th.

9) The company paid 1/2 of the bill for paper and supplies that was purchased on the 8th.

10) The company paid $2,100 cash for two weeks salary earned by two employees.

11) The company ran payroll service for all five companies that purchased service in October. 30 The company paid dividends of $700.

12) An employee and received a $300 advance for November travel for the company.

Use the “home” data to build a regression model that predicts market as a function of square feet. Give a 99% confidence interval for the value of one square foot. (select the closest answer)

Use the “home” data to build a regression model that predicts market as a function of square feet. Is the coefficient for square feet significant at a .05 level?

A normally distributed population has a mean of 71 and a standard deviation of 15. Determine the probability that a random sample of size 37 has an average between 74 and 78.

Round to four decimal places.

The length of time needed to complete a certain test is normally distributed with mean 77 minutes and standard deviation 11 minutes. Find the probability that it will take between 74 and 80 minutes to complete the test.