Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given ...
View QuestionWhich forms are based on the concept of functional dependency:
a) 1NF b) 2NF c) 3NF d) ...
View QuestionWhich forms has a relation that possesses data about an individual entity:
a) 2NF b) 3NF c) 4NF d) 5NF Answer: c Explanation: 4NF
View QuestionWhich forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
a) 1NF b) 2NF c) 3NF d) All of the mentioned
View QuestionWhich is a bottom-up approach to database design that design by examining the relationship between attributes:
a) Functional dependency b) Database modeling c) Normalization d) Decomposition Answer: ...
View QuestionFunctional Dependencies are the types of constraints that are based on______
a) Key b) Key revisited c) Superset ...
View QuestionWhich-one ofthe following statements about normal forms is FALSE?
a) BCNF is stricter than 3 NF b) Lossless, dependency -preserving decomposition into 3 ...
View QuestionTables in second normal form (2NF):
a) Eliminate all hidden dependencies b) Eliminate the possibility of a insertion anomalies c) ...
View QuestionA table on the many side of a one to many or many to many relationship must:
a) Be in Second Normal Form (2NF) b) Be in Third ...
View QuestionIn the __________ normal form, a composite attribute is converted to individual attributes.
a) First b) Second c) Third d) Fourth Answer: a Explanation: ...
View Question