sad

What is an entity? | A person, place, activity, or thing represented in a database. Ex: Person, Course, Product

What is a relationship? | A link between two entities. Ex: Student enrolls in Course

What is an attribute? | A descriptive property of an entity. Ex: Student has Name, GPA

What phase are entities, relationships, and attributes defined in? | Conceptual design (analysis)

What does logical design convert entities into? | Tables

What does logical design convert relationships into? | Foreign keys

What does logical design convert attributes into? | Columns

What is a table? | A named structure with a fixed set of columns and a varying set of rows

What is a column? | A named field with a specific data type

What is a row? | An unnamed tuple of values corresponding to each column

What is a primary key? | A column or group of columns used to uniquely identify a row

What is a foreign key? | A column that references a primary key in another table

What is a composite primary key? | A primary key made up of multiple columns that together form a unique identifier

What is a candidate key? | A simple or composite column that is unique and minimal — one will be chosen as the primary key

What is data independence? | The principle that changing physical design never affects query results, only speed