📘 Relational Data Model – PYQ (Hindi + English Mix)

✅ 1 Mark / Definitions

1. परिभाषा (Definition) of Relational Model

2. संबंध (Relation) kya hota hai?

3. पंक्ति (Tuple/Row) kya hai?

4. स्तम्भ (Attribute/Column) kya hai?

5. डिग्री (Degree) of relation define karo.

6. कार्डिनैलिटी (Cardinality) kya hoti hai?

7. डोमेन (Domain) kya hai?

8. प्राथमिक कुंजी (Primary Key) kya hai?

9. विदेशी कुंजी (Foreign Key) kya hai?

10. उम्मीदवार कुंजी (Candidate Key) kya hai?

11. सुपर कुंजी (Super Key) kya hai?

12. शून्य मान (NULL value) kya hota hai?

13. अखंडता बाधाएँ (Integrity Constraints) kya hai?

✅ 2–3 Marks Short Notes

1. फाइल सिस्टम (File System) aur DBMS me difference explain karo.

2. रिलेशनल स्कीमा (Relational Schema) with example.

3. प्राथमिक कुंजी (Primary Key) aur विदेशी कुंजी (Foreign Key) me antar.

4. डोमेन बाधा (Domain Constraint) explain karo.

5. एंटिटी अखंडता (Entity Integrity) kya hai?

6. संदर्भ अखंडता (Referential Integrity) samjhao.

7. डिग्री (Degree) aur कार्डिनैलिटी (Cardinality) me difference.

8. Relation ki गुण (Properties) likho.

✅ 5 Marks Important Theory

⭐ Most Repeated

1. रिलेशनल डेटा मॉडल (Relational Data Model) ko diagram ke sath explain karo.

2. कुंजियों के प्रकार (Types of Keys) explain karo:

   • Primary Key

   • Candidate Key

   • Super Key

   • Foreign Key

   • Composite Key

3. अखंडता बाधाएँ (Integrity Constraints) with example.

4. कोड के नियम (Codd’s Rules) kya hai?

5. स्कीमा (Schema) aur इंस्टेंस (Instance) me difference.

6. Relational Model ke लाभ (Advantages) likho.

✅ 8–10 Marks Long Questions

🔥 Very Important

Q1.

रिलेशनल मॉडल (Relational Model) ko detail me explain karo:

• Structure

• Table

• Keys

• Constraints

• Example

Q2. Example Based

STUDENT (Roll, Name, Email, Phone)

Find:

• प्राथमिक कुंजी (Primary Key)

• उम्मीदवार कुंजी (Candidate Key)

• सुपर कुंजी (Super Key)

Q3.

अखंडता बाधाएँ (Integrity Constraints) explain karo:

• Domain Constraint

• Entity Integrity

• Referential Integrity

Q4.

EMP(Eid, Name, DeptId)
DEPT(DeptId, Dname)

Find:

• Primary Key

• Foreign Key

• Relationship