Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 EMPLOYEE table [ [ Fname , Minit,Lname,Ssn , Bdate,Address,Sex,Salary,Super _ ssn , Dno ] , [ John , B , Smith, 1

QUESTION 1
EMPLOYEE
\table[[Fname,Minit,Lname,Ssn,Bdate,Address,Sex,Salary,Super_ssn,Dno],[John,B,Smith,123456789,1965-01-09,731 Fondren, Houston, TX,M,30000,333445555,5],[Franidin,T,Wong,333445555,1955-12-08,638 Voss, Houston, TX,M,40000,888665555,5],[Alicia,J,Zelaya,999887777,1968-01-19,3321 Castle, Spring. TX,F,25000,987654321,4],[Jennifer,S,Walace,987654321,1941-06-20,291 Berry, Bellare, TX,F,43000,383665555,4],[Ramesh,K,Narayan,666884444,1962-09-15,975 Fire Oak. Humble, TX,M,38000,333445555,5],[Joyce,A,English,453453453,1972-07-31,5631 Rice, Houston, TX,F,25000,333445555,5],[Ahmad,V,Jabbar,987987987,1969-03-29,980 Dallas, Houston, TX,M,25000,987654321,4],[James,E,Borg,888665555,1937-11-10,450 Stone, Houston. TX,M,55000,NULL,1]]
DEPARTMENT
\table[[Dname,Dnumber,Mgr_ssn,Mgr_start_date],[Research,5,333445555,1988-05-22
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions