IT 214

An attribute that cannot be divided in simpler parts that have a different semantic meaning in the real world is know as:

Simple Attribute

______ relationship exists when the PK of the related entity contains a PK component of the parent entity.

Strong

Example of relationship. An album contains one or more tracks. Does this example has correct notation for the relationships name?

True

The supertype and its sutype(s) depicted in the specialization hierachy maintain a one-to-many(1:M)

Wrong

A duplicated value attribute that must have the same value for two entity instances already defined.

Wrong: A Duplicated value attrivute is an attribute that may have the same value for two entity instances (already defined or to be defined in the future)

A new entity, called the bridge entity, is created to represent a 1:M relationship

Wrong: A new entity, called the bridge entity is created to represent the M:M relationship

A new entity, called the bridge entity, is created to represent a 1:1 relationship.

Wrong: A new entity, called the bridge entity, is created to represent the M:M relationship.

A table is said to be in the Third Normal Form when , it is in a second normal form and it has transitive dependency

Wrong: A table is said to be in the Third Normal Form when, it is in the Second Normal Form and it DOESN'T have Transitive Dependency

Crow's foot notation depicts the strong (identifying) relationship with a 'dashed' line between the entities

Wrong: Crow's foot notation is depicted with a solid line between entities.

Entity(E1) is 'optional' if for any entity instance of Entity (E2) there must be a corresponding entity instance of Entity(E1) for the relationship R.

Wrong: E1 is mandatory if for any entity instance of E2 there must be a corresponding enttiy instance of Entity (E1) for the relationship R.

For the entity CAR the attribute cost is an example of a composite attribute.

Wrong: For the entity CAR the attribute cost is an example of a simple attribute, because it is a number and cannot be divided in simpler parts that have a different semantic meaning in the real world.

In one-to-many relationship type, several entity instances may be in relation with one entity instance.

Wrong: In one-to-many relationship type, one entity instance is in relation with many entity instances

Supertype entity is an entity type that has got relationship with one or more subtypes and it contains attributes that are not common to its subtypes

Wrong: Supertype entity is an entity type that has got relationsbip with one or more subtypes and it contains attributes that are common to its subtypes.

Supertype entity is an entity type that has got relationship with one or more subtypes and it contains attributes are not common to its subtypes.

Wrong: Supertype entity is an entity type that has got relationship with one or more subtypes and it contains attributes that are common to its subtypes.

Supertype entity is an entity type that has got relationship with one or more subtypes and it contains attributes that are not common to its subtypes

Wrong: Supertype enttiy is an entity type that has got relationship with one or more subtypes and it contains attributes that ARE common to its subtypes.

The entities that participate in a relationship are not know as participants.

Wrong: The entities that participate in a relationship are also known as partipants.

The table is in 1NF if it contains a primary key and repeating groups of data.

Wrong: The table is in 1NF if it contains a primary key and repeating groups of data.

the table is in 1NF if its contains a primary key and repeating groups of data

Wrong: The table is in 1NF if it contains a primary key and repeating groups of data.

The table is in 2NF if it is in 1NF and partial dependences also exist

Wrong: The table is in 2NF if it is in 1NF and NO partial dependences exist.

The title of a course is an example of a multi-value attribute

Wrong: The title of a course is an example of a single-valued attribute, because any course has a single title.

The gender of a person is an example of a multi-value attribute.

Wrong: This is a single-value attribute because any person has a single gender (uh oh this is controversial)

First Normal Form (1NF) has one or more repeating groups, no primary key and multi value cells.

Wrong: UNF has one or more repeating groups, no primary key and multi value cells.

Unnormalized form has non repeating groups and single value cells

Wrong: Unnormalized form has ONE OR MORE repeating groups and multi value cells.

First normal form (1NF) has one or more repeating groups, no priary key and multi value cells.

Wrong: Unnormalized form has one or more repeating groups, no primary key and multi value cells.

Unnormalized form (UNF) has non repeating groups and single value cells.

Wrong: Unnormalized form has one or more repeating groups.

When a bridge entity is created to solve M:M relationships, two 1:M relationships between the bridge and the original entities are created

Wrong: When a bridge is created to solve M:M relationships, two 1:M relationships between the original entities and the BRIDGE entity are created

While naming entities if the name uses multiple words, separate them by semicolon

Wrong: While naming entities if the name uses multiple words, separate them by space.

When a brdige entity is created to solve M:M relationships, two 1:M relationships between the bridge and the original entities are created

Wrong: when a bridge enttiy is created to solve M:M relationships, two 1:M relationships between the original entities and the BRIDGE entity are created

Third normal form is based on the concept of _______:

a. transitive dependency b. closure dependency c. functional dependency d. normal dependency e. total dependency a. transitive dependency

The extended entity relation model is the result of adding more semantic constructs to the original ________ model

entity relationship

A 'biological' father (Entity 1) is father of several children and a child (Entity 2) has a single 'biological' father (Entity 1). The relationship 'is father' is an example of _______ relationship type.

one to many

Some entity instances may not have a value for _____ attributes

optional

the entities that participate in a relationship are also known as

participants

A _______ is a field in a table which uniquely identified each row/record in a database table.

primary key: is a field ina table which uniquely identified each row/record in a database table.

A(n) ______ attribute that has at most a single value for any given entity instance.

single valued

______ entities are subgroups of the supertype entity and have unique attributes, but they will be different from each subtype.

subtype

A _____ entity is an entity type that has got relationship with one or more subtypes and it contains attrivutes that are common to its subtypes.

supertype

A _______relationship exists when three entities are associated.

ternary

Types of relationships

unary: exists when an association is maintained within a single entity binary: exists when an association is maintained within two entities ternary: exists when an association is maintained within three different entities

_____ normal form has one or more repeating groups, no primary key and multi value cells.

unnormalized

The property of ______ enables an entity subtype to inherit the attributes and relationships of the supertype.

Inheritance: the property of inheritance enables an entity subtype to inherit the attributes and relationships of the supertype.

A DIVISION is managed by an EMPLOYEE is an example of passive verb relationship name

Right

A PROFESSOR teaches a class is an example of passive verb relationship

Right

A binary relationship exists when two entities are associated.

Right

A foreign key is a field or collection of fields in one table that uniquely identifies a row of another table or the same table

Right

A relationship degree indicated the number of entities or participants associated with a relationship

Right

A required attribute is an attribute that must have a vlaue for. all entity instances (already defined or to be defined in the future)

Right

A strong relationship is also known as identifying relationship

Right

A subtype discriminator is the attribute in the supertype eneity that determines to which subtype the supertype occurrence is related.

Right

A ternary relationship exists when three entities are associated.

Right

A unary relationship exists when an association is maintained within a single entity

Right

Attributes can be defined as properties of entities

Right

Attributes can be named as noun phrases which play the role of adjectives for an entity

Right

Cardinaility expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related enitity

Right

Disjoint subtypes are subtype that contain a unique subset of the suertype entity set.

Right

Entites are expressed as singlular noun

Right

For meeting database design requirements 'attributes identify what properties are stored for each entity (type of data) and the domain for each attribute.

Right

For meeting database design requirements, 'constraints' identify what specific constraints and rules are applied to the data in the business process.

Right

Partial completeness is symbolized by a circle over a single line

Right

Partial completeness means that not every supertype occurrence is a member of a subtype.

Right

Strong relationship exists when the PK of the related entity contains a PK component of the parent entity.

Right

Subtype entity are subgroups of the supertype entity and have unique attributes, but they will be different from each subtype.

Right

Subtype enttiy are subgroups of the supertype entity and have unique attributes, but they will be different from each subtype.

Right

Supertype entity is an entity type that has got relationship with one or more subtypes and it contains attributes that are common to its subtypes

Right

The completeness contrain specifies whether each entity supertype occurrence must also be a member of at least one subtype

Right

The existence of an optional entity indicates that the minimum cardinality is 0 for the optional enttiy.

Right

The table is in 2NF if it is in 1NF and no partial dependencies exist.

Right

a new entity, called the bridge entity, is created to represent a M:M relationship

Right

Entity (E1) is 'Mandatory' is for any entity instance of Entity (E2) there must be a corresponding entity instance of Entity (E1) for the relationship R

Right:

A 'simple' primary key is not composed of two or more attributes.

Right: A 'simple' primary key is composed of a single attribute

A new entity , called the bridge entity, is created to represent a M:M relationship

Right: A new entity, called the bridge entity, is created to represent the M:M relationship.

A table is said to be in the Third Normal Form when, it is in the second normal form and it doesnt have transitive dependency.

Right: A table is said to be in the Third Normal Form when, it is in the second normal form and it doesnt have Transitive Dependency.

Relationships in ER model are expressed in third person singular.

Right: Relationship in ER model are expressed in third person singular.

The completeness constraint specified whether each entity supertype occurrence must also be a member of at least one subtype

Right: The completeness constraint specifies whether each entity supertype occurrence must also be a member of atleast one subtype.

In a database keeping the history of sold cars in a country, for the entity CAR the attribute price is an example of a required attribute

Right: The price has to be a required attribute

The property of inheritance enables an enttiy subtype to inherit the attributes and relationships of the supertype.

Right: The property of inheritance enablers an entity subtype to inherit the attributes and relationships of the supertype.

The table is in 2NF if it is in 1NF and no partial dependencies exist

Right: The table is in 2NF if it is in 1NF and no partial dependencies exist.

Types of normal forms

1NF: Has non repeating groups and the table cells are a of single value 2NF: If it is IN 1NF and no partial dependencies exist. 3NF: If it is in the Second Normal Form and it DOESN'T have Transitive Dependency 4NF: UNF: has one or more repeating groups and multi value cells, no primary key and multi value cells

A function that has no partial functional dependences is in ______ form

2NF: If it is in 1NF and no partial dependencies exist

In a database, a foreign key is defined as:

A data element/attribute within a data field of a data record within a database table that is a primary key in another database table.

Which of the following normal forms has one or more repeating groups, no primary key and multi value cells?

a. third normal form b. fourth normal form c. first normal form d. second normal form e. unnormalized form e. unnormalized form

For meeting database design requirements, which of the following is correct statement for 'entities' ?

It identify what specific constraints and rules are applied to the data in the business process.

______ subtypes are subtypes that contain nonunique subsets of the supertype entity set

Overlapping

A table in which form if it has non repeating groups and the table cells are of single value

a. 3NF b. 2NF c. UNF d. 1NF d. 1NF: A table is in 1NF if it has non repeating groups and the table cells are of single value

A table is in which form if it is has non repeating groups and the table cells are of single value:

a. Fourth Normal Form b. Second Normal Form c. First normal form d. Third Normal form e. Unnorimalized Form c. first normal form

Which of the following are the properties of entities?

a. attributes b. table c. domain d. switchboards e. groups a. attributes

Functional dependencies are a generalization of:

a. database dependencies b. none of these c. closure dependencies d. key dependencies e. relation dependences d. key dependencies

A table is in which form if it has non repeating groups and the table cells are of single value:

a. fourth normal form b. second normal form c. third normal form d. unnormalized form e. first normal form. e. first normal form

Normalization ______ data duplication.

a. increases b. maximizes c. reduces d. leads to e. eliminates

Functional dependencies are a generalization of:

a. key dependencies b. none of these c. closure dependencies d. database dependencies a. key dependencies

An attrivutre that may not have a value for some entity instances (already defined or to be defined in the future) is named:

a. multi-value b. unique c. required d. optional e. single-value d. optional

Eliminating modifications anomalies is a(n) _________ of normalization

a. neither an advantage nor disadvantage b. advantage c.

Eliminating modification anomalies is an _________ of normalization

a. neither an advantage nor disadvantage b. disadvantage c. advantage d. none of these e. either an advantage or disadvantage c. advantage

A functional dependency is a relationship between or among

a. none of these b. relations c. rows d. tables e. attributes e. attributes

Third normal form is based on the concept of ______:

a. normal dependency b. total dependency c. functional dependency d. closure dependency e. transitive dependency e. transitive dependency

Third Normal Form is based on the concept of _________:

a. normal dependency b. transitive dependency c. closure dependency d. total dependency e. functional dependency b. transitive dependency

Functional dependencies are a generalization of

a. relation dependencies b. database dependences c. key dependencies d. none of these e. closure depencies c. key dependences

The supertype and its subtype(s) depicted in the specialization hierachy maintain a _____ relationship

a. self-referring b. many-to-many (M:M) c. one-to-many(1:M d. Many-to-one(M:1) e. one-to-one (1:!)

The supertype and its subtypes depicted in the specialization hierarchy maintain a ______ relationship.

a. self-referring b. many-to-one (M:1) c. many-to-many (M:M) d. one-to-many (1:M) e. one-to-one (1:1) e. one-to-one: the supertype and its subtypes depicted in the specialization hierarchy

A functional dependency is a relationship between or among:

a. tables b. attributes c. rows d. relations e. none of these b. attributes