Download Latest Version
java-cup-11a-runtime.jar (13.3 kB)
Get an email when there's a new version of Relational Algebra for MySQL
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| dloc.dat | 2016-02-03 | 192 Bytes | |
| employee.dat | 2016-02-03 | 4.1 kB | |
| employee.sql | 2016-02-03 | 408 Bytes | |
| load-department.sql | 2016-02-03 | 106 Bytes | |
| load-dependent.sql | 2016-02-03 | 106 Bytes | |
| load-dloc.sql | 2016-02-03 | 106 Bytes | |
| load-employee.sql | 2016-02-03 | 104 Bytes | |
| load-projects.sql | 2016-02-03 | 104 Bytes | |
| load-worksOn.sql | 2016-02-03 | 102 Bytes | |
| projects.dat | 2016-02-03 | 385 Bytes | |
| projects.sql | 2016-02-03 | 263 Bytes | |
| README.md | 2016-02-03 | 675 Bytes | |
| source.sql | 2016-02-03 | 332 Bytes | |
| worksOn.dat | 2016-02-03 | 1.1 kB | |
| worksOn.sql | 2016-02-03 | 232 Bytes | |
| department.dat | 2016-02-03 | 247 Bytes | |
| department.sql | 2016-02-03 | 210 Bytes | |
| dependent.dat | 2016-02-03 | 504 Bytes | |
| dependent.sql | 2016-02-03 | 264 Bytes | |
| dept_locations.sql | 2016-02-03 | 200 Bytes | |
| Totals: 20 Items | 9.8 kB | 0 | |
Sample Company Database
There are three files for each table in this directory. For example for the DEPARTMENT table the three files are:
- department.sql: contains the SQL Create Table statement to create the table.
- department.dat: contains data for the table to be loaded using the MySQL load command.
- load-department.sql: contains the LOAD command to load data into the table.
The file, source.sql, contains MySQL "source" commands to execute the "create table" and "load" commands for each table.
After signing in to MySQL and changing to "company" database, simply run the following command to create and populate the tables:
mysql> source source.sql
