Question: Figure 3.6 One possible database state for the COMPANY relational database schema write sql statments to create tables according figure 3.6 in sql file EMPLOYEE

Figure 3.6 One possible database state for the COMPANY relational database

Figure 3.6 One possible database state for the COMPANY relational database schema write sql statments to create tables according figure 3.6 in sql file EMPLOYEE Fname Minit John B Franklin T Alicia J Jennifer S Ramesh K Joyce A Ahmad V > XL Lname San Bdate Address Sex Salary Super_san Dno Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX 25000 987654321 4 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 1 4 James E DEPARTMENT Dname Research Dnumber Mgr_san 333445555 Mgr_start_date 1988-05-22 5 4 Administration Headquarters 987654321 888665555 1995-01-01 1981-06-19 DEPT_LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston 1 WORKS ON Essn Pno Pnumber Dnum Hours 32.5 Plocation Bellaire 1 1 5 123456789 123456789 2 7.5 2 5 PROJECT Pname ProductX Product Productz Computerization Reorganization Newbenefits Sugarland Houston 666884444 3 40.0 3 5 453453453 1 20.0 10 4 2 20.0 20 Stafford Houston Stafford 453453453 333445555 1 2 10.0 30 4 333445555 3 10.0 333445555 10.0 DEPENDENT 10 20 333445555 10.0 Essn Sex Bdate 30.0 333445555 F 999887777 999887777 1986-04-05 30 10 10.0 Dependent name Alice Theodore Joy Abner M 1983-10-25 333445555 333445555 987987987 10 35.0 F 1958-05-03 Relationship Daughter Son Spouse Spouse Son Daughter Spouse 987987987 30 5.0 987654321 M 1942-02-28 987654321 30 20.0 Michael M 123456789 123456789 1988-01-04 1988-12-30 987654321 20 15.0 Alice F 888665555 20 NULL 123456789 Elizabeth F 1967-05-05

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

How can analytical CRM help analyze the attractiveness of a residential long distance telephone services business? How would you evaluate a residential long distance business with these...

Figure 3.6 One possible database state for the COMPANY relational database schema. EMPLOYEE \begin{tabular}{|l|c|l|c|c|c|c|l|c|c|} \hline Fname & Minit & Lname & Ssn & Bdate & Address & Sex & Salary...

Supposed that each of the following Update operations is applied directly to the database state shown in the Figure 3.6. Discuss all integrity constraints violated by each operation, if any, and the...

Complete the Following: 1. Consider the data distribution of the Company database, where the whole database (shown in Figure 5.6) is stored at site 1, and the replicated fragments shown in Figure...

acording to the company schema pliz i want a solution coming from the (company scheme) please do not give a solution in the app already because I already seen them GEIT 3341: Database I 5\% Bonus...

GEIT 3341: Database 3. Find the first name, middle initial and last name of all employees who work on exactly 2 projects. (2.5 points) 2. Produce a relation showing the department name and the name...

DATABASE COURSE Produce a relation showing the department number and how many locations in each department ordered by the number of locations in descending order. Hint : you must use GROUP BY. (1.25...

Here is the schema: 1) Using SQL's INSERT command, insert a new employee using the following data: (2 points) Fname=Richard; Minit=K:Lname=Marini:SSN=653298653;Bdate='12- DEC-63; Address=98 Oak...

I need ONLY professional expert in Database course. I need all these questions to be answered correctly . Please use the SCHEMA to answer the following queries Database I Course: express the...

A solid cube of side 2a and mass M is sliding on a frictionless surface with uniform velocity v as in Figure P11.55a. It hits a small obstacle at the end of the table, which causes the cube to tilt...

If Larry in exercise 5 has accounts receivable of $100,000 rather than $60,000: a. What is Larrys accounts receivable turnover? b. What is Larrys average collection period? c. What should Larry do,...

An unfevorable veriance of $ 5 . 0 0 0 in sales is determined by comparing Fere fexible budget ( 9 , 0 0 0 units ) and the planning budget [ 1 0 , 0 0 0 units? What type of varimice is devibedt...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

How do Dimensional Database Models differ from Relational Models?

What type of processing do Relational Databases support?

Describe several aggregation operators.