The database design process for noSQL databases is different from one for relational (SQL) databases.

As we learned noSQL database does not require to have a predefined structure, except of creating a list of databases and the list of collections. Some of the noSQL databases (like MongoDB) allow to define certain rules that will define what should be the structure of the acceptable documents for each collection.

As you may recall, when you need to store multiple data points in a relational database you use multiple records (rows) where each record and then values to describe properties of that record will be placed in the columns. Unlike relational databases, noSQL databases allow two ways of storing multiple values (lists):

• By creating multiple documents (one per record);
• By creating lists within a single document.

The choice between one or another is based on the potential size of the list, size of the records, and the most common operations the database will need to process. The rule of thumb will be if the list changes regularly and each item in the list or complex (an object itself), not very well connected to the other items, or the list is very long, then use one document per record approach. Note, that the size of the document may also be limited (e.g. 15MB for a MongoDB document).

If the list is small, it has with small records, and unlikely change often, then you can make it as a part of one document.

For example, if you have a database of the business transactions, and there could be millions of those transactions recorded per minute, create a new document for each of them with me more efficient choice. In contrary, when you store information about degrees that an employee earned, which will be updated rarely, all degrees can be combined into a list in one employee profile document.

MongoDB also allows to use relational database – like relations, by using a document id as a value in another document.

You may read more about best practices of MongoDB design (Links to an external site.).

Business Case

A car-sharing company decided to use a MongoDB noSQL database to store information about their primary operations, which include recording of all rides, real time car locations, and users. A ride defined as combination of pick-up location, drop-off locations (if the car has been returned), with the associated timestamps of the those events.

Directions

In this assignment, you will propose a database structure for the given business case. It should include the list of collections, and one sample document (in JSON format) for each collection to demonstrate the document structure.

Put the list of the collections with the comments on their role along with the sample documents in JSON format in a single .txt file and submit it.

Exercise 10-24

On December 31, 2017, Oriole Inc. has a machine with a book value of $1,297,200. The original cost and related accumulated depreciation at this date are as follows.

Depreciation is computed at $82,800 per year on a straight-line basis.

Presented below is a set of independent situations. For each independent situation, indicate the journal entry to be made to record the transaction. Make sure that depreciation entries are made to update the book value of the machine prior to its disposal.

A fire completely destroys the machine on August 31, 2018. An insurance settlement of $593,400 was received for this casualty. Assume the settlement was received immediately. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

On April 1, 2018, Oriole sold the machine for $1,435,200 to Dwight Yoakam Company. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

On July 31, 2018, the company donated this machine to the Mountain King City Council. The fair value of the machine at the time of the donation was estimated to be $1,518,000. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

ATtached is a list of accounts

Accounts Payable
Accumulated Depreciation-Building
Accumulated Depreciation-Equipment
Accumulated Depreciation-Machinery
Accumulated Depreciation-Trucks
Buildings
Cash
Common Stock
Contribution Expense
Contribution Revenue
Cost of Goods Sold
Depreciation Expense
Direct Labor
Discount on Notes Payable
Equipment
Factory Overhead
Gain on Disposal of Buildings
Gain on Disposal of Equipment
Gain on Disposal of Machinery
Gain on Disposal of Trucks
Gain on Disposal of Plant Assets
Insurance Expense
Interest Expense
Interest Payable
Interest Revenue
Inventory
Land
Land Improvements
Loss on Disposal of Buildings
Loss on Disposal of Equipment
Loss on Disposal of Machinery
Loss on Disposal of Trucks
Machinery
Maintenance and Repairs Expense
Materials
No Entry
Notes Payable
Organization Expense
Paid-in Capital in Excess of Par - Common Stock
Prepaid Insurance
Retained Earnings
Salaries and Wages Expense
Sales Revenue
Trading Securities
Trucks

Electronic Commerce Act, 2000

1. Locate the Electronic Commerce Act, 2000 on Canlii, and attach a screenshot of the Act in your answer document.
2. What section of the Electronic Commerce Act, 2000 states that electronic contracts are legally enforceable?
3. A) If a contract is required by law to be in writing, how can this requirement be satisfied electronically? B) What section of the Electronic Commerce Act, 2000 contains this rule?
4. A) What section of the Electronic Commerce Act, 2000 describes the requirements that must be satisfied for an electronic document to be considered an original document? B) In your own words, what are the 2 requirements?

Project C0 C1 C2 C3 C4 C5

A -2000 +2000 0 0 0 0

B -3000 +2000 +1000 +2000 +1000 0

C -4000 +0 +2000 +1000 +1000 +3000

1. If the opportunity cost of capital is 12%, which projects have positive NPVs? Which

projects would a firm accept using the NPV rule?

2. Calculate the payback period of each project. Which project(s) would a firm using the

payback rule accept if the cutoff period were three years?

There are two unrelated parts to this question. Part 1 is worth 9 marks and Part 2 is worth 11 marks.

1. On 1 January 2018, Walli Ltd purchased equipment for a total cost of $55,016 paying cash. The estimated useful life of the equipment was 8 years, with an estimated residual value of $5,000. The entity’s reporting period ends on 30 June, and it uses straight-line depreciation. On 1 July 2018, Walli Ltd revalued the equipment upwards to reflect the fair value of $70,000. The revised useful life was 7 years and residual value was estimated to be nil. On 1 January 2020, Walli Ltd sold the equipment for $52,000. Walli Ltd is not registered for GST.

Required:

1. Prepare the journal entries in relation to the equipment from the date of acquisition to the date of disposal [9 Marks]

2. At 31 December 2018, Prince Ltd reported these non-current assets:

During 2019, the following selected transactions occurred:

May 1      Sold equipment that cost $720,000 for $420,000.

June 30   There was an indication that the building could be impaired due to flooding, Prince Ltd calculated the recoverable amount of the building. The net selling price was $155,000 and the value in use was estimated to be $147,000.

Prince Ltd uses straight-line depreciation for buildings and equipment. The building is estimated to have a 40-year useful life and no residual value. The equipment is estimated to have a 10-year useful life and no residual value.

Required

1. Journalise the transactions that occurred during 2019 [8 marks]
2. Explain the difference between impairment and depreciation [3 Marks]

WORKINGS

1. GENERAL JOURNal

For each of the following categories of compounds, indicate the type of liquid chromatography that could be used to separate analytes in that category. (Drag the appropriate chromatography label to the blank next to the category. Only one label applies to each category, but a label may be used more than once).

Seperation Mode Analyte Category

Fm>2000,soluble in octane,size10 nm

Fm>2000, soluble in butanol, size 100 nm

Fm>2000, soluble in water,nonionic,size 10 nm

Fm<2000, soluble in in ethanol

Fm<2000 , soluble in water, ion-paired

Fm<2000, soluble in water, ionic

Choices:

ion -exchange

Bonded-reverse phase

Adsorption

Bonded normal phase

Molecular exculsion

In debian and in red hat how would you update a package with file1.1.deb and file1.1.rpm respectively?

Use linux

International Economics

Explain how to manage/overcome balance of payments deficit of a country. Give explaination for each method. Put in-text-citations if you have any to support your point.