Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
4 PYQs - GATE 2003, GATE 2004 , GATE 2005, GATE 2008 (in Hindi)
157 plays

More

Sweta Kumari is teaching live on Unacademy Plus

Sweta Kumari
YouTuber (channel : GATE NoteBook) | Verified Educator | 2+ year Online Teaching Experience

U
Unacademy user
thank you so much sir...R.S.
  1. Consider the following functional dependencies in a database. In a schema with attributes A, B, C, D and E, following set of functional dependencies are given: A->B A->C CD->E B->D E->A Which of the following functional dependencies is NOT implied by the above set? (a) CD->AC(b) BD->CD (c) BC->CD (d) AC->BC Date of Birth->Age Age->Eligibility Name->Roll number Roll_number->Name Course number->Course name Course_ number->Instructor Roll number, Course number)->Grade GATE 2003 GATE 2005 The relation (Roll_number, Name, Date of_birth, Age) is (a) in second normal form but not in third normal form (b) in third normal form but not in BCNF (c) in BCNF (d) in none of the above


  2. Consider the following functional dependencies in a database. In a schema with attributes A, B, C, D and E, following set of functional dependencies are given: A->B A->C CD->E B->D E->A Which of the following functional dependencies is NOT implied by the above set? (a) CD->AC (b) BD->CD (c) BC->CD (d) AC->BC Date of Birth->Age Age->Eligibility Name->Roll number Roll_number->Name Course number->Course name Course_ number->Instructor Roll number, Course number)->Grade The relation (Roll_number, Name, Date of_birth, Age) is (a) in second normal form but not in third normal form (b) in third normal form but not in BCNF (c) in BCNF (d) in none of the above For the given relation only some of the above FDs are applicable. The applicable FDs are given below: Date of Birth->Age Name->Roll number Roll _number->Name Finding the closure set of attributes we getthe candidate keys:(Roll_number,Date of_Birth), and (Name, Date_ of_Birth) On selecting any one of the candidate key we can see that the FD Date_of_Birth->Age is a partial dependency. Hence the relation is in 1NF. GATE 2003 GATE 2005 Option (a): Closure set of CD CDEAB. Option (c): Closure set of BC BCDEA Option (d): Closure set of AC ACBDE. Option (b): Closure set of BD BD.


  3. Consider the following relational schemes for a library The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode.database: For any pincode,there is only one city and state. Also, Book (Title, Author, Catalog_no, Publisher, Year, Price) for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 relation in (a) 1NF only (b) 2NF and hence also in 1NF (c) 3NF and hence also in 2NF and 1NF (d) BCNF and hence also in 3NF, 2NF and 1NF Collection (Title, Author, Catalog_no) 1 is a relationinWith the following functional dependencies I. Title Author-> Catalog_no Il. Catalog no-> Title Author Publisher Year IlI. Publisher Title Year -> Price Assume Author, Title] is the key for both schemes. Which of the following statements is true? (a) Both Book and Collection are in BCNF (b) Both Book and Collection are in 3NF only (c) Book is in 2NF and Collection is in 3NF (d) Both Book and Collection are in 2NF only GATE 2004 GATE 2008


  4. GATE 2008 Consider the following relational schemes for a library The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode.database: For any pincode,there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation inWiththe following functional dependencies: (a) 1NF only (b) 2NF and hence also in 1NF Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) I. Title Author->Catalog_no Il. Catalog_no-> Title Author Publisher Year III. Publisher Title Year->Price Assume (Author, Title is the key for both schemes. Which of the following statements is true? (c) 3NF and hence also in 2NF and 1NF (d) BCNF and hence also in 3NF, 2NF and 1NF empcode is unique, therefore it is the primary key. Since(a) Both Book and Collection are in BCNF the primary key consists of a single attribute thereb) Both Book and Collection are in 3NF only be no partial dependency, hence the relation is in 2NF. c) Book is in 2NF and Collection is in 3NF From the question we get the FDs as below: pincode ->city, state street,city,state-> pincode From the FDs we can see that there are transitive dependencies, hence the table is not in 3NF. (d) Both Book and Collection are in 2NF only The relation Collection is in BCNF: Its given that Author, Title] is the key and there is only one functional dependency (FD) applicable to the relation Collectioni.e. Title Author->Catalog no .