C2. Prepare a Decision Table for the Airfare Discount problem. Also write the total number of columns in this decision table. The passengers are treated according to three categories: Type of Flight, Frequent Flyer and Age Group. The possible values of each category are: > Type of Flight: International (I), Local (L) > Frequent Flyer: Yes (Y), No (N) > Age Group: I (Infant: < 2 years), Y (Youth: between 2 and 16), O (Others: > 16) The system has four different types of discounts: V 80%: Infant passengers travelling in Local flight are eligible v 70%: Infant passengers travelling in International flight are eligible V 20%: Young Frequent Flyers, travelling in International flight V 15%: Other Frequent Flyers, travelling in any flight

C2. Prepare a Decision Table for the Airfare Discount problem. Also write the total number of columns in this decision table. The passengers are treated according to three categories: Type of Flight, Frequent Flyer and Age Group. The possible values of each category are: > Type of Flight: International (I), Local (L) > Frequent Flyer: Yes (Y), No (N) > Age Group: I (Infant: < 2 years), Y (Youth: between 2 and 16), O (Others: > 16) The system has four different types of discounts: V 80%: Infant passengers travelling in Local flight are eligible v 70%: Infant passengers travelling in International flight are eligible V 20%: Young Frequent Flyers, travelling in International flight V 15%: Other Frequent Flyers, travelling in any flight

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Construct a LCS table for Input1=’Student name’ and Input2=’Hometown’. Also find the Length of LCS and Actual LCS. Construct LCS for both scenarios given below. a)Take Input1—Vertical and Input2—Horizontal b) Take Input2—Vertical and Input1—Horizontal
Lastly, you will notice that more people scored "Above Average" than "Below Average" using 5 as the cut point. Redefine the LOOKUP formula so that a roughly equal number of employees are classified as "Above Average" and as "Below Average." 6. What is the new cut off point? Answer this question.
Create a decision table and decision tree that will be use by the clerk at the Parcel Department in a Post Office. Use the rules illusrated below: If the goods that is going to be sent is an ordinary goods, use mail type delivery. If the goods that is going to be sent is based on higher priority, use the courier service if the distance is local (not more than 10km), delivery should be done by lorries transportation if the distance is slightly higher (more than 10km but not more than 150km), or air mail service is being used if the distance is more than 150 km. Each goods that need to be sent should be weight accordingly. If the value of the goods is more than RM250, it must be insured.
Data minig course Given the observation table for student who pass/ do not pass the test according to their studying style, concentration level and sleeping habits below: Draw the decision tree for the below table Test Study Sleep Concentrate Time Pass ? 1 Hard No High Long Yes 2 Less Yes High Less Yes 3 Don’t study No No Long No 4 Don’t study No High Long No 5 Hard Yes No Long Yes 6 Hard No No Less No 7 Less Yes No Long No 8 Less Yes High Long Yes 9 Less Yes No Less No 10 Don’t study No High Less No
A company manufactures 3 products in 2 different factories. The cost of production and time required for production for each product varies depending on which factory produces it. The time and cost required for production of each product in each factory is provided in the tables in this worksheet. Demand for products 1, 2 and 3 are 200, 240 and 100 units, respectively. There are a total of 3,000 hours available in each factory. Additionally, at least 60% of the total units of Product 1 must be produced in Factory A, and at least 40% of of the total units of Product 2 must be produced in Factory B. Create a linear programming model and use the Solver add-in to determine the optimal production plan that will minimize total cost. Note: The cost is per unit not per hour. All demand must be met.
8. Commuting Times The U.S. Census Bureau reports that the average commuting time for citizens of both Baltimore, Maryland, and Miami, Florida, is approximately 29 minutes. To see if their commuting times appear to be any different in the winter, random samples of 40 drivers were surveyed in each city and the average commuting time for the month of January was calculated for both cities. The results are shown. At the 0.05 level of significance, can it be concluded that the commuting times are different in the winter? Miami Baltimore Sample size 40 40 Sample mean 28.5 min 35.2 min Population standard deviation 7.2 min 9.1 min
4. Suppose a company has employee annual salary data as follows. - For the interval $\$ 1$ to $\$ 25,000,5$ employees; for the interval $\$ 25,001$ to $\$ 50,000,15$ employecs; for the interval $\$ 50,001$ to $\$ 75,000, 25$ cmployees; - for the interval $\$ 75,001s to $\$ 100,000,25$ employecs; - for the interval $\$ 100, 001$ to $\$ 125,000, 35$ employees; - and for the interval $\$ 125,001$ to $\$ 150,000,30$ employees. (a) Which direction, if any, is this data skcwed? [Hint: Draw a graph of the distribution. Sec if that gives you an insight.] (b) Which is likely larger for this dataset, the mean or the median? S.P.PB. 251
Question 15 options: Complete the following Truth Table p q r p ∨ ~(~q ↔ ~r) T T T (a) T T F (b) T F T (c) T F F (d) F T T (e) F T F (f) F F T (g) F F F (h)
The tables below are actitvites slack times and number of workers required respectively. A-B B-D D-E A-D T1. (slack) A-D B-E B-C C-E 8 6 4 1 T2. (workers) B-E B-C C-E 3 2 3 4 3 2 2 Q2. In the above table, the completion times of the activities BD and DE are on average 6 hours and 8 hours, respectively, and if the variances of the completion times of the same activities are 16 and 9 hours, respectively. a. What is the expected total completion time of the project? b. What is the probability that the project will be completed in 20 hours in total?
Write aigorithm to accept salary of a person for 4 months and calculate average.
A store purchased x packages of AAA batteries at $5 per package and y packages of AA batteries at $7 per package for a total cost of $135. If at least one package of each type of battery was purchased, what are the possibilities of the number of packages of AAA batteries and the number of packages of AA batteries?
It is possible to differentiate scalar functions, aggregate functions, and table-valued functions.