quizzes (wip)

the sql command _________ adds one or more new columns to a table

alter table

an entity name should be all of the following except:

as short as possible

property or characteristic of an entity type that is of interest to the organization

attribute

which of the following criteria should be considered when selecting an identifier

choose an identifier that doesn't have large composite attributes

primary key that consists of more than one attribute

composite key

converting a m:n relationship into two 1:m relationship is often conducted during:

conceptual data modeling

which of the following counts only rows that contain a value

count(*)

when a regular entity type contains a multivalued attribute, then one must:

create two new relations, one containing the multivalued attribute

the relational data model consists of which components

data definition data manipulation data integrity

component of the relational data included to specify business rules to maintain the integrity of data when they are manipulated

data integrity

the number of entity types that participate in a relationship

degree

an attribute of an entity that is computed

derived attribute

logical representation of an organization's data

entity-relationship model

when all multivalued attributes have been removed from a relation, it is said to be in:

first normal form

an attribute in a relation of also serves as the primary key of another relation in the same database

foreign key

constraint between two attributes

functional dependency

which of the following clauses is required to produce scalar and vector aggregates

group by

which of the following is one of the properties of relations

no two rows in a relation are identical

database professionals use a set of principles called _______ to guide and assess the logical database design

normalization

_____________ database specification indicates all the parameters for data storage that are then input to database implementation

physical

ddl is typically used during which phase of the development process

physical design

simultaneous relationship among the instances of three entity types is called a __________ relationship

ternary

an entity type whose existence depends on another entity type

weak entity

in an sql statement, which of the following parts states the conditions for row selection

where