Data Model: Car Service

Overview

Top

The Car Service Data Model is structured into the following Subject Areas:

Navigate to each Subject Area to learn about the Dictionary of Entities and Attributes.

Subject Area: CUSTOMER Subject Area: SHOP Subject Area: EMPLOYEE AND ROLE Subject area: VEHICLE Subject area: SERVICE Subject Area: PRICE AND DISCOUNT Subject Area: ORDER Subject Area: PAYMENT AND INVOICE Subject Area: MEDIA

Learn more about the main Process steps and how to achieve your specific objectives with the Car Service Data Model.

ORDER Process and Status

Car Service ORDER Process and Status

Data Model: Online Food Ordering

Overview

Top

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

Navigate to each Subject Area to learn about the Dictionary of Entities and Attributes.

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

Learn more about the main Process steps and how to achieve your specific objectives with the Online Food Ordering Data Model.

ORDER Process and Status

Online Food Ordering ORDER Process and Status

Data Model: Restaurant

Overview

Top

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

Navigate to each Subject Area to learn about the Dictionary of Entities and Attributes.

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

Learn more about the main Process steps and how to achieve your specific objectives with the Restaurant Data Model.

ORDER Process and Status

Restaurant ORDER Process and Status

Installation

Overview

Top

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.

Requirements

Top

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.

Download

Top

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]

Create Database Schema

Top

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

Top