Fundamentals of Database System

UGRD-ITE6100B Fundamentals of Database System
(MidQ-1, 2, Midterm)

 


Question text

Indirect relationship causes functional dependency.

Question text

Matching Type

Common Data Types

Character

Date

Boolean

Numeric

Question text

Matching Type

Normal Forms

NO “repeating groups” (columns)


NO Transitive Dependency


Multi-value dependency

NO Partial Dependency


It is a stricter form of 2nd and 3rd normal form


Question text

Matching Type
Relational database schema commonly defines:

Tables

Constraints

Columns

Question text

A non-key attribute is dependent on part of a composite primary key.

Question text

A process of producing a set of tables (relations) with a proper attribute.

Question text

The table is in a 1NF if It satisfies the definition of a relation.


Select one:

Question text

The table is in a 2NF if there's NO Partial Dependency.

Select one:

Question text

No primary key can be null.

Select one:

Question text

Null means a value is unknown.

Select one:

Question text

Null means zero

Select one:

Question text

Matching Type

A single entity instance of one entity class is related to a multiple entity instance of another entity class.

The participation of an entity in the relationship is mandatory.

A single entity instance of one entity class is related to a single entity instance of another entity class.

Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.


The participation of an entity in the relationship is optional.

Question text

Matching Type

Table definition

All possible column values

Row

Column header / field

Table

Question text

Entities can be related indirectly by two (2) relationships.


Question text

It is the number of attributes in a relation.

Question text

Its is one or more columns of a relation or table that is used to identify a record.

Question text

It is the number of tuples in a relation.


Question text

This relationship exists if they are independent or different to each other.


Question text

Relationships can't have attributes.


Select one:

Question text

Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship.

Select one:

Question text

Maximum Cardinality describes the maximum number of entity instances in the relationship.

Select one:

Question text

Relational Model is a table with columns and rows.

Select one:

Question text

The relational model (RM) was first described by Edgar F. Codd

Select one:

Question text

Null means zero

Select one:

Question text

Matching Type

Normal Forms

NO Partial Dependency


NO “repeating groups” (columns)


Multi-value dependency

NO Transitive Dependency


It is a stricter form of 2nd and 3rd normal form


Question text

No primary key can be null.

Select one:

Question text

Matching Type
Relational database schema commonly defines:

Constraints

Tables

Columns

Question text

Indirect relationship causes functional dependency.

Question text

The table is in a 2NF if there's NO Partial Dependency.

Select one:

Question text

A process of producing a set of tables (relations) with a proper attribute.

Question text

The table is in a 1NF if It satisfies the definition of a relation.


Select one:

Question text

A non-key attribute is dependent on part of a composite primary key.

Question text

Null means a value is unknown.

Select one:

Question text

Matching Type

Common Data Types

Date

Character

Boolean

Numeric

Question text

The relational model (RM) was first described by Edgar F. Codd

Select one:
 

Question text

Matching Type

Column header / field

 

Table

 

Row

 

Table definition

 

All possible column values

 

Feedback

Question text

It is the number of attributes in a relation.

Question text

Relational Model is a table with columns and rows.

Select one:
 

Question text

Entities can be related indirectly by two (2) relationships.


Question text

Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship.

Select one:
 

Question text

This relationship exists if they are independent or different to each other.


Question text

Relationships can't have attributes.


Select one:

Question text

Its is one or more columns of a relation or table that is used to identify a record.

Question text

Maximum Cardinality describes the maximum number of entity instances in the relationship.

Select one:
 

Question text

It is the number of tuples in a relation.


Question text

Matching Type

The participation of an entity in the relationship is optional.

 

Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.


 

A single entity instance of one entity class is related to a single entity instance of another entity class.

 

The participation of an entity in the relationship is mandatory.

 

A single entity instance of one entity class is related to a multiple entity instance of another entity class.

 

Feedback