CC 213 (E) Quiz

These are the rules that the DBMSs follow.

• Semantics

• Queries

• Domain

• Constraints

It describes the relationship between individual attributes.

• Referential Integrity

• Functional Dependency

• Domain Integrity

• Relational Design

SELECT *

FROM Employees

_____ Address _____ '33%'

• WHERE, IN

• WHERE, BETWEEN

• WHERE, LIKE

• WHERE, IS

This command allows allows the user to extract data from tables.

• SELECT

• INSERT

• UPDATE

• DELETE

If these are incorrect, the design will be incorrect; hence, the application built will not function as expected by the users.

• Business Constraints

• Enterprise Constraints

• Business Rules

• Enterprise Rules

_____

FROM Customers

WHERE CustomerName _____ 'Tres Delicious'

• SELECT, LIKE

• DELETE, LIKE

• UPDATE, LIKE

• INSERT, LIKE

In this type of relationship, foreign key cannot be null.

• Optional Relationship

• Identifying Relationship

• Non-identifying Relationship

• Mandatory Relationship

It is used to obtain information based on two related tables.

• Join

• Normalization

• Joint

• Normalize

What is the relationship between WRITER and BOOK?

• One to Many

• One to One

• Many to Many

• None of the choices

What is the mandatory relationship between EMPLOYEE and SPOUSE?

• One to Many

• One to One

• Many to Many

• None of the choices