The Restaurant Data Model is structured into the following Subject Areas:

• Subject Area: CUSTOMER
• Subject Area: STORE
• Subject Area: EMPLOYEE AND ROLE
• Subject area: MENU
• Subject Area: PRICE AND DISCOUNT
• Subject Area: ORDER
• Subject Area: PAYMENT AND INVOICE
• Subject Area: DOCUMENT

The Online Food Ordering Data Model is structured into the following Subject Areas:

• Subject Area: CUSTOMER
• Subject Area: STORE
• Subject Area: EMPLOYEE AND ROLE
• Subject area: MENU
• Subject Area: PRICE AND DISCOUNT
• Subject Area: ORDER
• Subject Area: PAYMENT AND INVOICE
• Subject Area: DOCUMENT

Each data model is delivered as a .ZIP archive also called a DataModelPack.

To start using a DataModelPack you will need to download and install it.

The installation steps and requirements are the same for all data models.

Operating System
Windows 10 or higher (32 or 64 bits) to unzip the DataModelPack archive.

Files Disk Space
Depending on the complexity of the data model an average of 25 Mb of free disk space per data model are needed for archive download and unzip.

Database
You need a database instance up and running and a database admin account to deploy the SQL scripts into the database.
For all License editions, the .ZIP archive will contain SQL scripts to create / drop the database schema objects for the following databases: MySQL, MS SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere.

Database Disk Space
Depending on the complexity of the data model and the database engine an average of 50 Mb of free disk space per data model schema is needed to deploy the SQL scripts into the database.

DEMO edition download steps:

• Go to Data Models page
• Navigate to the Data Model you want to download the Demo edition
• Press Demo button
• Your data model Demo page opens. Read carefully the Terms of Use
• Press Download Demo_[data_model] button to Download your Demo copy of the data model.
• Extract the files from the Demo .ZIP archive

LICENSE editions download steps:

• Go to Data Models page
• Navigate to the Data Model you want to download
• Press Purchase button
• Your data model Purchase page opens. Read carefully the License Agreement and the price details
• Press Purchase STANDARD or Purchase PROFESSIONAL buttons to Purchase and Download your licensed copy of the data model.
• Extract the files from the .ZIP archive:

  • Logical Data Model Diagram [PDF]

  • Physical Data Model Diagram [PDF]

  • SQL scripts to create the database schema objects for all major databases: MySQL, MS SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere etc. [SQL]

Main steps to create the database schema objects:

• Create a new empty database schema. For example the SQL command to create a new empty database schema in the MySQL is:

  create schema 'schema_name';

• Open your SQL management console and connect to the new database schema.
• Open the [data_model_name]_MySQL_Create.sql file in your SQL management console.
• Run the [data_model_name]_MySQL_Create.sql file to create the data model objects in the database schema.

If you need to delete the database schema objects:

• Open your SQL management console and connect to the new database schema.
• Open the [data_model_name]_MySQL_Drop.sql file in your SQL management console.
• Run the [data_model_name]_MySQL_Drop.sql file to drop all the data model objects from the database schema.

Follow similar steps to create the database schema objects for all supported database engines: MS SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere. Your licensed copy of the .ZIP archive contains specific Create / Drop SQL scripts for all these databases:

[data_model_name]_MS_SQL_Server_Create.sql

[data_model_name]_MS_SQL_Server_Drop.sql

[data_model_name]_Oracle_Create.sql

[data_model_name]_Oracle_Drop.sql

[data_model_name]_PostgreSQL_Create.sql

[data_model_name]_PostgreSQL_Drop.sql

[data_model_name]_Sybase_SQL_Anywhere_Create.sql

[data_model_name]_Sybase_SQL_Anywhere_Drop.sql