The relation employee(ID,name,street,Credit,street,city,salary) is dec – McqOptions

MCQOPTIONS

1.	The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary)This type of decomposition is called
A.	Lossless decomposition
B.	Lossless-join decomposition
C.	Both a and b
D.	None of the mentioned
Answer» E.

Discussion

No Comment Found

Related MCQs

A function that has no partial functional dependencies is in _______ form :
4NF is designed to cope with :
5NF is designed to cope with :
A BCNF is :
Every Boyee-Codd normal form is in
Designers use which of the following to tune performance of systems to support time-critical operations?
In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies:F1->F3F2->F4(F1,F2)->F5in terms of normalization, this table is in
Consider the following functional dependencies in a database. Date_of_Birth->Age Age->Eligibility Name->Roll_number Roll_number->Name Course_number->Course_name Course_number->Instructor (Roll_number, Course_number)->GradeThe relation (Roll_number, Name, Date_of_birth, Age) is