Here is the SQL script for populating the demographic data toy database.
For these exercises you need to create a toy database with employees and departments.
For these exercises you need to create a toy database with sailors and boats.
For these exercises you may want to use some sample code to access a database.
For these exercises you need to create random instances for the tables of the employees database.
Here is a script for the creation of the tables.
These are the Java files RandomData, RandomDept, RandomEmp, PrintRandomDeptsAndEmps, which can be used to create files with random instance data for the tables.
The files can then be bulk loaded with the PostgreSQL copy command.
(Note that the previous version of the employees db would not work because the scripts generate strings for some columns that could not be stored.)
Finally, you will create indexes on those tables.