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

Four individuals wish to traverse an unstable bridge; they all start on the same side. You have 17 minutes to get everyone to the opposite side. Night has fallen, and they have only one torch. Two individuals may cross the bridge at once at most. Any crossing party, whether one or two individuals, must carry a torch. The torch must be carried back and forth; it cannot, for instance, be hurled. Person 1 crosses the bridge in one minute, person 2 in two minutes, person 3 in five minutes, and person 4 in ten minutes. A dyad must trek together at the slower individual's cadence. Create the algorithm specification that solves the problem.
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.
. 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.
Question 30 There are twelve gymnasts, among whom are Lia, Bella, and Priscilla. There is going to be world cup competition. A team comprised of 5 gymnasts should be send to participate in the competition. How many ways can this be done so that the team includes exactly two gymnast from {Lia, Bella, Priscilla}? 32 252 64 O 144
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.
• 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
A detachment of n soldiers must cross a wide and deep river with no bridge in sight. They notice two 12-year-old boys playing in a rowboat by the shore. The boat is so tiny, however, that it can only hold two boys or one soldier. How can the soldiers get across the river and leave the boys in joint possession of the boat? How many times need the boat pass from shore to shore?
IP Applications 4 Employment for Projects Formulate the following problem as integer linear programming problem. A company hires employees from a pool of 80 people. Employees are hired on a day to day basis. The pool contains 25 experienced persons. An experienced person can do twice as much work as an inexperienced person in the same time. Our company has n projects for which it has to recruit people. For the upcoming T days employees have to be divided over the projects. For project i (i = 1; :::; n) is w, the amount of required work on day t (t = 1; :::; T); an inexperienced employee can perform one unit of work per day. If an employee is hired on a certain day, he/she works on the same project all day. The cost for hiring a normal employee are c, per day and the cost for hiring an experienced employee are c, per day. Finally, for every day the minimal number of experienced employees that has to work on project i equals u,. The company wants to minimize the cost of hiring employees.…