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

.

.

.

.

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

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.

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.

Suppose that the distance of fly balls hit to the outfield (in baseball) is normally distributed with a mean of 250 feet and a standard deviation of 50 feet.

1.    If X = distance in feet for a fly ball, then X ~ _____(_____,_____) ?

2.    Find the z-scores for fly balls that travel 200 feet and 300 feet.

3.    What is the approximate percentage of fly balls that travel between 200 and 300 feet? (Use Empirical Rule)

4.    Find the z-score for a fly ball that travels 150 feet.

5.    What is the approximate percentage of fly balls that travel fewer than 150 feet? (Use Empirical Rule)

6.    What is the approximate percentage of fly balls that travel more than 200 feet? (Use Empirical Rule)

7.    99.7% of fly balls travel between what two distances? (Use Empirical Rule)

8.    What is the percentage of fly balls that travel more than the mean distance? (Use Empirical Rule)

9.    What is the z-score for a fly ball that travels 270 feet?

10. What fly ball distance has z-score of -1.30?