Show the result of each of the sample queries in Section 8.5 as it would apply to
Question:
Show the result of each of the sample queries in Section 8.5 as it would apply to the database state in Figure 5.6.
Figure 5.6
Transcribed Image Text:
ΕMPLOYEΕ Sen 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 333445555 1955-12-08 638 Voss, Houston, TX 999887777 1968-01-19 3321 Castle, Spring, TX Fname Minit Lname Bdate Address Sex Salary Super_ssn Dno John B Smith Franklin Wong M 40000 888665555 25000 987654321 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 25000 333445555 M 25000 987654321 Alicia Zelaya 4 Jennifer Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX 4 Ramesh K English 453453453 1972-07-31 5631 Rice, Houston, TX 987987987 1969-03-29 980 Dallas, Houston, TX Joyce A F 5 Ahmad V Jabbar 4 James Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr_san Mgr_start_date Dnumber Dlocation Research 5 333445555 1988-05-22 1 Houston Administration 987654321 1995-01-01 4 Stafford Headquarters 1 888665555 1981-06-19 5 Bellaire 5 Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Pnumber Plocation Dnum 123456789 32.5 ProductX Bellaire 5 123456789 7.5 ProductY 2 Sugarland 5 666884444 3 40.0 Productz 3 Houston 5 453453453 20.0 Computerization 10 Stafford 4 453453453 2 20.0 Reorganization 20 Houston 333445555 2 10.0 Newbenefits 30 Stafford 4 333445555 3 10.0 333445555 10 10.0 DEPENDENT 333445555 20 10.0 Dependent name Esan Sex Bdate Relationship 999887777 30 30.0 333445555 Alice 1986-04-05 Daughter 999887777 10 10.0 333445555 Theodore M 1983-10-25 Son 987987987 10 35.0 333445555 Joy 1958-05-03 Spouse 987987987 30 5.0 987654321 Abner M 1942-02-28 Spouse 987654321 30 20.0 123456789 Michael M 1988-01-04 Son 987654321 20 15.0 123456789 Alice 1988-12-30 Daughter 888665555 20 NULL 123456789 Elizabeth 1967-05-05 Spouse 2 -
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 60% (10 reviews)
First step create table EMPLOYEE with below attributes respective data types no...View the full answer
Answered By
Wilson Kariuki
Driven leveraging studies in Information Technology, Computer Programmer.
Offers strong interpersonal and task prioritization skills, Polytechnic University of the
Philippines 2018 - 2022, Cum Laude, President's List 1st and 2nd Semester 2021, President's List 1st and 2nd Semester 2020 , Dean's List 2018, 2019 and a SQL Database Developer at Information Technology Shanghai
0.00
0 Reviews
10+ Question Solved
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted:
Students also viewed these Computer science questions
-
Show the result of each of the sample queries in Section 6.5 as it would apply to the database state in Figure 3.6.
-
Show the result of inserting 2, 1, 4, 5, 9, 3, 6, 7 into an initially empty AVL tree.
-
We have discussed cost accounting as it would apply to a manufacturing industry. Conduct research online to determine the applicability of cost accounting in other industry sectors and present your...
-
Express the following sum in closed form. 2 k 2 (4 + 3 - 4 ) = n k 1
-
What is the power of the effect in the following planned studies using the analysis of variance with p Number of Levels of the Effect Predicted Effect Size Small Small Small Small Medium Overall...
-
Transactions made by M. Alberti and Co., a law firm, for the month of March are shown below and on the next page. Prepare a tabular analysis which shows the effects of these transactions on the...
-
Imagine that you see an advertisement for Manic Wesley's Used Car Emporium that reads something like this: "\($10,000\) Instant Credit! Seven Years to Pay! Low, Low Monthly Payments: Only \($231.99\)...
-
A uniform beam of mass m is inclined at an angle θ to the horizontal. Its upper end produces a ninety degree bend in a very rough rope tied to a wall, and its lower end rests on a rough floor...
-
Political tensions and debates surrounded territorial expansion of the United States leading up to the Civil War because any new states joining the Union could change the sectional balance (number of...
-
Details of receipts and issues of a material in a factory during March are as follows: March 1st Opening balance 500 quintals @ Rs.25 3rd Issued 70 quintals 4th Issued 100 quintals 8th Issued 80...
-
When is a query language called relationally complete?
-
Specify the following queries on the COMPANY relational database schema shown in Figure 5.5 using the relational operators discussed in this chapter. Also show the result of each query as it would...
-
Two cars are approaching an intersection. One is 2 miles south of the intersection and is moving at a constant speed of 30 miles per hour. At the same time, the other car is 3 miles east of the...
-
1)Why Shareholder equity is consider the liability of the company? 2)Explain the difference between Income Statement and Cash Flow Statement? 3)Why Company do not like to issue Preferred Stock? and...
-
Your investment portfolio has two funds in it. Fund A provides 13% return a year with risk of 19%. Fund B provides 8% a year with risk of 11%. The two funds has a correlation coefficient of 0.4. If...
-
AMAT currently pays $1.8 in dividend. The company can increase dividend at 10% a year. If the required return is 12.5%, what should be the stock price for AMAT in 10 years?
-
Evaluate the limit Answer: L = 5 5n 2 2 2 /25 - (- 5 + 57) . N L = lim N0 # Hint: Here each term being added depends on the number of terms involved. Therefore this problem cannot be addressed by our...
-
Stock return r_stock is either +2500% or -100% with equal probabilities. Find: E[r_stock] = Var[r_stock] = std_stock= Is such stock attractive? Would you like to invest everything in this stock? What...
-
Heather works in the training department of a large information technology (IT) organization. She is in charge of designing and delivering inter-personal skills training, including communication...
-
Suppose the market is semistrong form efficient. Can you expect to earn excess returns if you make trades based on? a. Your brokers information about record earnings for a stock? b. Rumors about a...
-
Justify Table 8.2, summarizing the running time of the methods of a tree represented with a linked structure, by providing, for each method, a description of its implementation, and an analysis of...
-
Draw an arithmetic expression tree that has four external nodes, storing the numbers 1, 5, 6, and 7 (with each number stored in a distinct external node, but not necessarily in this order), and has...
-
What are the minimum and maximum number of internal and external nodes in an improper binary tree with n nodes?
-
Exercise 3-10 (Algo) Applying Overhead; Journal Entries; T-accounts [LO3-1, LO3-2] Dillon Products manufactures various machined parts to customer specifications. The company uses a job-order costing...
-
Direct Materiais Purchases Budget Smart Strike Company manufactures and sells soccer balls for teams of children in elementary and high school. Smart Strike's best-selling lines are the practice ball...
-
Let u: R2 R be a strictly increasing C utility function. + (a) Derive an expression for the slope of an indifference curve at an arbitrary consumption bundle (xo, yo) R. '++ (b) Take a derivative of...
Study smarter with the SolutionInn App