Able to explain how data is modeled in a database

Question 1

In a database

Answer 1

In a database,

• data is organized and structured using a concept called data modeling.
• Data modeling is like creating a blueprint or a plan for how the data should be stored and related to each other.

Question 2

The most commonly used data model

Answer 2

• The most commonly used data model is the relational model.
• Imagine a table with rows(records) and columns, just like a spreadsheet.
• In a database, we create tables to represent different types of data.
• Each table has columns that define the specific attributes
  • or properties of the data, such as a person’s name, age, or email address.

Question 3

To establish relationships between different tables, we use keys

Answer 3

• To establish relationships between different tables, we use keys.
• A primary key uniquely identifies each row in a table.

   - For example, in a table of employees, the employee ID could be the primary key.

• We can then refer to this primary key in other tables to establish relationships. This is called a foreign key.