ITF102-Database Design

RDBMS is an acronym for

• Relational Database Merging System

• Relational Database

• Relational Database Management System

• Relational Database Manipulation System

Answer explanation

Relational Database Management System

What entity type is used in the given diagram?

• Student

• Doctor

• Employee

• Course

Which attribute is the COMPOSITE ATTRIBUTE?

• Degree

• Salary

• Age

• Address

Key which uniquely identifies each record in an entity?

• Foreign key

• Primary key or key identifier

• Secondary key

• Composite key

Diamond shaped symbol in ERD is for

• Cardinality

• Entity

• Relationship

• Attribute

Which SQL reserved keyword do you use to combine data from two or more tables, based on a common field between them?

• using SELECT

• using WHERE

• using JOIN

• using GET

Which character returns all the data found in a table?

• %

• #

• *

• /

How would you display Chairs in the Items table that have a Price greater than $50.

• Select * from Items where type='Chair' and price > 50

• Select * from Items where type='Chair' or price > 50

• Select * from Items where price > 50

• Select * from Items where type='Chair' and price >= 50

Choose CORRECT symbol of SELECT in Relational Algebra

• x

The ____ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.

• Difference

• Union

• Intersection

• Set difference