Functional requirements for Product rating based on sentiment analysis

and non functional requirments?

This project aims to develop a sentiment analysis system for product rating. It is an e-commerce web application. The main goal of this sentiment analysis system is to understand the hidden sentiments of customers in feedback and comments and analyze their product rating patterns. When registered customers (they can create account by themselves and then modify their account) use this application to view products, product features, and comment on different products, the sentiment analysis system will use API of some product review websites to collect comments of that product and analyze the comments of various users and ranks products accordingly. The system leverages a database of sentiment-based keywords (including positivity INFO2413 page 2 or negativity weight). So, when a user comments on a particular product, the sentiment analysis system analyzes the keywords in the comment to find the match with the keywords stored in the database. After analyzing the matches against the positive and negative keywords and sentiments, the system ranks a product as good, bad, and very bad. Thus, users can use this application to find out reviews on a product. The system also has administrator who manage the system, add/modify/delete users’ account

Individual student needs to prepare a paper on one reporting issue. The paper shall consists of a proper description of issue, literature review, theory and empirical evaluation of actual companies data. Students are encourage to discuss the forms, types and factors related to the issue. Examples of the issues include (but not limited to):-

1. Write off vs capitalizing In Process R&D especially in technology companies.

2. Gain on subsidiary stock sales.

3. Pushdown accounting

4. Goodwill write-off/impairment – recognition of loss in value, earnings power?

5. The effects of no par value shares.

6. Are impairments relevant for security valuation? And resulting earnings can predict future earnings better?

7. Whether fair value can explain stock price? 8. Use of special or non-recurring items

In C# thanks please,

Design a class named Person with properties for holding a person’s name, address, and telephone number.

Design a class named Customer, which is derived from the Person class. The Customer class should have the variables and properties for the customer number, customer email, a spentAmount of the customer’s purchases, and a Boolean variable indicating whether the customer wishes to be on a mailing list. It also includes a function named calcAmount that calculates the spentAmount.

All retail store has a preferred customer plan where customers can earn discounts on all their purchases. The amount of a customer’s discount is determined by the amount of the customer’s cumulative purchases in the store as follows:

• When a preferred customer spends $500, he or she gets a 5% discount on all future purchases.
• When a preferred customer spends $1000, he or she gets a 6% discount on all future purchases.
• When a preferred customer spends $1500, he or she gets an 8% discount on all future purchases.
• When a preferred customer spends $2000, he or she gets a 10% discount on all future purchases.

Design a class named PreferredCustomer, which is derived from the Customer class. The PreferredCustomer class should have a variable, discountLevel, with a read-only property. It alsoincludes a setDiscountLevel function that determine the discount level based on the purchases amount using switch statement and an override function, calcAmount, calculates the spentAmount with the current discount level.

Create a CustomerDemo class. In the main function, the program calls the getData function to read the data from the “CustomerInfo.txt” file and create a dynamic array of PreferredCustomer object.  Then, it prompts user to enter a customer number and displays a menu:

1. Display Customer Information: display the specific customer information
2. Update Spent Amount: update the total amount with the correct discount level

After update the spent Amount, the program writes the updated information back to file.

Example for customer info.txt below (there are 5 persons)

Kyle Jones

879 hobbs st. boston,MA 84758

456-789-0001

JLA9876A

[email protected]

3000

true

.

.

.

.

Juan Ltd acquired 80 percent share capital of Beach Ltd. On 1 July 2018 for a cost of $500,000. As at the date of acquisition, all assets and liabilities of Beach Ltd fairly valued except a land that has a carrying value $50,000 less than the fair value. The recorded balance of equity of Beach Ltd as at 1 July 2018 were as: Share capital $350,000 Retained earnings $100,000 Total $450,000 Additional information: ? The management of Juan Ltd values non-controlling interest at the proportionate share of Beach Ltd identifiable net assets ? Beach Ltd has a profit after tax of $70000 for the year ended 30 June 2019 ? During the financial year to 30 June 2019, Beach Ltd sold inventory to Juan Ltd for a price of $60000. The inventory costs Beach Ltd $30000 to produce. 25 percent of the inventory are still on the hand of Juan Ltd as at 30 June 2019. ? During the year Beach Ltd paid $10000 in management fees to Juan Ltd. ? On 1 July 2018, Beach Ltd sold an item of plant to Juan Ltd $40000. The equipment had a carrying value of $30000 (Cost $50000, accumulated depreciation $20000). At the date of sale it was expected that the equipment had a remaining life of 4 years and no residual value. ? The tax rate is 30 percent. Required: (a) Based on the above information, calculate the non-controlling interest as at 30 June 2019. (b) Pass necessary journal entry to recognise the non-controlling interest as at 30 June 2019.

SQL Program True/False Question

1. Which of the following is true of a many to many relationship? T/F

2. Security is rarely a concern for most databases. T/F

3. A security requirement refers to the need to restrict who can access some of the database data. T/F

4. Report requirements refer to the input forms the database will need. T/F

5. Insert permission is the permission to add records to the database. T/F

6. A trigger is code usually written in SQL which is triggered by a database event such as an insert or delete. T/F

7. A data requirement refers to the need to gather data about the database. T/F

8. One to one relationships are the most common relationship in a relational database. T/F

9. If you have an attribute that can have multiple values you should just number them 1, 2, 3, etc. T/F

10. Ideally every attribute in a database should have a unique name. T/F

11. Lookup entities have no effect on data consistency and integrity T/F

Creating a Database Design

Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document.

Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.

Recall Problem 3.3: A health insurance will pay for a medical expense subject to a USD 100 deductible. Assume that the amount of the expense is exponentially distributed with mean USD 500. Compute the empirical mean and empirical standard deviation of the payout by the insurance company by using 100000 samples.

Avig Ltd acquired 80% of the issued capital of Non Ltd on 1 July 2015. The following three transactions occurred. 1) On 1 July 2018, Avig Ltd purchased equipment from Non Ltd for $1,500,000. The equipment had originally cost Non Ltd $1,200,000 when acquired on 1 July 2016. Non Ltd had been depreciating the equipment over 12 years using the straight-line method. Avig Ltd expected the remaining useful life of the equipment to be 10 years and also depreciates using the straight-line method. 2) In May 2020, Avig Ltd sold inventory costing $80,000 to Non Ltd for $150,000. One quarter of this inventory remained on hand as at 30 June 2020. 3) Non Ltd paid a final dividend of $500,000 on 30 June 2020. Required Based on the information provided, prepare the intra-group journal entries, including all related tax effects, required upon consolidation as at 30 June 2020. The tax rate is 30%. Note: NCI allocation journals are not required.