Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fig. 2 . 2 . Example Database EMP table [ [ ENO , ENAME,TITLE ] , [ E 1 , J . Doe,Elect. Engineer

Fig. 2.2. Example Database
EMP
\table[[ENO,ENAME,TITLE],[E1,J. Doe,Elect. Engineer],[E2,M. Smith,Syst. Anal.],[E3,A. Lee,Mech. Eng.],[E4,J. Miller,Programmer],[E5,B. Casey,Syst. Anal.],[E6,L. Chu,Elect. Eng.],[E7,R. Davis,Mech. Eng.],[E8,J. Jones,Syst. Anal.]]
ASG
\table[[ENO,PNO,RESP,DUR],[E1,P1,Manager,12],[E2,P1,Analyst,24],[E2,P2,Analyst,6],[E3,P3,Consultant,10],[E3,P4,Engineer,48],[E4,P2,Programmer,18],[E5,P2,Manager,24],[E6,P4,Manager,48],[E7,P3,Engineer,36],[E8,P3,Manager,40]]
PROJ
PAY
\table[[PNO,PNAME,BUDGET,LOC],[P1,Instrumentation,150000,Montreal],[P2,Database Develop.,135000,New York],[P3,CAD/CAM,250000,New York],[P4,Maintenance,310000,Paris]]
\table[[TITLE,SAL],[Elect. Eng.,40000],[Syst. Anal.,34000],[Mech. Eng.,27000],[Programmer,24000]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions