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.