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) :

image 42

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) :

image 43

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/


These are Data Base Management System Week 4 Assignment Answers