Normal Forms

Question 1
Marks : +2 | -2
Pass Ratio : 100%
Functional dependencies that have a time associated with them during which they are valid are called as________
Timed functional dependencies
Clocked functional dependencies
Temporal functional dependencies
Modeled functional dependencies
Explanation:
Functional dependencies that have a time associated with them during which they are valid are called as temporal functional dependencies. All snapshots of the relation should satisfy the functional dependency for it to be a temporal functional dependency.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
To specify the foreign keys in relations referencing temporal data we need to specify _______
The time interval
The Boolean value for the working
The integer corresponding to the relation number
None of the mentioned
Explanation:
To specify the foreign keys in relations referencing temporal data we need to specify the time interval. The time interval specification thus preserves referential integrity in the relation.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Crosstabs are not desirable in a database design
True
False
Explanation:
Crosstabs may be useful for the users but they are not desirable in a database system because the queries would get more complicated due to the addition of cross tabs.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
What is unique role assumption?
The attribute name has a unique meaning in the database
The attributes are all unique
No two tuples have even a single same value in a relation
None of the mentioned
Explanation:
Unique role assumption means that the attribute names must have unique meaning in the database. This prevents us from using the same attribute to mean different things in different schemas.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
The value of the data at a particular time is called as?
Instance
Picture
Snapshot
None of the mentioned
Explanation:
The value of the data at a particular time is called as a snapshot. This is used in temporal data.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
The data that have a time interval associated with them during which they are valid are called as ________
Timed data
Temporal data
Model data
Clocked data
Explanation:
The data that have a time interval associated with them during which they are valid are called as Temporal data. We use the term snapshot to mean the value of the data at a particular point in time.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is the time of temporal data that record when a fact was recorded in a database?
Transaction time
Valid time
Enter time
Exit time
Explanation:
The transaction time is the time of temporal data that records when a fact was recorded in a database.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
State true or false: Overlapping time intervals cannot be prevented
True
False
Explanation:
IF a system supports a native valid time type, then the system can detect and prevent overlapping time intervals.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is not a process of generating a good relational schema?
Converting ER diagrams to relational schema
Decomposing the relational schema while satisfying functional dependencies
Joining multiple relations together to form a single relation containing all the attributes
A design of relations which is then tested and modified to satisfy given normal forms
Explanation:
Joining multiple relations together to form a single relation containing all the attributes is not a method for the development of good relational schema because it might violate the normal forms if it is combined.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
The process of making a normalized schema unnormalized is called as _________
Unnormalization
Denormalization
Renormalization
Annormalization
Explanation:
The process of making a normalized schema unnormalized is called as denormalization. Designers use it to tune performance of systems to support time-critical operations.