Draw an ERD with the following information:

You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to discuss their business and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore, there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices for them are based on the quantity of their shipment and the past business they have done with each company. The price of a DVD for a movie might be different from the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors and at different wholesale prices. Each video and DVD has a unique identification number that The owners assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number. The owners assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to the owners, and the information from these catalogs must be included in the database. The owners need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion, there are discount prices for specific movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the Academy Awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. The owners need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc. There must be no limit to the number of video and/or DVD copies of a movie that the owners can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and Academy Awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

The following section is taken from Privy Ltd’s statement of financial position at 31 December 2018.

Interest is payable half-yearly on 1 January and 1 July. Assume no interest is accrued on 30 June.

Required: Prepare journal entries to record interest payments, and redemption of unsecured notes.

a.    Journalise the payment of interest on 1 January 2019.

2. Prepare the entry to pay the interest due on 1 July 2019.
3. Assume on 1 July 2021, after paying interest, that UGGS Ltd redeems half of the unsecured notes at 105.
4. Record the redemption of the notes.

1. With so many foreigners living in Thailand, a number of them western and non-western, work in the Kingdom without proper approval; work permits. As they are paid cash for their illegal work, how do you think this affects the Thai economy, money supply, and capital available for loan.
2. Consider an economy. This economy’s real GDP is constant. The government decides to buy out the government bonds from the commercial banks. What macroeconomic variables will such policy affect? Explain why. Would this effect be different if there was more output produced in the same year? What concept explains this?
3. Over 2018 the cumulative inflation in Venezuela reached 80,000%. How is such phenomenon called? What can cause inflation to reach such value? Explain your answer using the quantity theory of money. Give examples.

Larkspur Leasing Company signs a lease agreement on January 1, 2017, to lease electronic equipment to Crane Company. The term of the non-cancelable lease is 2 years, and payments are required at the end of each year. The following information relates to this agreement: 1. Crane has the option to purchase the equipment for $15,500 upon termination of the lease. It is not reasonably certain that Crane will exercise this option. 2. The equipment has a cost of $110,000 and fair value of $158,500 to Larkspur Leasing. The useful economic life is 2 years, with a residual value of $15,500. 3. Larkspur Leasing desires to earn a return of 5% on its investment. 4. Collectibility of the payments by Larkspur Leasing is probable.

Prepare the journal entries on the books of Larkspur Leasing to reflect the payments received under the lease and to recognize income for the years 2017 and 2018.

Assume that today is December 31, 2018, and that the following information applies to Abner Airlines:

After-tax operating income [EBIT(1 - T)] for 2019 is expected to be $550 million.

The depreciation expense for 2019 is expected to be $50 million.

The capital expenditures for 2019 are expected to be $475 million.

No change is expected in net operating working capital.

The free cash flow is expected to grow at a constant rate of 7% per year.

The required return on equity is 16%. The WACC is 11%.

The firm has $202 million of non-operating assets.

The market value of the company's debt is $3.183 billion.

200 million shares of stock are outstanding.

Using the corporate valuation model approach, what should be the company's stock price today? Do not round intermediate calculations. Round your answer to the nearest cent.

Shamrock Leasing Company signs a lease agreement on January 1, 2017, to lease electronic equipment to Pharoah Company. The term of the non-cancelable lease is 2 years, and payments are required at the end of each year. The following information relates to this agreement:

1. Pharoah has the option to purchase the equipment for $17,500 upon termination of the lease. It is not reasonably certain that Pharoah will exercise this option.

2. The equipment has a cost of $150,000 and fair value of $199,000 to Shamrock Leasing. The useful economic life is 2 years, with a residual value of $17,500.

3. Shamrock Leasing desires to earn a return of 5% on its investment. 4. Collectibility of the payments by Shamrock Leasing is probable.

Prepare the journal entries on the books of Shamrock Leasing to reflect the payments received under the lease and to recognize income for the years 2017 and 2018.

C#. Build a class that will be called “MyDate”. The class should have 3 properties: month, day and year. Make month, day and year integers. Write the get and set functions, a display function, and constructors, probably two constructors. (No Database access here.)

Using the scenario provided in the Milestone One Guidelines and Rubric document, prepare a brief summary of the HCI (human–computer interface) and the IMD (information management database) of the distribution company, using appropriate IT terminology. Submit this as a Word document with supporting screenshots embedded in the document.

"Acquisitions" Please respond to the following: Use the Internet or Strayer online database to research a publically traded company that recently acquired another company. Analyze the performance of the combined company, and ascertain at least two (2) benefits that the combined companies gained from the acquisition.

Develop the SQL scripts that will create the tables and enforce all the appropriate

constraints

• Develop sample SQL scripts that will insert the data to the database (one row in each

table)

• Convert at least 2 entities to MongoDB Collections. Write the scripts that will Create the

collection(s)