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!
Week 0: Assignment answers
Week 1:Â Course Overview. Introduction to RDBMS
Week 2: Structured Query Language (SQL)Â
Week 3: Relational Algebra. Entity-Relationship ModelÂ
Week 4: Relational Database Design
Week 5:Â Application Development. Case Studies. Storage and File StructureÂ
Week 6: Indexing and Hashing. Query ProcessingÂ
Week 7:Â Query Optimization. Transactions (Serializability and Recoverability)
Week 8:Â Concurrency Control. Recovery Systems. Course Summarization.
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)
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)
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)
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)
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.