Question 1 of 25
Hints left: 3
Q1
A ________ is a stored program that is attached to a table or a view.
Q2
An entity class is a collection of entities and is described by the structure of the entities in that class.
Q3
A subtype entity is a special case of another entity called a supertype entity.
Q4
The degree of a relationship refers to the number of entity classes in the relationship.
Q5
Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
Q6
In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Q7
An identifier typically uses more than one attribute.
Q8
When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.
Q9
An entity is something that can be identified in the user's work environment; something that the users want to track.
Q10
The DROP TABLE statement:
Q11
A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.
Q12
A recursive relationship is a relationship between an archetype and an instance of that archetype.
Q13
Composite identifiers consist of two or more attributes.
Q14
A ternary relationship is so called because in contains two entities and one association between them.
Q15
In a 1:N relationship, the parent is the entity on the one side of the relationship and the child is the entity on the N side of the relationship.
Q16
An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.
Q17
Entities use identifiers while tables use keys.
Q18
A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
Q19
Entity instances are associated by relationship classes.
Q20
1:1, 1:N and N:M relationships are also known as HAS-A relationships.
Q21
All instances of an entity class have the same attributes.
Q22
An identifier determines the type of relationship that an entity has.
Q23
Relationship classes are associations between entity classes.
Q24
An attribute describes the entity's characteristics.
Q25
The SQL command to create a table is: