Relational Data

Recognize the following that hold a single value attribute

• Address

• Register number

• Reference

• Subject_taken

In relational data model, the total number of rows can be identified as ______________________ .

• Cardinality

• Degree

• Attribute

• Entity

Identify the total number of attributes in a relational data model.

• Tuple

• Entity

• Degree

• Cardinality

Identify the candidate key.

• W

• X

• Y

• Z

One attributes divided into smaller subparts such as address consist of street,postcode, city. Identify the types of attributes?

• Simple Attributes

• Composite attributes

• Single Valued Attributes

• Multivalued Attributes

An attribute whose value is calculated (derived) from other attributes. Choose the correct attributes based on the information given.

• Registration Number

• IC Number

• Certificates

• Date of Birth

If related data exists in more than one table, they can be joined by using the Primary Key link to the same key in the other table. Identify this key.

• Foreign Key

• Primary Key

• Candidate Key

• Composite Key

Based on the table given, identify the relation name.

• AccoundID

• Car Loan

• Account

• Balance

In relational data model, the total number of attributes can be identified as ______________________ .

• Cardinality

• Degree

• Tuple

• Entity