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

p.77, icon at Example 6 #5. Determine whether this argument is valid: Lynn works part time or full time. If Lynn does not play on the team, then she does not work part time. If Lynn plays on the team, she is busy. Lynn does not work full time. Therefore, Lynn is busy.
Case Study:i) User who registers himself as a new user initially is regarded as staff or student forthe library system. For the user to get registered as a new user, registration forms are available thatis needed to be fulfilled by the user. After registration, a library card is issued to the user by the librarian. On thelibrary card, an ID is assigned to cardholder or user.ii) After getting the library card, a new book is requested by the user as per thererequirement.iii) After, requesting, the desired book or the requested book is reserved by the user thatmeans no other user can request for that book.iv) Now, the user can renew a book that means the user can get a new due date for thedesired book if the user has renewed them.v) If the user somehow forgets to return the book before the due date, then the userpays fine. Or if the user forgets to renew the book till the due date, then the bookwill be overdue and the user pays fine.vi) User can fill the feedback form available if they…
state machine diagram for the following use case by draw io
Please do it in excel A company would like to invest on a project. The rate the company uses to justify their investments, i.e. the MARR is 25% per year (compounded yearly). Their estimations about the projects are as follows: Initial Cost: ($300,000)The Study Period: 15 yearsSalvage (Market) Value of the Project: 20% of the initial cost Operating costs in the first year are estimated to be ($7,500) and these operating costs are estimated to increase by 5% per year. Construct cash flow table and determine the minimum amount of annual revenue ($ per year?) that makes this investment an attractive option for the company? (i.e. what is Equivalent UNIFORM (Annual) Cost, EU(A)C?)
33. "The Bank system should not allow users to send emails" is an example of: Domain Requirements Functional Requirements Non Functional Requirements
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
RECURRING?????????
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…