Colonial Adventure Tours Case

• The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. (If you use a computer to complete these exercises, use a copy of the Colonial Adventure Tours database so you will still have the original data when you complete Chapter 3 exercises.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take.
• Save the file on your computer with your last name in the file name. (Example: case_1-1 _Jones.doc)
• Click the Choose File button to find and select your saved document.

1. List the name of each trip that does not start in New Hampshire (NH).
2. List the name and start location for each trip that has the type Biking.
3. List the name of each trip that has the type Hiking and that has a distance greater than six miles.
4. List the name of each trip that has the type Paddling or that is located in Vermont (VT).
5. How many trips have a type of Hiking or Biking?
6. List the trip name, type, and maximum group size for all trips that have Susan Kiley as a guide.
7. List the trip name and state for each trip that occurs during the Summer season. Sort the results by trip name within state.
8. List the name of each trip that has the type Hiking and that is guided by Rita Boyers.
9. How many trips originate in each state?
10. How many reservations include a trip with a price that is greater than $20 but less than $75?
11. List the reservation ID, customer last name, and the trip name for all reservations where the number of persons included in the reservation is greater than four.
12. List the trip name, the guide’s first name, and the guide’s last name for all trips that originate in New Hampshire (NH). Sort the results by guide’s last name within trip name.
13. List the reservation ID, customer number, customer last name, and customer first name for all trips that occur in July 2018.
14. Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the result by the number of persons included in the reservation. List the reservation ID, trip name, customer’s last name, customer’s first name, and total cost for all trips where the number of persons is greater than four.
15. Create a new table named Hiking that includes all columns in the Reservation table where the trip type is Hiking.
16. Use an update query to change the OtherFees value in the Hiking table to $5.00 for all records on which the OtherFees value is $0.00.
17. Use a delete query to delete all trips in the Hiking table where the trip date is 6/12/2018.
18. One of the reservations agents at Colonial Adventure Tours created the query shown in Figure 2-49 to list each trip name and the last name and first name of each corresponding guide. The query results included 410 records, and he knows that this result is incorrect. Why did he get so many records? What should he change in the query design to get the correct query results?

C++ language, only math equation, no code.

A Box on a slope slides under the following force F = m*g*sin(theta) - 0.2v(t). Assume m = 1kg and g=10 and theta = 30'. We want to simulate the slide using dt = 0.1 second interval. This means update frame rate is 10 per second. Initial speed is 0. After 2 seconds we like to know what is the current position and speed of the box. We want to do this using Explicit Euler(EE), Semi-Explicit Euler(SE), and Verlet Method for updating at each frame.

a) What are the update equations for EE method?

b) What are the update equations for SE method?

c) What is the update equation for Verlet method? How do you choose the initial first 2 positions in this method?

d) Provide a table showing updates per frame for each method. This means there are 3 columns, one for each method, and there are 20 rows for 20 frames to comprise 2 seconds of updates. Which method is more out of sync with the other 2 methods?

e) What is the maximum speed of decent of the box on the slope? why? (hint. Use analytical way to argue what is the maximum speed)

In C++, please build a simple Distance Vector program that will communicate with N partners and do the following. (NOTE: All connections between a server and clients should be TCP/IP socket.)

1. You will run N instances on your machine
2. Each instance will run on a different port (instance 1 will run on port 18181, instance 2 on port 18182, instance 3 on port 18183, etc)
3. The program will start by reading in the appropriate neighbors file and vector file.
4. The program will ONLY read vectors where the fromNode is equal to that node. For instance, node 1 will only read in vectors where node1 is the fromNode.
5. The program will support the following requests from clients:
   1. Show files at the server’s current directory: ‘print’
      1. This will print the current vector table on a node.
      2. ONLY print valid vectors (don’t print uninitialized ones)
   2. Download files: ‘refresh’
      1. This will force the current node to send its vector table to all its neighbors.
   3. Upload files: ‘update’

1. This will be of the form: Update fromNode toNode cost
2. Update checks that the toNode is the current node. If it is not it is ignored
3. Update then checks if the toNode-fromNode exists in vector table. If it does not it is added and neighbors are notified
4. If the pair is in the table, and if the new cost is less than the old cost, that cost is stored and the neighbors are notified.

All transaction occur in Jan 1, 2018

1- Jan 1, Jana Mohammad begins his own business with a cash investment of 150,000$.

2- Jan 10, Jana Mohammad paid 60000 cash for rent expenses

3- Jan 12, Jana Mohammad purchased for 20000 equipment she paid 2000 cash and 18000 on credit

4- Jan 12, Jana Mohammad paid 4500 cash for decoration expenses

5- Jan13,jana Mohammad purchased for 1000 supplies cash

6- Jan15, Jana Mohammad paid 500 cash for advertising expenses

7- Jan 18, Jana Mohammad purchased for 15000 car she paid 3000 cash and 12000 on credit

8- Jan 20, Jana Mohammad received 500 cash from customer for rent a lake in the shop

9- Jan 20, Jana Mohammad withdraw 300 cash from the business for her personal use

10- Jan 21, Jana Mohammad Purchased a one-year fire insurance policy for 30,000

11- Jan 22, customer rent a lake in the shop on account by 500

12- Jan 23,jana Mohammad paid 2000 cash for equipment which bought on credit (on transaction 3 )

13- Jan 24, Jana Mohammad borrowed 10,000$ by signing 5%, one-year note on february1, 2019.

14- Jan 25, Jana Mohammad paid 3000 cash salaries expenses

15- Jan 27, Jana Mohammad received 200 cash from the customer whose rent a lake on account ( transaction 11)

16- Jan 31, used shop supply during the month 600

Adjusted entry

• The equipment purchased on Jan12, 2018 is being depreciated using the straight-line method over 10 years, with a salvage value of $1,800.

• Jana Mohammad shop estimates that uncollectible accounts receivable at year-end is 300

• The short-term note is dated Jan 1, 2018, and carries a 5% interest rate.

Prepare

ADJUSTED TRIAL BALANC

AND CLOSING ENTRY

AND FINANCIAL STATMANT

All transaction occur in Jan 1, 2018

1- Jan 1, Jana Mohammad begins his own business with a cash investment of 150,000$.

2- Jan 10, Jana Mohammad paid 60000 cash for rent expenses

3- Jan 12, Jana Mohammad purchased for 20000 equipment she paid 2000 cash and 18000 on credit

4- Jan 12, Jana Mohammad paid 4500 cash for decoration expenses

5- Jan13,jana Mohammad purchased for 1000 supplies cash

6- Jan15, Jana Mohammad paid 500 cash for advertising expenses

7- Jan 18, Jana Mohammad purchased for 15000 car she paid 3000 cash and 12000 on credit

8- Jan 20, Jana Mohammad received 500 cash from customer for rent a lake in the shop

9- Jan 20, Jana Mohammad withdraw 300 cash from the business for her personal use

10- Jan 21, Jana Mohammad Purchased a one-year fire insurance policy for 30,000

11- Jan 22, customer rent a lake in the shop on account by 500

12- Jan 23,jana Mohammad paid 2000 cash for equipment which bought on credit (on transaction 3 )

13- Jan 24, Jana Mohammad borrowed 10,000$ by signing 5%, one-year note on february1, 2019.

14- Jan 25, Jana Mohammad paid 3000 cash salaries expenses

15- Jan 27, Jana Mohammad received 200 cash from the customer whose rent a lake on account ( transaction 11)

16- Jan 31, used shop supply during the month 600 Adjusted entry •

The equipment purchased on Jan12, 2018 is being depreciated using the straight-line method over 10 years, with a salvage value of $1,800.

• Jana Mohammad shop estimates that uncollectible accounts receivable at year-end is 300 • The short-term note is dated Jan 1, 2018, and carries a 5% interest rate. Prepare adjusting journal entries for each transactions and post to the ledger for each transaction

on 1st april2017 prentice acquired 60% of the equity share capital of sontic in a share exchange of two shares in prentice for three in sontic.the issue of shares has not yet been recorded by prentice at the date of acquisition,shares in prentice had a market value of $6 each. below are summerised draft financial statement of both companies.

statement of profit or loss for the year ended 30 September 2017

   prentice sontic

$000 $000

   revenue 85000    42000

   cost of sales    63000 32000

   gross profit    22000 10000

distribution costs    (2000)    (2000)

administration costs    (6000)    (3200)

finace costs    (300) (400)

   profit before tax 13700 4400

   income tax (4700)    (1400)

   profit after tax 9000 3000   

statement of financial position as at 30th September 2017

ASSETS

non current assets 40600 12600

property plant &equip 16000    6000

total current assets    56600    19200

   EQUITY AND LIABILITIES

   equity shares of $1    10000 4000

   returned earnings 35400 6500

   total    45400    6500

NON CURRENT LIABILITIES

   10% loan notes    3000    4000

   current liabilities 8200    4700

   total equity    56600 19200

the following information is relevant:

1. at the date of acquisition, the fair value of sontic's assets were equal to their carrying amounts with the exception of an item of plant which had a fair value of $2 million in excess of its carrying amount. it had a remaining life of five years at the date (straight line method depreciation is used) sontic has not adjusted the carrying amount of its plant as a result of the fair value exercise

2.sales from pretice in the post acquisition period were $8 million sontic made a mark up on cost of 40% on these sales. prentice had sold $5.2 million (at cost to prentice)of these goods by 30 September 2017. 3. sontic's trade receivables at 30 September 2008 include $600000 due from prentic which did not agree with prentic's corresponding trade payables. this was due to cash in transit of $200000 from prentice to sontic, both companies have positive bank balance

3.other than where indicated , statement of profit or loss items are deemed to accrue evenly on a time basis 5. prentice has a policy of accounting for any non controlling interest at fair value . the fair value of the non controlling interest at the acquisition date was $5.9 million

REQUIRED

(a) prepare the consolidated statement of profit or loss for prentice for the year ended 30 September 2017

(b)prepare the consolidated statement of financial position as at 30 sept 2017

In your opinion, what role does culture play in international expansion by a corporation? Your journal entry must be at least 200 words. No references or citations are necessary.

Write a one-page paper describing, discussing, and analyzing LIFO and FIFO. Research and include other sources. Include a title page, reference page, in-text citations.