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

Switch statement Problem 6. A manufacturing company has classified its executives into four levels for the benefit of certain perks. The levels and corresponding perks are shown be Perks Conveyance allowance Entertainment allowance Level 1000 750 500 250 500 200 100 2 An executive's gross salary includes basic pay, house rent allowance at 25% of basic pay and other perks. Income tax is withheld from the salary on a percentage basis a Gross salary Таx гate Gross 65000 No tax deduction 20% 25% 30% Write a program that will read an executive's job number, level number, and basic pay and then compute the net salary after withholding income tax.
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.
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 company pays its employees on a weekly basis. The employees are of four types: Salariedemployeesarepaidafixedweeklysalaryregardlessofthenumberofhoursworked, hourly employees are paid by the hour and receive overtime pay (i.e., 1.5 times their hourly salary rate) for all hours worked in excess of 40 hours, commission employees are paid a percentage of their sales and base-salaried commission employees receive a base salary plus a percentage of their sales. For the current pay period, the company has decided to reward salaried-commission employees by adding 10% to their base salaries. The company wants to write an application that performs its payroll calculations polymorphically. Create an EMPLOYEE class having First Name, Last Name, socialSecurityNumber(SSN); Provide a default Constructor. Provide overloaded parameterized Constructors. Provide getters, and setters for the data members. In addition there is method earnings which will return the earning of employees. For now you just…
BU School of Witchcraft and Wizardry is a school of magic that sends admission letters only to children with magical abilities. The admissions process for BU School of Witchcraft and Wizardry is as follows:- If both parents of the child have previously studied at BU, they do not need to reply to the admission letter. Otherwise they need to reply to the admissions letter by July 31. If they do not reply by the specified date, they are not accepted to the school. BU has 4 houses that students are sorted into by the sorting hat “Hayri”. These houses are; Gryffindor, Hufflepuff, Ravenclaw and Slytherin. Hayri sorts the students into houses according to 2 characteristics; braveness and intelligence.- If Hayri finds the student to be brave and intelligent, they are sorted into Gryffindor.- If the student is found to only be brave, they are sorted into Slytherin.- If the student is found to only be intelligent, they are sorted into Ravenclaw.- Finally, if they are neither brave nor…
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).
i want 4 SEQUENCES DIAGRAM from this use case:- 옷 Student incorrect extend 옷 admin add course «include include login employees evalution includes reservation time include «include>> extend extend extende extende extend y extend lack of money follow up financial situation make payment include member complete training course include online «include> basic course view employee info remove empolyee promotion employee extende view std info cash not qualified include print card has no money extend extends pass the interview includes «extend- extend choose level course exten write report apply to work receive salary modify 064 employee WRON WHEN OPM
3G R 4G O 53% D 17:57 CMPG 121 Final... Loyalty points are awarded by a company based on the amount a customer spend. Loyalty points can be used immediately with the current transaction or can be accumulated. The number of loyalty points per transaction is calculated as follows: For purchases of R 500.00 or less, 1 loyalty point will be awarded per R 50.00 spent. For purchases of more than R 500.00 the following applies: • For the first R 500.00, 1 loyalty point will be awarded per R 50.00 spent For the remainder of the amount, 2 loyalty points will be awarded per R50.00 spent. Examples: For purchases of R 460.00, 9 loyalty points will be awarded. For purchases of R 660.00, 10 loyalty points will be awarded for the first R 500.00 and 6 loyalty points for the remaining R 160.00 = 16 loyalty points For purchases of R 1250.00, 10 loyalty points will be awarded for the first R 500.00 and 30 loyalty points for the remaining R 750.00 = 40 loyalty points The monetary value of the loyalty…
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…
Tyger Valley Pet Shelter (TVPS) receives food donations from a group of pet food manufacturers. TPS relies on each manufacturing company for a particular need. For example, Veggie Land supplies all the vegetables and Premier Seed Suppliers supplies all the seeds. The different food types are allocated to the animals according to their category. For example, food type 'seeds' is allocated to category 'Birds', while food type 'vegetables' is allocated to the categories 'Mammals' and 'Birds'. Each animal category is subdivided into different pet types. For example, the mammal record could relate to pet types 'Dog' and 'Cat'. TPS has recruited you to be their database designer. The database will store information on their suppliers, food types, animal categories and pet types: Record a unique ID, company name, contact number and possibly an e-mail address for each manufacturer. When recording information about the different food types, ensure that the expiry date is also stored. When…
Question 4Ghana Water Company is considering automating its billing system. A software application is to be developed for this system and the application should be able to;i. Accept the following input: Customers name, Quantity of water consumed.ii. Distinguish the following categories of consumers based on the number of gallons of water used:  Domestic, if water consumed is less than or equal to 500 gallons a month Commercial, if water consumed is more than 500 but less than or equal to 1000 gallons a month Industrial, if water consumed is more than 1000 gallons of water a month. iii.Compute the following Domestic amount to pay is GHC 10.00 per gallon Commercial amount to pay is GHC 20.00 per gallon Industrial amount to pay is GHC 30.00 per gallon.(a) Write an Algorithm for this software application (b) Draw the flow chart for your algorithm