Manipulating Data Using DBMS GUI

Question 1

It can be one, stand-alone table that can contain many fields of information.

Answer 1

Database

Question 2

The simplest, yet least powerful type of database and is often referred to as a “flat” database.

Answer 2

Database

Question 3

Many tables that are linked through common fields and can ensure greater accuracy and less input of data.

Answer 3

Relational Databases

Question 4

Increase flexibility of data and allow ease of collecting and maintaining historical data.

Answer 4

Relational Databases

Question 5

These are one-to-one and one-to-many relationships.

Answer 5

Relationships

Question 6

This relationship ensures that one record in one table has a (and only one) matching record in another table.

Answer 6

One-to-one Relationship

Question 7

This relationships allow one record in one table and many records in another table.

Answer 7

One-to-many Relationship

Question 8

These objects generally are tables, queries, forms, and reports.

Answer 8

Database Objects

Question 9

These objects provide functionality and power to your database information.

Answer 9

Database Objects

Question 10

It contains or holds the data.

Answer 10

Table (Entity)

Question 11

It can limit the types of data in fields and can assist in the integrity and accuracy of data.

Answer 11

Table

Question 12

It is a collection of fields for an item you are tracking.

Answer 12

Record

Question 13

It is a single row that consists of multiple fields.

Answer 13

Record

Question 14

These are the different characteristics (attributes) within a Table.

Answer 14

Fields

Question 15

It is the lowest level of data in a database.

Answer 15

Field

Question 16

It consists of information about the item you are tracking.

Answer 16

Field

Question 17

General guidelines in naming any data project

Answer 17

Relate to business, not technical characteristics.
Be meaningful, must be to the point
Readable
Be Unique  
Follow rules in naming a variable

Question 18

It is an attribute that cannot be divided into smaller independent attributes. For example, the age (attribute) of a student (entity) cannot further be divided.

Answer 18

Atomic Attribute

Question 19

It is an attribute that can be divided into smaller independent attribute. The address (attribute) of student (entity) can be further be divided into House no, city and so on.

Answer 19

Composite Attribute

Question 20

It is an attribute that has only single value for an entity. The age (attribute) of a student (entity) can have only one value.

Answer 20

Single-valued Attribute

Question 21

It is an attribute that can have multiple values for an entity. The Phone no (attribute) of a student (entity) can have multiple values because a student may have many phone numbers.

Answer 21

Multiple-valued Attribute

Question 22

It is an attribute that cannot be derived from another attribute. For example, birth date cannot derive from age of student.

Answer 22

Stored Attribute

Question 23

It is an attribute that can be derived from another attribute. For example, age can be derived from the birth date of the student.

Answer 23

Derived Attribute

Question 24

It is an attribute that has no value for an entity. For example, there may be a chance when a student has no phone no.

Answer 24

Null-valued Attribute

Question 25

An attribute that has a unique value for each entity. For example, every student has a unique student no.

Answer 25

Key Attribute