The BigUniversityRDB
repository contains SQL DDL, DML, and supporting documentation for the University Database Schema presented by Silberschatz et al in Database System Concepts (6th edition) McGraw Hill, 2010.
To understand the scope and semantics of these scripts, make sure to first see the contents of the SmallUniversityRDB Github repository.
Important: the schema for the large database is identical to that of the small database, except that the small database tables have an appended "_s" for all table names
- LargeRDBTableSizes.png: describes the size of the database tables
- README.md: this file
- largeDDLAndDrop.sql: DDL for deleting and creating the schema
- largeRelationsInsertFile.sql: the population script
Per the authors: "The ο¬le largeRelationsInsertFile.sql contains SQL insert statements for larger, randomly created relations for a truly strange university (since course titles and department names are chosen randomly)."
The size of the "large' database tables are shown below.
The authors claim that these scripts should run for "most databases other than MySQL". I have tried them only for PostgreSQL 11, but see no reason why they can't run successfully on "most other databases".
With Postgres, you can invoke a script thusly:
psql -f file.sql