TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

Database

Database Design Process

Overview

In this tutorial, we will learn about database design process. The database design process includes the following basic steps:

  • Database Requirements
  • Conceptual Design
  • Logical Design
  • Physical Schema

Database Requirements Collection

This phase consists of collecting and evaluating database requirements from various stake holders of the proposed system.

Conceptual design

In Conceptual Design we will study the business process and identify the entities, attributes and relationships among the entities. We can use tools represent the design in ER Diagram. CHEN and Crow Foot are popular notations.

Logical Design

Transform the conceptual design to a logical structure in the Relational model. In Logical design we will validate the model using Normalization forms 1NF, 2NF, 3NF, etc.

Physical Design

In Physical design we will create SQL statements for creating database tables, views, insert data, create stored procedures, etc.

 

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts

Database /

MS Access Data Types

SQLite

Database /

SQLite database introduction

Database /

Popular NoSQL Databases

Database /

Database Characteristics

3-Tier Architecture

Database /

3-Tier Architecture

‹ SQL SubQuery› Entity-Relationship Model

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version