company-database

This is a physical SQLite representation of the COMPANY database used several times in "Fundamentals of Database Systems".

How to Use

These files are to be used in a database management system, such as sqliteonline or DataGrip. There are three ways to open and load the database:

• Open the binary database file (schemas/company.db)
• To create the tables and fill in the data all in one step, load schemas/master.sql into the DBMS and run the SQL queries.
• To separately create the tables and fill in data, first load schemas/schema.sql into the DBMS and run the SQL queries. Then, you can either:
  • Import the CSV files (located in data-csv/) (using the file name as the table name, the first line as column names, , as the delimiter character, and " as the escape character)
  • Import the SQL schemas (located in data-sql/) for the different tables, and run the queries
  • Fill in your own data using whichever method you prefer.
  • You can mix and match these options for each table!