Lecture #2

Question 1

Explain the relational Data Model.

Answer 1

A collection of inter-related tables where the data in each table is organized and each table has rows representing individual records and columns representing specific data fields, esnuring structured and efficient management of data.

Question 2

Another name for row or record.

Answer 2

Tuple

Question 3

Another name for a column.

Answer 3

Field or Attribute

Question 4

What does the Degree of the table represent?

Answer 4

The number of attributes in the table.

Question 5

What are the basic Building blocks of Data modelling?

Answer 5

• Entities
• Attribute
• Relationships
• constraints

Question 6

Explain Independent Entities.

Answer 6

Independent tables that store data, each with its own structure and typically linked through relationships defined by keys.

Question 7

Explain Dependent Entities.

Answer 7

Refers to tables that rely on relationships with other tables to exist or function correctly.

Question 8

Explain Characteristic Entities.

Answer 8

Tables that represent distinct attributes or properties of another entity.

Question 9

What is a primary Key?

Answer 9

A column or set of columns in a table whose values uniquely identify each row in that table.

Question 10

What is a foreign key ?

Answer 10

A column or a set of columns in one table that refers to the primary key in another table.