Introduction to Database

What is a database?

• It is a database engine/system based on relational model.

• The ANSI standard language for operating relational tables

• A collection of information/objects/tables

• It contains information that describes the data for the individual record.

What is a Primary Key?

• It is a key composed of columns that actually have a logical relationship to other columns within a table.

• It is a key used to link two tables together

• It is a technique which organizes tables in a manner that reduces redundancy and dependency of data.

• It consists of one or more columns whose data contained within is used to uniquely identify each row in the table.

Column in a table also known as

• Attribute

• Entity

• Record

• Relationship

Following are the relationship type, except

• One-to-zero relationship

• One-to-one relationship

• Ont-to-many relationship

• Many-to-many relationship

Identify the types of Data Anomalies:

• Add, Delete and Save anomalies

• Insert, Add and Save anomalies

• Update, Save and Insert anomalies

• Insert, Delete and Update anomalies

Normalization consists of First Normal Form, Second Normal Form and ?

• Second and a half Normal Form

• Three Normal Form

• Third Normal Form

• Zero Normal Form

Which one of these do we wan to avoid in good database design?

• Data

• Redundancy

• Normalization

• RDBMS

Which of the following is NOT an example of a database?

• telephone book

• real estate listing

• online library catalog

• DVD

Which is the best example of a Primary Key?

• Price

• Name

• Address

• IC No

SQL stands for

• structured query language

• structured question language

• sustainable query language

• sustainable question language