Quiz
ICS121CH4
This quiz has question types that open in the usual player.
Questions in this quiz (23)
1[blank_start]Candidate Key[blank_end]- A unique identifier. One of the candidate keys willbecome the primary key.
- ACandidate Key
2[blank_start]Composite Key[blank_end]- more than one field.
- AComposite Key
3[blank_start]Enterprise Key[blank_end] - Primary keys that are unique in the whole database, not just within a single relation.
- AEnterprise Key
4[blank_start]Foreign Key[blank_end] - Identifiers that enable a dependent relation to refer to its parent relation.
- AForeign Key
5[blank_start]Primary Key[blank_end] - are unique identifiers of the relation.
- APrimary Key
6[blank_start]Determinant[blank_end] - Determines the value of another attribute.
- ADeterminant
7Entity integrity rule - [blank_start]?[blank_end]
- A?
8[blank_start]First normal form[blank_end] - No multivalued attributes,every attribute value is atomic.
- AFirst normal form
9[blank_start]Second normal form[blank_end] - Every non-key attribute must be defined by the entire key, No partial functional dependencies.
- ASecond normal form
10[blank_start]Thrird normal form[blank_end] - No transitive dependencies.
- AThrird normal form
11[blank_start]Functional dependency[blank_end] - the value of one attribute.
- AFunctional dependency
12[blank_start]Homonym[blank_end] - attribute with the same namebut different meanings.
- AHomonym
13Normal Form - [blank_start]?[blank_end]
- A?
14Partial functional dependency - [blank_start]?[blank_end]
- A?
15[blank_start]Recursive foreign key[blank_end] - One-to-many relationship.
- ARecursive foreign key
16Referential integrity onstraint - [blank_start]?[blank_end]
- A?
17[blank_start]Relation[blank_end] - A relation is a named, two-dimensional table of data.
- ARelation
18[blank_start]Surrogate primary key[blank_end] - if you have large composite primary keys.
- ASurrogate primary key
19[blank_start]Synonym[blank_end]- Two or more attributes with different name but same meaning.
- ASynonym
20[blank_start]Transitive dependency[blank_end] - Even if relations are in 3NF prior to merging, they may not be after merging.
- ATransitive dependency
21[blank_start]Well-structured relation[blank_end] - A relation that contains minimal data redundancy annd allows users to insert,delete and update rows without causing data inconsistencies.
- AWell-structured relation
22Allias - [blank_start]?[blank_end]
- A?
23Anomaly - [blank_start]?[blank_end]
- A?
Information
- Description
- Quiz on ICS121CH4, created by 2014068629 on 08/10/2015.
- Author
- 2014068629
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz