EXERCISE_RELATIONALDATABASE

Below are the type of key(s) available in RDBM EXCEPT

• Superkey

• Candidate key

• Primary key

• Composer key

Below are the characteristics of a Relational Table EXCEPT

• A table is perceived as a two-dimensional structure composed of rows and columns.

• Each table row(tuple) represents a single entity occurrence within the entity set.

• Each table column represents an attribute.

• All values in a column may have different data format.

In the table above, which one is Primary Key?

• firstName

• lastName

• StudentID

The order of rows and columns is important to the DBMS.

• True

• False

What is the heart of the Relational Database Model?

• A collection of rows

• A collection of columns

• A collection of attributes

• A collection of tables

All Primary Key entries are unique, and no part of a primary key may be null

• Entity Integrity

• Referrential Integrity

Complete the sentence below.

A _____ is a row in a database table. This is also known as a record.

• Tuple

• Degree

• Relation

• Domain

Jimmy is planning to name the relations depending on their content. What is a relation in a database?

• Attribute

• Table

• Row

• Column

Complete the sentence below.

The _____ is all the possible allowable values for an attribute.

• Cardinality

• Domain

• Tuples

• Table

RDBMS stands for

• Relation Database Management System

• Relational Database Management System

• Related Database Management System

• Random Database Management System