Data Base Management System | Week 4
Course Name: Data Base Management System
Course Link: Click Here
These are Data Base Management System Week 4 Assignment Answers
Q1. Consider the relational schema Course Assignments (Assignment No, QNo, Topic, Marks, QType) with the following Functional Dependencies : Assignment No → Topic Topic {Topic, QNo} → QType Which of the following is not a prime attribute of Course Assignments? (Marks, AssignmentNo}
a) QNo
b) Topic
c) QType
d) AssignmentNo
Answer: d) AssignmentNo
These are Data Base Management System Week 4 Assignment Answers
Q2. Consider the relational schema FileRepo (RepoName, FileNo, IndexNo, AdminID, FileCount) with the following functional dependencies : RepoName→{AdminID, FileNo} FileCount {RepoName, IndexNo} Which of the following decomposition of FileRepo is lossless?
a) FileRepo1 (RepoName, FileNo), FileRepo2 (IndexNo, Admin ID, FileCount)
b) FileRepo1 (RepoName, FileNo), FileRepo2 (FileNo, AdminID, FileCount)
c) FileRepo1 (RepoName, FileCount), FileRepo2 (FileNo, IndexNo, AdminID, FileCount)
d) FileRepo1 (RepoName, AdminID), FileRepo2 (FileNo, IndexNo, AdminID, FileCount)
Answer: b) FileRepo1 (RepoName, FileNo), FileRepo2 (FileNo, AdminID, FileCount)
These are Data Base Management System Week 4 Assignment Answers
Q3. Consider the relational schema Course Assignments (Assignment No, QNo, Topic, Marks, QType) with the following Functional Dependency set : F={ QNo {Topic, AssignmentNo} Topic {Topic, QNo} → QType (Marks, AssignmentNo} } What is the canonical cover of F?
Answer: d
These are Data Base Management System Week 4 Assignment Answers
Q4. Consider the relational schema Game Repo (Game Name, Game Type, Developer, PlayedBy) with the following Functional Dependency GameName, GameType → Developer GameTypePlayedBy Developer Game Name Identify the possible number of superkeys of GameRepo.
a) 4
b) 6
c) 8
d) 10
Answer: a) 4
These are Data Base Management System Week 4 Assignment Answers
Q5. Consider the relation Fig (FNo, Page, Colored, Dimensions) with the following Functional De pendencies : FD1 : FNo, Page → Colored FD2 : Colored → Dimensions FD3 : Dimensions → FNo If Fig is decomposed into Fig1 (FNo, Page, Colored) and Fig2 (Colored, Dimensions), which of the following options is (are) true?
a) The decomposition is both lossless and dependency preserving.
b) The decomposition is lossless but not dependency preserving.
c) The decomposition neither lossless nor dependency preserving.
d) The decomposition is not lossless but is dependency preserving.
Answer: d) The decomposition is not lossless but is dependency preserving.
Q6. Consider the relational schema Game Repo (Game Name, GameType, Developer, PlayedBy) with the following Functional Dependency GameName, GameType → Developer GameType → PlayedBy Developer Game Name What is the highest Normal form of GameRepo?
a) INF
b) 2NF
c) 3NF
d) BCNF
Answer: b) 2NF
These are Data Base Management System Week 4 Assignment Answers
Q7. Consider the relation Fig (FNo, Page, Colored, Dimensions) with the following Functional De pendencies : FD1 : FNo, Page → Colored FD2 : Colored → Dimensions FD3 : Dimensions → FNo Which of the following is true?
a) Fig has 1 candidate keys and is in 1NF
b) Fig has 2 candidate keys and is in 2NF
c) Fig has 3 candidate keys and is in 3NF
d) Fig has 2 candidate keys and is in BCNF
Answer: d) Fig has 2 candidate keys and is in BCNF
These are Data Base Management System Week 4 Assignment Answers
Q8. Consider the instance of the relation Food (DishName, Price, Restaurant) :

Which of the following Functional Dependencies hold true on Food as can be found in the given instance?
a) (DishName, Price} → Restaurant
b) {Restaurant, Price} → DishName
c) {Restaurant, DishName} → Price
d) Restaurant → {Price, DishName}
Answer: a, b, c, d
These are Data Base Management System Week 4 Assignment Answers
Q9. Consider the instance of the relation Food (DishName, Price, Restaurant) :

If a new tuple {Risotto, 250, ItaliYum} is inserted to the given instance of Food, which of the following can not be a possible candidate key of Food?
a) {DishName, Price}
b) {Restaurant, Price}
c) {Restaurant, DishName}
d) {DishName, Price, Restaurant}
Answer: a, b, c, d
These are Data Base Management System Week 4 Assignment Answers
Q10. Consider the following relation : ClothesShop (ClothType, CColor, Designer, Shop ID) with the following functional dependencies : FD1 : ClothType → CColor FD2 : {Designer, CColor} → ShopID According to the rule of pseudo-transitivity, which of the following functional dependencies can be derived?
a) CColor ShopID
b) {ClothType, CColor} → Shop ID
c) {ClothType, Designer} → Shop ID
d) ClothType → ShopID
Answer: d) ClothType → ShopID
These are Data Base Management System Week 4 Assignment Answers
These are Data Base Management System Week 4 Assignment Answers
More Solutions of Data Base Management System: Click Here
More NPTEL Solutions: http://13.235.254.184/nptel/
