Entities, and normalization, indexs

Question 1

Entity-relationship model

Answer 1

a visual way to design a database by showing the main parts (entities) and how they’re connected (relationships). It helps plan out the database structure before creating it.

Question 2

Cardinality

Answer 2

tells you how many connections or matches there can be between items in different tables.

Question 3

Normalization

Answer 3

the process of organizing data to reduce duplication and improve efficiency. The goal is to split data into related tables so that each piece of information is stored only once, avoiding repetition.

Question 4

Denormalization

Answer 4

is the process of adding some duplication back into the data to make it faster to read or retrieve. This can be helpful when you want to reduce the number of tables you have to join to get certain information.

Question 5

First Normal Form

Answer 5

making sure each cell has only one value and that each column is consistent, helping keep data clean and easy to work with.

Question 6

Second Normal Form

Answer 6

removing data that only relates to part of a composite key, organizing it better to avoid duplication and make the database more efficient.