NPTEL Introduction to Database Systems Assignment 8 Answers 2023

Hello Learners, In this Post, you will find NPTEL Introduction to Database Systems Assignment 8 Week 8 Answers 2023. All the Answers are provided below to help the students as a reference don’t straight away look for the solutions.

NPTEL Introduction to Database Systems Assignment 9 Answers Join Group👇

CLICK HERE

Note: First try to solve the questions by yourself. If you find any difficulty, then look for the solutions.

NPTEL Introduction to Database Systems Assignment 8 Answers 2023:

We are updating answers soon Join Group for update: CLICK HERE

Q.1. Consider the statements given below:

S1: For a given FD set, there exists exactly one minimal cover.
S2: For a given FD set, there may exist more than one minimal cover and all minimal covers are equivalent to each other.
Choose the correct option:

• S1: True; S2: True
• S1: True; S2: False
• S1: False; S2: True
• S1: False; S2: False

Q.2. For FD set F = {A → BC, CD → E, E → C, D → AE}, find minimal cover F_m

• F_m = {A → B, A → C, CD → E, E → C, D → A}
• F_m = {A → B, A → C, CD → E, D → A, D → E}
• F_m = {A → B, A → C, D → A, D → E}
• F_m = {A → B, A → C, E → C, D → A, D → E}

Q.3. Given the following relation instance

Which of the following functional dependencies are satisfied by the instance?

• XY → Z and Z → Y
• YZ → X and Y → Z
• YZ → X and X → Z
• XZ → Y and Y → X

NPTEL Introduction to Database Systems Assignment 8 Answers Join Group👇

Q.4. Let R = (A, B, C, D, E, F) be a relation scheme with the set of all functional dependencies that hold on it as {C → F, E → A, EC → D, A → B}. Which of the following is a key for R?

• CD
• AE
• AC
• EC

Q.5. Consider a relation R(A, B, C, D) and the set of all FDs that hold on R as

{ A → C, BC → D, B → A}
Choose the correct option:

• only A is prime attribute
• only B is prime attribute
• only A and B are prime attributes
• All attributes are prime attributes

Q.6. Consider a relation R(A, B, C, D, E) and the set of all FDs that hold on R as

{A → C, BC → D, B → A}
Find candidate key(s) of R

• only AE
• only BE
• only ABE
• only {AE, BE}

Q.7. Consider a relation R(A, B, C, D, E) and a set of all FDs that hold on R as given below:

{A → BC, CD → E, B → D, E → A}
Choose the correct option:

• R is in 1NF, not in 2NF
• R is in 2NF, not in 3NF
• R is in 3NF, not in BCNF
• R is in BCNF

NPTEL Introduction to Database Systems Week 8 Answers Join Group👇

CLICK HERE

Q.8. Consider a relation R with only simple candidate keys (i.e. no candidate key in R has more than one attribute). Choose the most appropriate option:

• R is always in BCNF
• R is always in 3NF
• R can be in 2NF, but may not be in 3NF
• R can not be in 2NF

Q.9. Consider the following two sets of functional dependencies:

F = {A → C, AC → D, E → AD, E → H}
G = {A → CD, E → AH}
Choose the correct option:

• only F covers G
• only G covers F
• F and G are equivalent
• None of the above

Q.10. Consider the following statements:

S1: Any relation schema with two attributes is always in BCNF
S2: Any relation schema with three attributes is always in BCNF
Choose the correct option:

• S1: TRUE; S2: TRUE
• S1: TRUE; S2: FALSE
• S1: FALSE; S2: TRUE
• S1: FALSE; S2: FALSE

NPTEL Introduction to Database Systems Assignment 8 Answers Join Group👇

Disclaimer: This answer is provided by us only for discussion purpose if any answer will be getting wrong don’t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided by Brokenprogrammers. This tutorial is only for Discussion and Learning purpose.

About NPTEL Introduction to Database Systems Course:

Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard

Course Layout:

• Week 1   : Introduction and part of E/R Model Module
• Week 2   : ER Model Module
• Week 3   : Relational Model Module
• Week 4   : Relational Model Module
• Week 5   : TRC Module and part of SQL Module
• Week 6   : SQL Module
• Week 7   : Indexes Module
• Week 8   : Indexes Module + Query Processing Module
• Week 9   : Normal Forms Module
• Week 10 : Normal Forms Module
• Week 11 : Transaction Processing Module
• Week 12 : Transaction Processing Module

CRITERIA TO GET A CERTIFICATE:

Average assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

If you have not registered for exam kindly register Through https://examform.nptel.ac.in/