Unit 4: Database Design Theory and Normalization21CSC205P

First Normal Form (1NF) and Second Normal Form (2NF)

Curriculum and historical examination lineage for First Normal Form (1NF) and Second Normal Form (2NF) under Unit 4 (Database Design Theory and Normalization) of Database Management Systems (21CSC205P) at SRMIST.

Appearances
3
Cataloged Exam Questions
Exam Papers
3
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
3
Semester Exam
Marks Weightage Distribution

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

1 Marks:3 questions
Sample Past Exam Questions

Representative historical questions extracted directly from SRMIST examination papers.

Eliminating partial dependency is equal to (A) 2NF (C) Zero (B) INF (D) None of the above [1]

Year: 2022•Assessment: EndSem
1 Marks

Tables in second normal form (2NF): (A) Eliminate all hidden dependencies (B) Eliminate the possibility of a insertion anomalies (C) Have a composite key (D) Have all non key...

Year: 2023•Assessment: EndSem
1 Marks

A relation is said to be in 2NF if it is 1NF and if all of its non-key attributes are ________ dependent on the entire primary key. (A) Fully functionally (B) Closure (C)...

Year: 2023•Assessment: EndSem
1 Marks
Historical Papers Indexed (3)

Examinations where questions for First Normal Form (1NF) and Second Normal Form (2NF) have appeared.

Database Management Systems - JUNE 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 First Normal Form (1NF) and Second Normal Form (2NF) in MintAI

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