InfyTQ Previous year question

InfyTQ

Question 1.   Consider the following relational schemas.

book (isbn,title, author,genre, catalogno, publisher, year, price) student (studentid, studentname, classroom)

Following are the functional dependencies:

isbn->title, author.genre.year

genre->catalogno

catalogno->publisher

title price

 studentid ->studentrame, classroom

Which of the following statement TRUE with respect to the above schemas and dependencies?

1. book is in 3NF and student is in 2NF

2.book is in 2NF and student is in 3NF

3.book is in 3NF and student is in 1NF

 4.book is in 1NF and student is in 3NF

Question 2. Consider the following relational schemas;

teacher (teacherid, designation, salary) allocation (teacherld, subject, classroom)

Following are the functional dependencies:

teacherid → designation

designation -->salary

teacherid,salary

teacherid, subject → classroom

Which of the following option is TRUE for the relations given above?

1. teacher has one transitive dependency and allocation has one partial dependency

2. teacher has one transitive dependency and allocation has one full functional dependency

3.teacher has one partial dependency and allocation has one transitive dependency

 4.teacher has one full functional dependency and allocation has one full functional dependency