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 Plan

Overview

In this tutorial, we will learn to construct a Database Design Plan. A database is a container for the database objects. We must first prepare a plan when creating a new database.

Database Design Plan

 

Database Design Plan

 

The design plan should answer many important decisions regarding the database.

  • The primary purpose of this database.
  • Entities that need to be stored in the database, their attributes, and data types.
  • How do the entities relate to each other? Establish relationships between entities.
  • Database Normalization process.
  • Database Creation scripts.
  • Execute the scripts on the MySQL database server.

 

List entities and their attributes. Identify the appropriate data type for each attribute of the table. Establish relationships between the entities and the cardinality.

Normalization is a technique that is used as a guide in designing relational databases. Normalization removes data redundancy and anomalies. Normalization process of decomposition of complex tables into a set of smaller tables.

Normalization removes undesirable multi-valued attributes and repeating groups within rows and data redundancy within columns. There are various levels of the normalization process.

—

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

SQLite

Database /

SQLite database introduction

Database /

Popular NoSQL Databases

world database ERD

Database /

Entity-Relationship Model

Database /

Database Design Process

SQL Sub Query

Database /

SQL SubQuery

‹ Database Modeling› SQL Questions for Beginners

Recent Posts

  • Update draw.io on Windows
  • 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