The Basic Database Design workshop educates a user with the fundamental database design concepts and the best practices to achieve the same. This workshop aims at laying a sound foundational knowledge of databases before delving deep into the advanced features and their usage.

Problem Description


Every business, small or large, involves the use of a database which stores information of all kinds. The way a database is structured, affects every other action like ease of entering data into the database, efficiency of the database to trap inconsistencies and prevent duplicate records from being inserted, effective and flexible retrieval of information from the database, etc. Hence, the most crucial step in creating a sound database lies in designing the structure carefully.

Usage Scenario


The usage scenario pertains to an electronics store where a customer places an order for certain products he wishes to buy and the transaction is recorded in the database of the store. The database consists of tables that store the transaction information, product information as well as customer information.

Operation


The workshop aims to introduce some features that enable efficient creation of database tables and highlights some of the best practices associated with designing such a database and storing information.

Solution


The workshop demonstrates basic database concepts namely :

  1. Normalization
  2. Data type selection
  3. Table Constraints
  4. Indexes
  5. Table Joins
  6. Views
  7. Storage