onzfonz

group: more random data

description[[ the data for this dataset is for testing

The relation _Book_ contains basic information about Book	
The relation _Author_ contains basic information about Author
The relation _Branch_ contains basic information about Branch
The relation _Holdings_ contains basic information about Holdings	
The relation _Borrower_ contains basic information about Borrower

onzfonz

group: some random data

description[[ the data for this dataset is for testing

The relation _T_ contains basic information about T	
The relation _S_ contains basic information about S

]]

S = {

onzfonz

group: Elmasri & Navathe Possible Library DB State

description[[ this is a potential set of data based on the Library Schema from the Elmasri & Navathe (Fundamentals of Database Systems Textbook) While it is based on the Schema, this is not from the book.

The relation _Book_ contains basic information about a book
The relation _Book_authors_ contains basic information about authors of books
The relation _Publisher_ contains basic information about a publisher
The relation _Book_copies_ contains information about the number of copies of a particular book
The relation _Book_loans_ contains information on Loans done at a library
The relation _Library Branch_ has simple information about one branch in a library system

onzfonz

group: Elmasri & Navathe Possible Airline DB State Figure 5.8

description[[ this is a potential set of data based on the Airline Schema from the Elmasri & Navathe (Fundamentals of Database Systems Textbook) While it is based on the Schema, this is not from the book.

The relation _Airport_ contains basic information about an airport	
The relation _Flight_ contains basic information about a complete flight route
The relation _Flight_Leg_ contains information about a flight segment within that route
The relation _Leg_instance_ contains information on a flight leg from a particular day
The relation _Fare_ contains information on a fare for a flight
The relation _Airplane_type_ has information about different airplane models

onzfonz

group: Elmasri & Navathe StudentCourse DB Figure 1.2

description[[ the data for this dataset was taken from the Elmasri & Navathe (Fundamentals of Database Systems Textbook) with some minor modifications

The relation _Student_ contains basic information about a student	
The relation _Course_ contains basic information about a course
The relation _Section_ contains information the different course sections
The relation _Grade_report_ contains info on grades students received in the course
The relation _Prerequisite_ contains information on course Prerequesites

onzfonz

group: Company DB Elmasri & Navathe Figure 5.6

description[[ the data for this dataset was taken from the Elmasri & Navathe (Fundamentals of Database Systems Textbook) with some minor modifications

The relation _Employee_ contains basic information about the employees at a company	
The relation _Dependent_ contains basic information about each employees dependents
The relation _Department_ contains basic information about the dept and its manager
The relation _Dept_Locations_ contains info on where each department has offices
The relation _Project_ contains basic information on each project and which dept it is in
The relation _Works_On_ contains information on how much each employee works on each project