Produce the data mining decision rules based on the following table. Only Use theformat below the table.Ten cases, and three variables (life cycle phase, competition, and product), and the finaloutcome (prediction) are below.Cases Life Cycles Competition Product Expert PredictionPhasesDeclineMaturityMaturityDeclineGrowthGrowthMaturityGrowthCase 1Case 2Case 3Case 4Case 5Case 6Case 7Case 8Case 9Case 10Q2) Format to fill in.1) If #1,2) If #4MaturityDecline3) If #7Q1) Draw a decision three (you can draw using a software, e.g. word processor).is #24) If #12LowHighLowis #5LowLowLowLowHighHighHighis #8Then the decision outcome is #11is #13_Then the decision outcome is # 16SoftwareSoftwareHardwareHardwareHardwareSoftwareSoftwareSoftwareHardwareSoftwareAND #9, Then the decision outcome is #3Then the decision outcome is #6of ProfitDownDownUpDownUpUpUpUpDownDownAND #14is # 10is #

Que) Produce the data mining decision rules based on the following table. Only Use the format below…

Q1) Draw a decision three (you can draw using a software, e.g. word processor). Q2) Format to fill in. 1) If #1, 2) If #4 3) If #7 is #2 4) If #12 is #5 is #8 Then the decision outcome is #11, is #13 Then the decision outcome is #16 Then the decision outcome is #3_ Then the decision outcome is #6_ AND #9 AND #14 is #10 is #

Q1) Draw a decision three (you can draw using a software, e.g. word processor). Q2) Format to fill in. 1) If #1, 2) If #4 3) If #7 is #2 4) If #12 is #5 is #8 Then the decision outcome is #11, is #13 Then the decision outcome is #16 Then the decision outcome is #3_ Then the decision outcome is #6_ AND #9 AND #14 is #10 is #

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter4: Analyzing And Charting Financial Data

Section: Chapter Questions

Problem 2.12CP

See similar textbooks

Similar questions

Describe a feature that is found in Design View but not in the Datasheet View. Describe two situations where you might use this feature.
Consider the following PRODUCT table (Primary key underlined). True or False: The two last rows are allowed in the table PRODUCT PRODUCT ID PRODUCT_TYPE_CODE PRODUCT_PRICE PRODUC_NAME PRODUCT_DETAILS Some Description P1 РС-1 23.45 Introduction to Access Some Description Some Description Some Description P2 PC-2 99.25 Plates P3 PC-3 9.99 Forks P4 PC-4 1200.45 Horizon 2000 Tread Mill P5 PC-4 900.00 Soul F80 Some Description True False
Refer to the dimension tables and EmployeeFact table below. Job Date Location EmployeeFact •JobID •DatelD •LocationID • ( OEmployeelD Title FullDate StreetAddress oJobID JobCode DayNumber City PostalCode OLocationID LevelCode MonthNumber oHireDatelD OBirthDatelD ) SalaryAmount BonusAmount MonthName State Year CountryCode EducationYears PerformanceRating The following query reports the employee with the highest salary amount per postal code for employees with level code 8. Complete the missing values. SELECT CountryCode, EmployeeID, MAX(_ _(A)_ FROM (B). Location, Job WHERE EmployeeFact.LocationID = Location.LocationID AND EmployeeFact.JobID = (C). AND = 8 GROUP (A) Ex: Identifier (B) (C)
The below data is in first normal form. Normalise the data to third normal form, showing all steps with explanations. Dependency diagrams or tabular data are acceptable for the final answer. Primary key: PlayerName, CharacterName Player Player Character Character Character Name DateJoined Name Level Маx Health Bob 2014-12-31 George 50 800 Bob 2014-12-31 Fred 50 1200 Alice 2015-05-09 ZeAlice 21 350 Charles 2016-09-09 HisRoyalHighness 30 470 Delta 2020-02-29 WarriorDelta 50 1205 Delta 2020-02-29 DeltaMage 60 2.
T Shirt Sales t-shirt price quantity sold total revenue $15 400 $6,000 50 100 150 200 250 300 350 400 $10 $15 $17 $25
Question 3 refers to two data tables giving the details of a company's employees and company's job titles, called EMP and JOB respectively, which have the following format: Table EMP Column type Integer Up to 10 characters Column name Example entry Description Employee ID number Employee surname EMPNO 7369 ENAME SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager Date employment started Monthly salary HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column type Integer Up to 15 characters Column name Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN b) Using EMP and JOB tables, give an example of the JOIN SQL statement which uses "WHERE", "GROUP BY", “HAVING" and “ORDER BY" clauses. Explain the result table of the SQL statement. (Maximum 300 words).
which rules apply to desigining table with less redundancy? a) Binary Relationship b) Reflective Relationship c) Weak entity d) Normal form
Write the resulting relations based on the following ER diagram Like_Group N Customer N name N name address Group Like_Artist amoun t N name Classify Artist year N birthplace 1 title style age type Artwork N Paints price
Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs 1 screen Duration StartDate 2022-05-06 1 2022-05-15 1 4 10 TeamMemberID 2022-05-06 2 Write a SQL statement to create the table Task. Hint: The sample data should give you an indication of the data types you should use.
Modify the PILOT table to add the attribute shown in the following table, with a precision and scale of (8,2).
draw ERD for these tabels The system must contain tables such as category(catNo,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo),Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity)
The term attribute refers to a of a table. Your answer When we talk about the table in more accurate details, for example this field, what is its data type and what is the domain of it like integer or text, this type is called view of data. Your answer