Data Modeling and Relational Database Design - Part 1

Do you want to understand and design database diagrams? Do you want to develop software that interacts with a database ?

If the answer is yes then you are in the right place, This series of articles is about database design, converting physical business model into database model (database structure), how to do that and the tools used to do that.

Before going on , first we will explore some database modeling defintions and concepts that we will face .

Database.

A database  is a set of tools used to collect, store and manage data. Database has many forms some are paper like records  and some are electronic which used on computers.
Even the electronic database has many forms some are registered on flat files (like text files), some uses spreadsheet files (like Excel - LiberOffice calc) and some use a special software called Database Management System DBMS that used to manage the database.

 

Database Management System DBMS.

Is a software that is used to manage database and store and retrieve database data.
There are many Database Management Systems DBMS, Some are commercial Database Management Systems DBMS like Oracle, MS SQL sever, DB2, SyBase and others, Some are Open Source Database Management Systems DBMS like PostgreSQL, MariaDB, SQLite and many others.

 

Database Modeling.

Database modeling is a paradigm used to create a database structure related to a business or physical object, At the end of the process this structure will be used to store the data related to that business or object.

Many paradigms are used to create database model some are like hierarchical model, network model, But our main interest will be concentrated on the Relational Database Model .

Relational Database Model.

In this model the database structure - Structure used to store data - is constructed from a set of related tables -These tables are the data storage units. In the stage of modeling the table is called "Entity".

Conceptual Model.

The conceptual model is an imagination or simulation for the system represented by the model.

Why using Conceptual Model ?

  • Conceptual Model helps understanding the business requirements accurately.

  • Conceptual Model helps to prevent mistakes and misunderstand.
  • Conceptual Model makes it easy to discuss and understand the system model.
  • Conceptual Model constructs the base structure of  physical database.

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
17 + 3 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.