Answered: EMP: NUMBER (4) EMPNO VARCHAR2 (10)…

EMP: NUMBER (4) EMPNO VARCHAR2 (10) ENAME VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7,2) SAL NUMBER (7, 2) COMM NUMBER (2) DEPTNO DEPT: NUMBER (2) DEPTNO VARCHAR2 (14) DNAME VARCHAR2 (13)

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

Gotham City National Bank is open Monday through Friday from 9 a.m. to 5 p.m. From past experience, the bank knows that it needs the numbers of tellers listed in the file P04_104.xlsx. Gotham City Bank hires two types of tellers. Full-time tellers work 9 a.m. to 5 p.m. five days per week, with one hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 12 p.m. and 1 p.m. or between 1 p.m. and 2 p.m. Full-time employees are paid (including fringe benefits) $15 per hour, which includes payment for lunch hour. The bank can also hire part-time tellers. Each part-time teller must work exactly four consecutive hours each day. A part-time teller is paid $9 per hour and receives no fringe benefits. To maintain adequate quality of service, the bank has decided that, at most, six part-time tellers can be hired. Determine how to meet the bank’s teller requirements at minimum cost.
Comet Enterprises assembles hand-held vacuum cleaners and desk fans in Memphis, TN. Each vacuum cleaner requires one electric motor, 4 hours of labor, and 20 ounces of stainless steel, and brings $12 profit. Each fan requires one electric motor, 1 hour of labor, and 10 ounces of stainless steel, and brings $4 profit. There are 100 electric motors, 160 hours of labor, and 1100 ounces of stainless steel available for this week's production. (a) Formulate a linear program to determine Comet's production plan for this week to maximize total profit, that is, how many hand-held vacuum cleaners, and how many desk fans should the company produce.
A company supplies a rang of cosmetic products and gives discounts on order as follows: For order less than 1000sh a discount of 2% is given. For orders Worth 1000sh and above a discount of 5% is given. These discounts are only given if the customer's account is less than four weeks in arrears.If the account is more than 8 weeks in arrears, a proforma invoice must be sent and settled before dispatch. Prepare a limited entry decision table for the above information.
. Employees of a certain firm are paid on hourly basis at the end of each week. If an employee works up to 40hrs, the employee is paid 6 GHS and 7 GHS per hour for a male and female respectively. If an employee works for more than 50 hours then the employee is also paid 2.5 the corresponding regular rate for hours worked in excess of 40. All employees are to pay 10 % of their gross as INCOME TAX and 2.5% towards the NHIS. If an employee has more than 3 children then he or she pays 2 cedis per child in excess of three towards GETFUND. Write a C++ program that can print onto screen the Net Salary of any staff onto screen. NB (NETSALARY is equal to gross salary less all deductions (VAT, NHIS, GETFUND). Write a C++ program and draw a flow chart for a software solution that can solve for the problem above.
Employees of KB and SONS Consultants Limited are paid at an hourly basics of 25GHS per an hour for regular hours and 1.5 times per hour for overtime hours in a week. Any hour worked over 40 hours per week is overtime. The following national tax sliding scale is then applied to determine the amount of tax to be paid by an employee. GrossWage Tax Rate (%) First 125 0 Next 125 5 Next 1500 10 Next 2750 15 Next 1250 20 Excess over 5000 30 In addition 6% of an employee’s gross wage is withheld for Social Security, 3% is withheld as constituency tax and 20GHS is withheld by the employer as welfare contribution. If an employee has more than 3 dependants then an amount of 5GHS for each dependant in excess of three towards NHIS. You are required to write a program that compute a workers gross pay, the deductions and his/her net pay. Your program should allow details of the staff to be accept /input into the system for the necessary computations. Try using comments in explaining the flow of the…
The Callaghan family owns 410 acres of farmland in Co. Cork on which they grow wheat and oats. Each acre of wheat costs €105 to plant, cultivate, and harvest; each acre of oats costs €210. The Bradleys have a budget of €52,500 for next year. The government limits the number of acres of oats that can be planted to 100. The profit from each acre of wheat is €300; the profit from each acre of oats is €520. The Callaghans want to know how many acres of each crop to plant in order to maximize their profit. ii. Formulate a linear programming model for this problem.
amnswer as soon as possible
• A certain grade of steel is graded according to the following conditions: (i) Hardness must be greater than 100 (ii) Carbon content must be less than 0.8 (iii) Tensile strength must be greater than 5500 The grades are as follows: Grade is 10 if all three conditions are met Grade is 9 if conditions (i) and (ii) are met Grade is 8 if conditions (ii) and (iii) are met Grade is 7 if conditions (i) and (iii) are met Grade is 6 if only one condition is met Grade is 5 if none of the conditions are met Write a program, which will require the user to give values of hardness, carbon content, and tensile strength of the steel under consideration, and output the grade of the steel. Comment/Discussion on the obtained results and discrepancies (if any).
He is given a commission on the basis of the following schedule: Monthly Sales: Less than P50,000 1% P50,000 − P99,999 2% P100,000 - P149,999 3% P150,000 and above 4% Compute for his commission assuming his total sales are: a) P75,800 b) P49,900 c) P151,200 d) P123,500
The Dash Cell Phone Company charges customers a basic rate of $5 per month to send text messages. Additional rates are as follows: The first 100 messages per month, regardless of message length, are included in the basic bill. An additional three cents are charged for each text message after the 100th message, up to and including 300 messages. An additional two cents are charged for each text message after the 300th message. Federal, state, and local taxes add a total of 14 percent to each bill. Design using a pseudocode. A program that continuously accepts data about text messages until a sentinel value is entered, and displays details only about customers whose total bill with taxes is over $10.