Data Relational Model1

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

What is data types?

• It specifies what type of data is expected inside of each column in a table (ef. number, date, string)
• It specifies how many tables you will create when you convert your Entity Relations Model to a Logical Data Model
• It specifies the database-name
• It counts how many attributes you have

What does the data-type INT contain

• Whole numbers
• Decimal numbers
• Characters
• Date

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

What language does the Relational Model use?

• Java
• Python
• SQL
• C++

What is SQL?

• Structured Query Language
• Suitable Query Language
• Sustainable Question Language
• Suitable Question Language