Unit 4: Database Design Theory and Normalization21CSC205P

Functional Dependencies and Armstrong's Axioms

Curriculum and historical examination lineage for Functional Dependencies and Armstrong's Axioms under Unit 4 (Database Design Theory and Normalization) of Database Management Systems (21CSC205P) at SRMIST.

Appearances
4
Cataloged Exam Questions
Exam Papers
4
Distinct University Exams
Question Families
0
Recurring Conceptual Archetypes
SRMIST Status
Active
Regulation 2021 Syllabus
Assessment Cycle Weightage

Historical appearance distribution across SRMIST Formative Tests (CT1, CT2) and University End Semester examinations.

CT1
0
Cycle Test 1
CT2
0
Cycle Test 2
EndSem
4
Semester Exam
Marks Weightage Distribution

Factual marks weightage of questions asked on this topic in historical examinations.

1 Marks:2 questions
12 Marks:2 questions
Sample Past Exam Questions

Representative historical questions extracted directly from SRMIST examination papers.

Functional dependency is a relationship between (A) Entities (C) Attributes (B) Rows (D) Tables [1]

Year: 2022•Assessment: EndSem
1 Marks

Functional dependency (A) Avoid data redundancy (B) Avoid dependency (C) Not good for good database (D) Make database complex for query [1]

Year: 2022•Assessment: EndSem
1 Marks

Determine the closer of the following set of functional dependencies for a relational scheme R(A,B,C,D) and FDs {AB -> C, C -> D, D -> A}. List out the candidate keys of R.Find...

Year: 2023•Assessment: EndSem
12 Marks

Discuss the concepts of functional dependency that are required for a database to be in third normal form. Illustrate them with proper examples. [12]

Year: 2023•Assessment: EndSem
12 Marks
Historical Papers Indexed (4)

Examinations where questions for Functional Dependencies and Armstrong's Axioms have appeared.

Database Management Systems - JUNE 2022 Examination Paper
2022EndSem
Database Management Systems - NOV 2022 Examination Paper
2022EndSem
Database Management Systems - DEC 2023 Examination Paper
2023EndSem
Database Management Systems - MAY 2023 Examination Paper
2023EndSem
Other Exam Topics in Unit 4: Database Design Theory and Normalization

Master Functional Dependencies and Armstrong's Axioms in MintAI

Practice past exam questions, test recurring archetypes, and view predictive probability for this topic before your upcoming exam.