Empnoforenamesdobaddresstelno Depno

Oracle Tutorials - Databases

EMPLOYEE

empnoforenamesdobaddresstelno depno

surname

1JonesElizabeth Barbara05-jan-194426 Agnews Terrace, Shamrock Bay212 337 2288 1

2SmithRobert07-feb-194718 Marsh Street, Tollcross, Edinburgh031 732 89721

3WhiteAllan05-may-19616 Remote Place, North Berwick121 555 66221

4ReidGordon10-aug-19639 Noble Road, Penicuik629 424 67131

5MacCallanClaire18-sep-195825 Crisis Avenue, Leith, Edinburgh031 337 4166 1

6Murphy Brian Charles 30-jun-19549 Roberts Street, Biggar331 229 41471

7Gibson James 09-mar-194811 Depressed Way, Glasgow 041 447 80012

8AndrewsJohn02-jan-195873 Long Road, Lengthitown 70 229 72132

9Wright Audrey Mary 02-jan-195810 Nile Terrace, Polwarth, Edinburgh031 424 70922

10Reagan Anne17-aug-196182 Longstone Road, Longstone, Ed031 111 27992

11NorthAnnabel 01-sep-196235 Marchmont Terrace, Marchmont, Ed031 447 22662

12SouthTodd James28-feb-195910 Shandon Road, Merchiston, Ed031 333 10082

13East Ian 13-may-194247 Colinton Road, Craighlochart, Ed031 424 56652

14West Jack15-jun-194615 South West Gardens, Peebles466 31763

15AllenEster 27-feb-195510 Troon Street, Leith, Edinburgh 031 424 29073

16BrunellLiza18-aug-19628 Commercial Street, Tollcross, Ed031 424 16563

17RobertsonDavid Andrew07-aug-19609North Loan, South Queensferry 031 447 82133

18Robinson Allan 09-jun-196131 Newall Terrace, Hawick 229 08543

19RobertsRobert01-jan-19597 Peebles Road, Melrose 402 92133

20Murray James 06-mar-196440 Blackhall Loan, Biggar 121 444 45803

21BryceAnne13-sep-196522 Forresthill Place, Greyfriars, Edi031 402 66663

22CowanAudrey03-apr-194012 Down Street, Brayend 228 93214

23StevensonJohn David12-dec-195416 Rubber Road, Stampingham 337 62624

24DicksonWilliam 06-jan-195011 Newplace Road, Newton041 444 67304

25Brownlie Matthew 14-may-195480 Cowan Road, Shandon, Edinburgh 031 228 41414

26Gordon Mark12-feb-196010 Whyte Place, North Berwick 424 1024 4

27KennedyLuke26-jul-195214 Bucket Street, Musselburgh 031 414 73125

28GrantLynn12-jul-19563 Dey Terrace, Selkirk337 89115

29MacDonaldElizabeth 03-sep-196823 Neidpath Road, Peebles 444 89985

30MacDugle Shirley 09-oct-19648 Rosebank Terrace, Shandon, Ed031 447 11895

31DouglasChris 23-jun-195519 High Street, Livingston031 229 67925

32Christie Malcolm 5-jul-195911 Rounders Park, Polwarth, Ed031 424 84065

DEPARTMENT

Note head is the empno of the head of the department

depno dname location head

1accountsfloor 31

2administrationfloor 21

3software designfloor 12

4communicationsfloor 43

5engineeringfloor 57

COURSE

coursenocname cdate

1Basic Accounting11-jan-1989

2Further Accounting25-jan-1989

3Issues in Administration27-sep-1988

4More Administration16-oct-1988

5Ada01-nov-1988

6Introduction to Ingres05-feb-1989

7New Topologies10-mar-1989

8LANs12-dec-1988

9Structural Stress Analysis20-feb-1989

10Traffic Flow Analysis24-oct-1988

JOBHISTORY

empnoposition startdateenddatesalary

1AccountsManager12-jan-1976£30000.00

1AssistantAccountsManager11-feb-197212-jan-1976£22000.00

1Accountant10-mar-196811-feb-1972£15000.00

1JuniorAccountant09-apr-196410-mar-1968 £6000.00

2AssistantAccountsManager08-may-1976£25000.00

2Accountant07-jun-197108-may-1976£16000.00

2JuniorAccountant06-jul-196707-jun-1971 £8000.00

3Accountant05-aug-1984£16000.00

3JuniorAccountant04-sep-198105-aug-1984 £8000.00

4Accountant05-oct-1989£16000.00

5Accountant02-nov-1980£16000.00

5JuniorAccountant01-dec-197802-nov-1980 £8000.00

6Accountant12-jan-1980£16000.00

6JuniorAccountant11-feb-197412-jan-1980 £8000.00

7AdminManager10-mar-1980£30000.00

7AssistantAdminManager09-apr-197410-mar-1980£22000.00

7SeniorAdminAssistant01-dec-196809-apr-1974£16000.00

7AdminAssistant07-may-196001-dec-1968£10000.00

8AssistantAdminManager10-mar-1980£20000.00

8SeniorAdminAssistant09-apr-197710-mar-1980£12000.00

8AdminAssistant01-dec-197609-apr-1977 £8000.00

9SeniorAdminAssistant10-jul-1988£14000.00

9AdminAssistant08-jun-198210-jul-1988£10000.00

10AdminAssistant06-sep-1986£12000.00

10JuniorAdminAssistant22-sep-198306-sep-1986 £6000.00

11AdminAssistant13-mar-1982£15000.00

11JuniorAdminAssistant23-oct-198013-mar-1982 £8000.00

12AdminAssistant26-feb-1982£15000.00

12JuniorAdminAssistant03-jan-197726-feb-1982 £6500.00

13AdminAssistant17-apr-1988£16000.00

14AdminAssistant14-nov-1985£16000.00

15SeniorSystemsAnalyst21-aug-1988£35000.00

15SystemsAnalyst09-feb-198621-aug-1988£31000.00

15AnalystProgrammer17-jan-198409-feb-1986£25000.00

15Programmer13-may-198017-jan-1984£16000.00

16SystemsAnalyst25-apr-1991£30000.00

16AnalystProgrammer16-nov-198625-apr-1991£21000.00

16Programmer01-oct-198416-nov-1986£16000.00

17AnalystProgrammer17-jan-1988£21000.00

17Programmer01-oct-198417-jan-1988£16000.00

18AnalystProgrammer23-sep-1988£22000.00

18Programmer01-oct-198423-sep-1988£16000.00

19AnalystProgrammer23-sep-1988£22000.00

19Programmer01-oct-198423-sep-1988£16000.00

20AnalystProgrammer23-sep-1988£22000.00

20Programmer01-oct-198423-sep-1988£16000.00

21AnalystProgrammer13-dec-1991£25000.00

21Programmer11-sep-198913-dec-1991£21000.00

22CommunicationsManager03-aug-1985£36000.00

22SeniorCommunicationsEngineer21-jun-197703-aug-1985£26000.00

22CommunicationsEngineer13-may-197521-jun-1977£12000.00

22ElectricalEngineer08-feb-196613-may-1975 £8000.00

23SeniorCommunicationsEngineer03-aug-1985£18000.00

23CommunicationsEngineer21-jun-197903-aug-1985 £9000.00

23SoftwareEngineer14-feb-197721-jun-1979 £5000.00

24CommunicationsEngineer08-oct-1985£15000.00

24ElectricalEngineer06-may-198008-oct-1985£13000.00

25CommunicationsEngineer01-oct-1988£19000.00

25SoftwareEngineer25-aug-198501-oct-1988£16000.00

25SystemsProgrammer29-jan-198325-aug-1985£11000.00

25Programmer14-sep-198029-jan-1983 £9000.00

26CommunicationsEngineer13-mar-1988£19500.00

26SoftwareEngineer30-aug-198513-mar-1988£17000.00

26Trainee Engineer13-sep-198230-aug-1985£11000.00

26ElectronicEngineer01-sep-198013-sep-1982 £9000.00

27SeniorChiefEngineer01-nov-1990£25000.00

27ChiefEngineer20-jun-198601-nov-1990£17000.00

27MechanicalEngineer19-apr-198120-jun-1986£11000.00

27GraduateEngineer13-sep-197519-apr-1981 £6000.00

28ChiefEngineer06-jul-1989£29000.00

28CivilEngineer17-apr-198406-jul -1989£17000.00

28TraineeEngineer10-dec-197817-apr-1984£12000.00

28GraduateEngineer01-sep-197810-dec-1978 £3000.00

29ElectricalEngineer09-feb-1986£17000.00

29GraduateEngineer03-oct-198009-feb-1986£14000.00

30SeniorElectricalEngineer30-apr-1992£22000.00

30ElectricalEngineer06-mar-198730-apr-1992£17000.00

31SeniorMechanicalEngineer30-may-1987£22000.00

31MechanicalEngineer06-jun-198030-may-1987£17000.00

32SystemsEngineer01-mar-1991£19000.00

32ElectronicsEngineer31-oct-198901-mar-1991£18000.00

EMPCOURSE

empno courseno

11

12

21

22

73

74

83

84

145

146

155

156

217

227

228

195

196

Information on Table course

+------+------+------+------+------+

|Column Name |Data Type|Key #|Nulls|Defaults |

|------+------+------+------+------|

|courseno |integer | |no |no |

|cname |varchar(30)| |yes |n/a |

|cdate |date | |yes |n/a |

+------+------+------+------+------+

Information on Table department

+------+------+------+------+------+

|Column Name |Data Type|Key #|Nulls|Defaults |

+------+------+------+------+------+

|depno |integer | |no |no |

|dname |varchar(20) | |yes |n/a |

|location |varchar(15) | |yes |n/a |

|head |integer | |yes |n/a |

+------+------+------+------+------+

Information on Table empcourse

+------+------+------+------+------+

|Column Name |Data Type|Key # |Nulls |Defaults |

|------+------+------+------+------|

|empno |integer | |no |no |

|courseno |integer | |no |no |

+------+------+------+------+------+

Information on Table employee

+------+------+------+------+------+

|Column Name |Data Type|Key #|Nulls|Defaults |

|------+------+------+------+------|

|empno |integer | |no |no |

|surname |varchar(15) | |yes |n/a |

|forenames |varchar(30) | |yes |n/a |

|dob |date | |yes |n/a |

|address |varchar(50) | |yes |n/a |

|telno |varchar(20) | |yes |n/a |

|depno |integer | |yes |n/a |

+------+------+------+------+------+

Information on Table jobhistory

+------+------+------+------+------+

|Column Name |Data Type|Key #|Nulls|Defaults |

|------+------+------+------+------|

|empno |integer | |no |no |

|position |varchar(30) | |yes |n/a |

|startdate |date | |yes |n/a |

|enddate |date | |yes |n/a |

|salary |decimal(8,2) | |yes |n/a |

+------+------+------+------+------+

Alison Varey, School of Computing, Napier University 1