Data Base Management System | NPTEL 2023 | Week 4 Assignment Solutions

Data Base Management System NPTEL Assignment answers

This set of MCQ(multiple choice questions) focuses on the Data Base Management System NPTEL 2023 Week 4 Assignment Solutions.

The course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.

Course layout (Answers link)

Answers COMING SOON! Kindly Wait!

NOTE: You can check your answer immediately by clicking show answer button. Data Base Management System NPTEL 2023 Week 4 Assignment Solution” contains 10 questions.

Now, start attempting the quiz.

Data Base Management System NPTEL 2023 Week 4 Quiz Solutions

Q1. Consider the relational schema Office(Sector, Company, Building, Floor, Employees) with the following Functional Dependency set:
{Sector, Company} -> {Building, Floor}
{Company, Building} -> {Employee, Sector}
Building -> Floor
Which attribute is present in all the composite candidate keys of OfficeList?

a) Sector
b) Company
c) Building
d) Floor

Answer: b) Company

Q2. Consider the relational schema:
DeviceLogs(Device, OperatingSystem, Logins, DateOfRecord, DeviceLocation) with the following Functional Dependency set:
{Device, OperatingSystem} -> DeviceLocation
{Logins, DateOfRecord} -> OperatingSystem
DeviceLocation -> DateOfRecord
If X is the number of candidate keys of DeviceLogs and Y is its highest Normal Form, find the values of X and Y.

a) X=1, Y=2
b) X=2, Y=1
c) X=3, Y=3
d) X=2, Y=3

Answer: c) X=3, Y=3

Q3. Consider the relational schema DataLabelling(DataSetName, DataFeature1, DataFeature2, Label, Confidence, Annotators) with the following Functional Dependency set:
DataSetName -> {Annotators, DataFeature2}
{DataFeature1, DateFeature2} -> Label
{Label, DataFeature1} -> Confidence
DataFeature2 -> DataSetName
Which attribute can NOT be derived directly or indirectly from DataFeature2?

a) DataSetName
b) DataFeature1
c) Label
d) Annotators

Answer: b), c)

Data Base Management System NPTEL 2023 week 1 Assignment Solutions

Q4. Consider the relational schema LuckyDraw(Box, Item, Picked, WinningPrize). Which of the following set of functional dependencies should be chosed so that LuckyDraw can be in 2NF but not in 3NF?

a) Box -> {Item, Price}
Price -> WinningPrize
Item -> Picked
b) {Box, Item} -> Price
Price -> WinningPrize
Item -> Picked
c) {Item, Box} -> Price
{Item, Price} -> WinningPrize
d) {Item, Box, Picked} -> Price
{Item, Price} -> WinningPrize
{WinningPrize, Price} -> {Item, Box}

Answer: a)

Q5. Consider the relational schema Tournament(Champion, Category, Participants, Judges, Day) with the following Functional Dependency set F.
{Category, Day} -> Champion
{Category, Champion} -> {Participants, Judges}
Day -> {Judges, Category}
What is the canonical cover of F?

a) Category -> Champion
Champion -> Participants
Champion -> Judges
Day -> Category
b) Day -> Champion
{Category, Champion} -> Participants
{Category, Champion} -> Judges
c) Day -> Champion
{Category, Champion} -> Participants
{Category, Champion} -> Judges
Day -> Category
d) {Category, Day} -> Champion
{Category, Champion} -> Participants
{Category, Champion} -> Judges
Day -> {Judges, Category}

Answer: d)

Q6. Consider the relational schema Gallery(GallerySection, ArtistID, ArtID, Sold, Theme) with the following functional Dependency set:
{GallerySection, ArtistID} -> ArtID
ArtID -> Sold
{ArtID, ArtistID} -> Theme
The relation is decomposed into the following:
Gallery1(GallerySection, ArtistID, ArtID)
Gallery2(GallerySection, ArtistID, Sold)
Which of the following is true about the decomposition?

a) Both lossless and dependency preserving
b) Neither lossless nor dependency preserving
c) Lossless but not dependency preserving
d) Lossy but dependency preserving

Answer: b)

Data Base Management System NPTEL 2023 week 1 Assignment Solutions

Q7. Consider the relational schema Gallery(GallerySection, ArtistID, ArtID, Sold, Theme) with the following functional Dependency sets:
S1 = {
{GallerySection, ArtistID} -> ArtID
Sold -> {ArtID, Theme}
}
S2 = {
GallerySection -> {ArtistID, ArtID}
Sold -> {GallerySection, Theme}
}
Which of the following is true?

a) Neither S1 covers S2 nor S2 covers S1
b) S1 covers S2 but S2 does not cover S1
c) S2 covers S1 but S1 does not cover S2
d) Both S1 covers S2 and S2 covers S1

Answer: c)

Q8. Consider the relational schema Gallery(GallerySection, ArtistID, ArtID, Sold, Theme) with the following functional Dependency set:
{GallerySection, ArtistID} -> ArtID
ArtID -> Sold
{ArtID, ArtistID} -> Theme
Which of the following is true?

a) Gallery has 1 candidate key and is in 1NF
b) Gallery has 1 candidate key and is in 2NF
c) Gallery has 2 candidate key and is in 3NF
d) Gallery has 2 candidate key and is in 1NF

Answer: a)

Q9. In a relation FurnitureStore(FurnitureNo, FurnitureType, Price, Width, Height, Weight, DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent of FurnitureNo and Weight together. Which of the following are the non-prime attributes of FurnitureStore?

a) FurnitureNo
b) Height
c) Weight
d) DeliveryCharge

Answer: b), d)

Data Base Management System NPTEL 2023 week 1 Assignment Solutions

Q10. In a relation FurnitureStore(FurnitureNo, FurnitureType, Price, Width, Height, Weight, DeliveryCharge), FurnitureNo identifies FurnitureType and Price. Also, FurnitureType, Width, Height and Weight combined determines the DeliveryCharge. Width and Height of the furniture are dependent of FurnitureNo and Weight together. The highest normal form of FurnitureStore is n. If the highest normal form of the relation has to be increased to n+1, which of the following changes should be made in its current functional dependency set?

a) FurnitureNo and Weight together, should identify FurnitureType and Price
b) Only Width, Height and Weight should identify the DeliveryCharge
c) Only FurnitureType, Height and Weight shoulld identify the DeliveryCharge
d) Only Weight should identify the Width and Height

Answer: a)

Data Base Management System NPTEL 2022 Week 4 Assignment Solutions

Q1.

Answer: a) 1NF

Q2.

Answer: c)

Q3.

Answer: b), c)

Q4.

Answer: d)

Q5.

Answer: c)

Data Base Management System NPTEL Week 4 Assignment Solutions

Q6.

Answer: a), d)

Q7.

Answer: d)

Q8.

Answer: d)

Q9.

Answer: a)

Q10.

Answer: c)

<< Prev- Data Base Management System Week 3 Assignment Solutions

>> Next- Data Base Management System Week 5 Assignment Solutions


DISCLAIMER: Use these answers only for the reference purpose. Quizermania doesn't claim these answers to be 100% correct. So, make sure you submit your assignments on the basis of your knowledge.

NPTEL answers: Problem solving through programming in C

NPTEL answers: Principles of Management

Programming in Java NPTEL week 1 quiz answers

NPTEL – Python for Data Science assignment solutions

Nptel – Deep Learning assignment solutions

For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.

Leave a Comment

Your email address will not be published. Required fields are marked *