COMPANY (Figure 3.6) Fundamentals of Database Systems 6th edition

COMPANY_fig3-6_Gist.txt

group: COMPANY (Figure 3.6) Fundamentals of Database Systems 6th edition
description[[ 
## COMPANY (Figure 3.6)   
###Fundamentals of Database Systems 6th edition  
Formatted for use in __RelaX__ - relational algebra calculator  
http://dbis-uibk.github.io/relax/index.htm>  
created by Johannes Kessler BSc at Databases and Information Systems Group at the   
Institute of Computer Science at the University of Innsbruck under supervision of   
Michael Tschuggnall PhD and Prof. Dr. Günther Specht  


This database example is used here for educational purposes only.  
Data source is Figure 3.6 of the book  
__Fundamentals of Database Systems 6th edition__   
Ramez Elmasri, Department of Computer Science and Engineering, The University of Texas at Arlington  
Shamkant B. Navathe, College of Computing, Georgia Institute of Technology  
ISBN-13: 978-0-136-08620-8  
Copyright © 2011, 2007, 2004, 2000, 1994, and 1989 Pearson Education, Inc., publishing as Addison-Wesley.   

]]

DEPARTMENT = { 
    Dname		Dnumber	Mgr_ssn		Mgr_start_date
	Research	5	333445555	1988-May-22
	Administration	4	987654321	1995-Jan-01
	Headquarters	1	888665555	1981-Jun-19
}
	
DEPENDENT = {	
	Essn		Dependent_name	Sex	Bdate		Relationship
	333445555	Alice		F	1986-Apr-05	Daughter
	333445555	Theodore	M	1983-Oct-25	Son
	333445555	Joy		F	1958-May-03	Spouse
	987654321	Abner		M	1942-Feb-28	Spouse
	123456789	Michael		M	1988-Jan-04	Son
	123456789	Alice		F	1988-Dec-30	Daughter
	123456789	Elizabeth	F	1967-May-05	Spouse
}

DEPT_LOCATIONS = {
	Dnumber	Dlocation
	1	Houston
	4	Stafford
	5	Bellaire
	5	Sugarland
	5	Houston
}
	
EMPLOYEE = {	
	Fname		Minit	Lname	Ssn		Bdate		Address				Sex	Salary	Super_ssn	Dno
	John		B	Smith	123456789	1965-Jan-09	"731 Fondren, Houston, TX"	M	30000	333445555	5
	Franklin	T	Wong	333445555	1955-Dec-08	"638 Voss, Houston, TX"		M	40000	888665555	5
	Alicia		J	Zelaya	999887777	1968-Jan-19	"3321 Castle, Spring, TX"	F	25000	987654321	4
	Jennifer	S	Wallace	987654321	1941-Jun-20	"291 Berry, Bellaire, TX"	F	43000	888665555	4
	Ramesh		K	Narayan	666884444	1962-Sep-15	"975 Fire Oak, Humble, TX"	M	38000	333445555	5
	Joyce		A	English	453453453	1972-Jul-31	"5631 Rice, Houston, TX"	F	25000	333445555	5
	Ahmad		V	Jabbar	987987987	1969-Mar-29	"980 Dallas, Houston, TX"	M	25000	987654321	4
	James		E	Borg	888665555	1937-Nov-10	"450 Stone, Houston, TX"	M	55000	NULL		1
}
	
PROJECT = {	
	Pname		Pnumber	Plocation	Dnum
	ProductX	1	Bellaire	5
	ProductY	2	Sugarland	5
	ProductZ	3	Houston		5
	Computerization	10	Stafford	4
	Reorganization	20	Houston		1
	Newbenefits	30	Stafford	4
}	

WORKS_ON = {
	Essn		Pno	Hours
	123456789	1	32.5
	123456789	2	7.5
	666884444	3	40
	453453453	1	20
	453453453	2	20
	333445555	2	10
	333445555	3	10
	333445555	10	10
	333445555	20	10
	999887777	30	30
	999887777	10	10
	987987987	10	35
	987987987	30	5
	987654321	30	20
	987654321	20	15
	888665555	20	null
}