Answer
See explanation
Work Step by Step
Transforming entities into tables is a key step in designing a relational database.
1. Entity Becomes a Table
An entity represents a real-world object or concept—like Student, Course, or Employee. When designing a database, each entity is mapped to a table.
The name of the entity becomes the name of the table.
2. Attributes Become Columns
Each attribute of the entity becomes a column in the table.
3. Primary Key Is Defined
Every table needs a primary key—a unique identifier for each row.
4. Relationships Are Represented
If entities are related (e.g., a student enrolls in a course), those relationships are represented using foreign keys or junction tables.
A foreign key is a column that links to the primary key of another table.
For many-to-many relationships, a junction table is created to connect two entities.
