GST Billing Software

header image

Database Structure and Design

Erachana Line

SL No.

Contents

1

Introduction

1.1

What is Data?

1.2

What is Database?

1.3

What is a Database Management System (DBMS)?

2

Database Basics

2.1

Database Architecture

2.1.1

Three-Tier Architecture

2.2

Database Concepts

2.3

Database Schema

3

Database Management System Basics

3.1

Components of DBMS

3.2

Types of DBMS

3.2.1

Relational DBMS

3.2.2

Hierarchical DBMS

3.2.3

Network DBMS

3.2.4

Object Oriented DBMS

4

Database Design

4.1

What is Database Design?

4.2

Why Database Design is Important?

4.3

Database development life cycle

5

Database Design Relationship

5.1

One-to-One

5.2

One-to-Many (or Many-to-One)

5.3

Many-to-Many

5.4

Assignment

6

Database Modelling

6.1

Database Normalization

6.1.1

First Normal Form

6.1.2

Second Normal Form

6.1.3

Third Normal Form

6.1.4

Boyce-Codd Normal Form (BCNF)

6.1.5

Domain Key Normal Form (DKNF)

6.1.6

Assignment

6.2

Entity-Relation Modelling

6.2.1

Entity

6.2.2

Relationship

6.2.3

Participation Constraints

6.2.4

Assignment

7

Summary