Q 1) Develop a decision table for the bank account described below. i. When account is opened it must have a minimum deposit of $500. ii. The account owner can make as many deposits as he/she wants. iii. Withdrawals are restricted to four times a week. iv. The account owner must maintain a minimum balance of %10 of all previous deposits. For example, initial deposit is $500, and subsequent deposits are $100 and $300. The %10 of all previous deposits are $50, $10 and $30 and the total is $80. v. The account owner is charged %0.2 of all withdrawals less than $1000, %0.1 of withdrawals more than $1000 and less than $10000, and %0.05 of all withdrawals more than $10000.

Q 1) Develop a decision table for the bank account described below. i. When account is opened it must have a minimum deposit of $500. ii. The account owner can make as many deposits as he/she wants. iii. Withdrawals are restricted to four times a week. iv. The account owner must maintain a minimum balance of %10 of all previous deposits. For example, initial deposit is $500, and subsequent deposits are $100 and $300. The %10 of all previous deposits are $50, $10 and $30 and the total is $80. v. The account owner is charged %0.2 of all withdrawals less than $1000, %0.1 of withdrawals more than $1000 and less than $10000, and %0.05 of all withdrawals more than $10000.

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

Fact-Finding Summary• A typical center has 300–500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded on acharge slip, which is signed by the member.• At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receiptsare deposited in a local bank and credited to the corporate Personal Trainer account. TheBumbleBee program produces a daily activity report with a listing of all sales transactions.• At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member statements are prepared and mailed. Members mail their payments to…
General Computer Accessory Company: In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at least one component and can comprise many components (described by component number (PK), description, and unit of measure), and each component is used to make zero to many products. GCAC keeps track of the quantities of products and components in the manufacturing process. In addition, a component can be used to make zero to many other components and a component can consist of zero to many other components. GCAC also keeps track of how many components go into making some other components. Draw an ER diagram using Draw.io Links to an external site.and insert the diagram (as an image file exported from the drawing tool; ensure that the image is a clean ER diagram that does not contain non-relevant details such as tool background and buttons) in a file (enter your full name and assignment number on the first…
Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit and surcharge of 15% of bill is added. •If the units consumed are more than 1000, then the cost is Rs 15/- per unit and surcharge of 25% of bill is added. Trace the production rules for the sample execution of the system given below;Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit…
The Livewright Medical Supplies Company has a total of 12 salespeople it wants to assign to three regionsthe South, the East, and the Midwest. A salesperson in the South earns $600 in profit per month for the company, a salesperson in the East eams $540, and a salesperson in the Midwest earns $375. The southern region can have a maximum assignment of 5 salespeople. The.company has a total of $750 per day available for expenses for all 12 salespeople. A salesperson in the South has average expenses of $80 per day, a salesperson in the East has average expenses of$70_pér day, and a salesperson in the Midwest has average daily expenses of $50. The company wants to detemine the number of salespeople to assign to each region to maximize profit. a. Formulate an integer programming model for this problem. b. Solve this model by using the computer.
Visual Basic problem
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME EMPLOYEE P_ID EMP_HIRE_DATE STUDENT P ID STUDY_MAJOR PK, FK1 PK, FK1
(a) Modules can be taken iff (if and only if) they have more than seven students registered. (b) The assessments for a module must total 100%.
Real-time Scheduling: Select all of the following statements that are true. Soft real-time systems must guarantee that real-time tasks will be serviced in accord with their deadline requirements. A periodic task is a job that is repeated regularly. A real-time task's CPU utilization can be calculated by dividing its period length by its service time for one period. Schedulability refers to a property indicating whether a real-time system (a set of real-time tasks) can meet its deadlines. Real-time systems apply an admission-control algorithm in order to decide whether a task is admitted (guaranteeing that it will complete on time) or rejected (if it cannot guarantee that the task will be serviced by its deadline).
Maximization Problem: Production Optimization A metallurgical company produces three types of metal products: A, B and C. These Products require different amounts of resources to manufacture. The company has limitations on the number of labor hours, machines available and raw Materials. The goal is to maximize total profit. Variables X₁: Quantity of products A to produce. X₂: Quantity of products B to produce. X3: Quantity of products C to be produced. X4: Hours of labor used. X5: Hours of machines used. X: Amount of raw material used for A. X7: Amount of raw material used for B. X₂: Amount of raw material used for C. Xg: Upper limit on total product production. X10: Upper limit on the number of work hours available. Objective Function Maximize Z = 5x, +8x₂+6x3 Restrictions 2x₁+4x₂+3x3 ≤ x₂ (Labor restriction) 3x₁+2x₂+5x3 ≤ X5 (Machine restriction) X ≤ 5x₂ (Raw material for A) 2x, ≤ 6x₂ (Raw material for B) 3x ≤ 4x, (Raw material for C) X₂+x₂+x3 ≤ x₂ (Limit on total production) X4 SX₂0…