Database DesignThinking in entitiesLesson 17 / 69

Entities & attributes

Fill-gap20 min

Entities & attributes

An entity is a noun worth remembering: a User, a Lesson, an Order. An attribute is a fact about it: a user has an email, a lesson has a duration.

The design move is spotting entities inside a sentence:

> "A student enrolls in a course and submits answers to its lessons."

Entities: Student, Course, Lesson, Enrollment, Answer. Notice "enrolls" and "submits" are verbs — they become relationships, not tables, unless they carry data of their own (Enrollment does: the date).

Exercise

From "a customer places orders that contain products and a shipping address", list the entities and each one's three most important attributes.