This sets of MCQs helps you to understand about the process of Normalization, the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
In the __________ normal form, a composite attribute is converted to individual attributes.
A table on the many side of a one to many or many to many relationship must:
Tables in second normal form (2NF):
Which-one ofthe following statements about normal forms is FALSE?
Functional Dependencies are the types of constraints that are based on______
An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:
A method of modelling and describing user tasks for an interactive application is referred to as:
Information architecture influences:
Also known as schematics, a way of illustrating the layout of an individual webpage is a:
A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:
A relation is in this form if it is in BCNF and has no multivalued dependencies:
Second normal form.
Third normal form.
Fourth normal form.
Domain/key normal form.
The different classes of relations created by the technique for preventing modification anomalies are called:
Normal forms.
Referential integrity constraints.
Functional dependencies.
None of the above is correct.
Row is synonymous with the term:
Record.
Relation.
Column.
Field.
The primary key is selected from the:
Composite keys.
Determinants.
Candidate keys.
Foreign keys.