Uncategorized

What are structural constraints in an ER diagram? Explain Total Participation (Mandatory) and Partial Participation (Optional) with examples, and describe how total participation affects ER-to-Relational table reduction.

September 25, 2026 Uncategorized

What is meant by the degree of a relationship set in an ER model? Explain unary, binary, and ternary relationships with suitable examples. How is a ternary relationship set converted into relational tables?

September 25, 2026 Uncategorized

A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of players participating in each game for each team, the positions they play in that game, and the result of the game.

September 25, 2026 Uncategorized

What is Unified Modeling Language? Explain different types of UML.

September 25, 2026 Uncategorized

Discuss the extended ER (EER) model.

September 25, 2026 Uncategorized

Explain the reduction of an ER schema to tables. OR  How to reduce an ER model into tables?

September 25, 2026 Uncategorized

Explain generalization, specialization, and aggregation with suitable examples.

September 25, 2026 Uncategorized

Discuss candidate key, primary key, super key, composite key, and alternate key OR Explain primary key, super key, foreign key, and candidate key with examples. OR Define key. Explain various types of keys.

September 25, 2026 Uncategorized

Describe the three-schema architecture. Why do we need mappings between schema levels? How do different schema definition languages support this architecture?

September 25, 2026 Uncategorized

Describe mapping constraints with their types.

September 25, 2026