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.