Software Development Lifecycle (SDLC): End-to-End Overview

What is Database Design?

Database design defines how data will be structured, stored, and accessed in the system.

Good database design ensures Efficient data storage, Fast queries and Data consistency

Key Concepts of Database Design are:

Table: to represents an entity

Columns represents attributes of the entity

Primary Key: Unique identifier for each record.

Foreign Key: Links two tables together.

What is Entity Relationship (ER) Diagram

An ER Diagram visually represents relationships between entities.

ER Diagram Components:

Entity: Represents an object. Example: Student, Course

Attribute: Properties of an entity. Example: name, email

Relationship: Connection between entities. Example : Student enrolls in Course.