Relational Databases

Question 1

What are Relational Databases?

Answer 1

• Are Databases with tables that have been organized with rows and columns (rows and fields).
• Contain rigid schema (rows=records and columns=fields) that define a relationship within a database table.

Question 2

What is the point of a table within a database?

Answer 2

It provides data on single subject or topic.

Question 3

What is the point of a row and column within a table in a database?

Answer 3

• Row (Record) provides a particular instance within a subject.
• Column (Field) provides a characteristic of a table subject.

Question 4

What is a primary and foreign key within a database?

Answer 4

• Primary key is a unique row(record) entry within a database table.
• Foreign Key is defines or links the relationship between two tables; the link is usually same (column or fields) within a table.

Question 5

What is a contraint within a table in a database?

Answer 5

• Are business rules that are maintained and enforced by the database.
• Enforcing a condition applied on data stored within a table.

Question 6

What are a few examples of RDBMS?

Answer 6

• Oracle Database
• Microsoft SQL
• MySQL
• Microsoft Office Access