Database Management System Question
Database Management System Question With Answer & Solution
Que. - Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
Que. - Which forms has a relation that possesses data about an individual entity:
Que. - Which forms are based on the concept of functional dependency:
Que. - Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
Que. - We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
Que. - Which of the following is not Armstrong’s Axiom?
Que. - The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
employee1 (ID, name)
employee2 (name, street, city, salary) This type of decomposition is called
employee1 (ID, name)
employee2 (name, street, city, salary) This type of decomposition is called
Que. - Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under
Que. - There are two functional dependencies with the same set of attributes on the left side of the arrow:
A->BC A->B
This can be combined as
A->BC A->B
This can be combined as
Que. - Consider a relation R(A,B,C,D,E) with the following functional dependencies:
ABC -> DE and
D -> AB The number of superkeys of R is:
ABC -> DE and
D -> AB The number of superkeys of R is:
Showing
181
To
190 of 1293 results