# Data Base Management System | Week 4

Session: JAN-APR 2024

Course Name: Data Base Management System

#### Q1. Consider the relation R(X, Y, Z,V,W) which satisfies the following functional dependencies:XY→ZYZ→VZV→WVW→XXW→YWhich of the following functional dependencies are also guaranteed to be satisfied by relation R?a) XZ → Vb) YZV → Xc) Z → Wd) X → Z

Q2. Consider the relation Student (Reg No, Name, Address, Phone, Class_ID) and the set of following functional dependencies:
• FD1: Reg No → Name
• FD2: Address, Phone → Class_ID
• FD3: Name → Phone
• FD4: Class_ID → Reg No, Address
Which of the following are possible sets of candidate key(s) of Student?

a) Reg_No
c) Name
d) Class_ID

These are Data Base Management System Week 4 Assignment Answers

Q3. Consider the following relational table R:
If, relation R is decomposed into R₁ = (A, B, C) and R2 = (C, D, E). Choose the correct statement/s based on the above relations.

a) The decomposition does not preserve dependencies
b) ПR₁ (R) >< ПR₂ (R) will be:
c) ПР₁ (R) >< ПR2 (R) not equals to R
d) AB holds in the table ПR₁ (R) >< ПR₂ (R)

Q4. The following relation guarantees which highest normal form?
a) 1NF
b) 2NF
c) BCNF
d) 3NF

These are Data Base Management System Week 4 Assignment Answers

Q5. In a relation MountainTreking(Altitud (Altitude, MName, Location, MType, TrekkerAge, Climate, TrekkerExp), Altitude identifies MName and Location. Also, MName, MType, TrekkerAge and Climate combined determines the TrekkerExp, MType. TrekkerAge of the MountainTreking are dependent on Altitude and Climate together. Which of the following are the non-prime attributes of Mountain?
a) Altitude
b) Trekker Age
c) Climate
d) TrekkerExp

These are Data Base Management System Week 4 Assignment Answers

Q6. Consider the following instance of the relation MonthlyExpense (Budget, Month, Expense, Salary)
Which of the following Functional Dependencies hold for MonthlyExpense?
a) (Budget, Month) Expense
b) (Expense, Month) Budget
c) Budget Salary
d) Expense Salary

These are Data Base Management System Week 4 Assignment Answers

Q7. Consider the relational schema Flight (FNo, SeatNo, Window, Pilot, Duration) with the following functional dependencies:
FNo {Pilot, SeatNo}
Duration{FNo, Window}
Which of the following decomposition of Flight is lossless?

a) F1(FNo, Duration), F2(SeatNo, Window, Pilot, Duration)
b) F1 (FNo, SeatNo), F2(Window, Pilot, Duration)
c) Fi(FNo, Window), F2(SeatNo, Pilot, Duration)
d) F1(FNo, Pilot), F2(SeatNo, Window, Pilot, Duration)

Answer: a) F1(FNo, Duration), F2(SeatNo, Window, Pilot, Duration)

These are Data Base Management System Week 4 Assignment Answers

Q8. Consider the relation HousePlan (Room, Area, Location, Floor) with the following Functional Dependency set
F={
FD1: Room → {Area, Location}
FD2: Location → Floor
FD3: Area, Floor} → {Room, Location}
}
What is the canonical cover of F?

a) FD1: Room→ {Area, Location}
FD2: LocationFloor
FD3: (Area, Floor)→Room
b) FD1: RoomArea
FD2: LocationFloor
FD3: Area, Floor}{Room, Location}
c) FD1: RoomLocation
FD2: LocationFloor
FD3: {Area, Floor}{Room, Location}
d) FD1: Room→{Area, Location}
FD2: LocationFloor
FD3: Floor{Room, Location}

These are Data Base Management System Week 4 Assignment Answers

Q9. Consider the relational schema Book(Author, ISBN, Title, Category, Pages, Publisher) which satisfies the following functional dependencies:
•FD1: Author, ISBN → Title
•FD2: Author → Category
•FD3: ISBN Pages, Publisher
The given relation guarantees which highest normal form?

a) 1 NF
b) 2 NF
c) 3 NF
d) BCNF

These are Data Base Management System Week 4 Assignment Answers

Q10. Determine the highest Normal Form of the relation Restaurant (Dish, Chef, Table, Price) having the following complete set of functional dependencies.
Dish → Chef, Table
Table → Price

a) 1 NF
b) 2 NF
c) 3 NF
d) BCNF

These are Data Base Management System Week 4 Assignment Answers

Course Name: Data Base Management System

#### 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) QNob) Topicc) QTyped) 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)

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?

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

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

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}

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}

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