Important Questions and Answers
CP25C02- Advanced Database Technologies
Syllabus
1. Entity Relationship Model: Entity Relationship Model Revised-Subclasses, Superclasses
and Inheritance -Specialization and Generalization-Union Types-Aggregation.
Activity: Design ER Model for a specific use case.
2. Enhanced Entity Relational Model: Relational Model Revised, Converting ER and EER
Model to Relational Model-SQL and Advanced Features, File Structures, Hashing, and
Indexing.
Activity: Demonstration of SQL Implementation.
3. Object Relational Databases: Object Database Concepts-Object Database Extensions to
SQL, The ODMG Object Model and ODL, Object Database Conceptual Design-Object
Query Language OQL-Language Binding in the ODMG Standard.
Activity: Demonstration of Object Query Language.
4. Query Processing and Optimization: Query Processing, Query Trees and Heuristics,
Query Execution Plans, Cost Based Optimization.
Activity: Design of Query Evaluation Plans.
5. Distributed Databases: Real-Time Bidding, E-mail Marketing, Affiliate Marketing, Social
Marketing Mobile Marketing, Distributed Database Concepts, Data Fragmentation,
Replication and Allocation, Distributed Database Design Techniques, Distributed Database
Design Techniques, Distributed Database Architectures.
Activity: Demonstration of Concurrency and Transactions.
6. NOSQL Systems and Bigdata: Introduction to NOSQL Systems-The CAP Theorem,
Document, based NOSQL Systems, Key-value Stores, Column-Based or Wide Column
V.
NOSQL Systems, NOSQL Graph Databases and Neo4j.
U
m
Activity: Design application with MongoDB.
ap
7. Advanced Database Models, Systems and Applications: Active Database Concepts and
at
Triggers, Temporal Database Concepts, Spatial Database Concepts, Multimedia Database
hy
Concepts, Deductive Database Concepts, Introduction to Information Retrieval and Web
,Pr
Search.
of
./
EC
N
ot
es
, Activity: Demonstration of Hadoop infrastructure for Big Data Analytics.
S.No. Description
Unit-I
Entity Relationship Model
Basic Concepts
S.
Concept Basic Definition Example / Notation
No.
A conceptual database model used to
1 ER Model represent entities, attributes, and Student — Enrolls — Course
relationships.
A subgroup of an entity type that inherits
2 Subclass Student is a subclass of Person.
the properties of its superclass.
A general entity type that contains common
3 Superclass Person(Person_ID, Name, Age)
attributes shared by subclasses.
A subclass inherits the attributes and Student inherits Person_ID, Name,
4 Inheritance
relationships of its superclass. Age.
A top-down process of dividing a
Employee → Teaching_Staff,
5 Specialization superclass into more specific subclasses
Non_Teaching_Staff
based on distinguishing characteristics.
A bottom-up process of combining similar
6 Generalization Car + Bus → Vehicle
entity types into a common superclass.
Disjoint An entity can belong to only one subclass Employee → Permanent or
7
Constraint within a specialization. Temporary
Overlapping An entity can belong to more than one
8 Person → Student and Employee
Constraint subclass.
Total Every entity in the superclass must belong
9 Every Vehicle is a Car or a Bus.
Specialization to at least one subclass.
Partial Some superclass entities may not belong to Some Employees may not be
10
Specialization any subclass. Managers.
Owner ⊆ Person ∪ Company
Union Type A subclass formed from the union of
11
(Category) different superclasses.
Treating a relationship set as a higher-level Employee — Works_On —
V.
12 Aggregation entity so it can participate in another Project; Manager monitors this
U
m
relationship. assignment.
ap
Important equations and notations (copy to Word)
at
hy
Inheritance: Subclass attributes = Superclass attributes + Subclass-specific attributes
,
Pr
Specialization: Superclass → Subclass₁, Subclass₂, ..., Subclassₙ
of
./
EC
N
ot
es
, Union Type: Category ⊆ Superclass₁ ∪ Superclass₂
Generalization: Entity₁ + Entity₂ → Superclass
Total Specialization: S₁ ∪ S₂ ∪ ... ∪ Sₙ = Superclass
Disjoint Subclasses: Sᵢ ∩ Sⱼ = ∅, for i ≠ j
Overlapping Subclasses: Sᵢ ∩ Sⱼ ≠ ∅ may be possible
Exam tip: Remember the differences between specialization (top-down), generalization (bottom-up),
inheritance (property sharing), union type (multiple superclasses), and aggregation (relationship
treated as a higher-level object).
Multiple Choice QA
1. What is a superclass in the Enhanced Entity Relationship (EER) model?
A) An entity that contains no attributes
B) A higher-level entity that contains common attributes shared by subclasses
C) A relationship between two weak entities
D) An entity without a primary key
Answer: B) A higher-level entity that contains common attributes shared by subclasses
Reason: A superclass stores common attributes and relationships shared by its subclasses. For
example, Employee can be a superclass of Manager and Engineer.
Plain-text notation: Employee -> Manager, Engineer
2. Which concept allows a subclass to acquire the attributes and relationships of its superclass?
A) Aggregation
B) Generalization
V.
C) Inheritance
U
m
ap
D) Union
at
hy
Answer: C) Inheritance
,Pr
Reason: Inheritance allows a subclass to obtain the attributes and relationships of its superclass
of
./
EC
N
ot
es
, without redefining them.
Plain-text notation: Subclass attributes = Inherited attributes + Specific attributes
3. What is specialization in the EER model?
A) Combining multiple entity types into one general entity
B) Dividing a superclass into more specific subclasses
C) Converting attributes into relationships
D) Removing common attributes
Answer: B) Dividing a superclass into more specific subclasses
Reason: Specialization follows a top-down approach. For example, Vehicle can be divided into Car,
Bus, and Bike.
Plain-text notation: Vehicle -> Car, Bus, Bike
4. What is a union type (category) in the EER model?
A) A subclass whose members come from the union of different superclasses
B) A relationship containing only one entity
C) An entity without attributes
D) A superclass formed only by identical entities
Answer: A) A subclass whose members come from the union of different superclasses
Reason: A union type represents a category whose members can originate from different entity types.
V.
For example, an Owner may be a Person, a Company, or both, depending on the model's constraints.
Plain-text notation: Owner ⊆ Person ∪ Company
U
m
ap
at
hy
5. What is aggregation in the ER model?
,Pr
of
./
EC
N
ot
es
CP25C02- Advanced Database Technologies
Syllabus
1. Entity Relationship Model: Entity Relationship Model Revised-Subclasses, Superclasses
and Inheritance -Specialization and Generalization-Union Types-Aggregation.
Activity: Design ER Model for a specific use case.
2. Enhanced Entity Relational Model: Relational Model Revised, Converting ER and EER
Model to Relational Model-SQL and Advanced Features, File Structures, Hashing, and
Indexing.
Activity: Demonstration of SQL Implementation.
3. Object Relational Databases: Object Database Concepts-Object Database Extensions to
SQL, The ODMG Object Model and ODL, Object Database Conceptual Design-Object
Query Language OQL-Language Binding in the ODMG Standard.
Activity: Demonstration of Object Query Language.
4. Query Processing and Optimization: Query Processing, Query Trees and Heuristics,
Query Execution Plans, Cost Based Optimization.
Activity: Design of Query Evaluation Plans.
5. Distributed Databases: Real-Time Bidding, E-mail Marketing, Affiliate Marketing, Social
Marketing Mobile Marketing, Distributed Database Concepts, Data Fragmentation,
Replication and Allocation, Distributed Database Design Techniques, Distributed Database
Design Techniques, Distributed Database Architectures.
Activity: Demonstration of Concurrency and Transactions.
6. NOSQL Systems and Bigdata: Introduction to NOSQL Systems-The CAP Theorem,
Document, based NOSQL Systems, Key-value Stores, Column-Based or Wide Column
V.
NOSQL Systems, NOSQL Graph Databases and Neo4j.
U
m
Activity: Design application with MongoDB.
ap
7. Advanced Database Models, Systems and Applications: Active Database Concepts and
at
Triggers, Temporal Database Concepts, Spatial Database Concepts, Multimedia Database
hy
Concepts, Deductive Database Concepts, Introduction to Information Retrieval and Web
,Pr
Search.
of
./
EC
N
ot
es
, Activity: Demonstration of Hadoop infrastructure for Big Data Analytics.
S.No. Description
Unit-I
Entity Relationship Model
Basic Concepts
S.
Concept Basic Definition Example / Notation
No.
A conceptual database model used to
1 ER Model represent entities, attributes, and Student — Enrolls — Course
relationships.
A subgroup of an entity type that inherits
2 Subclass Student is a subclass of Person.
the properties of its superclass.
A general entity type that contains common
3 Superclass Person(Person_ID, Name, Age)
attributes shared by subclasses.
A subclass inherits the attributes and Student inherits Person_ID, Name,
4 Inheritance
relationships of its superclass. Age.
A top-down process of dividing a
Employee → Teaching_Staff,
5 Specialization superclass into more specific subclasses
Non_Teaching_Staff
based on distinguishing characteristics.
A bottom-up process of combining similar
6 Generalization Car + Bus → Vehicle
entity types into a common superclass.
Disjoint An entity can belong to only one subclass Employee → Permanent or
7
Constraint within a specialization. Temporary
Overlapping An entity can belong to more than one
8 Person → Student and Employee
Constraint subclass.
Total Every entity in the superclass must belong
9 Every Vehicle is a Car or a Bus.
Specialization to at least one subclass.
Partial Some superclass entities may not belong to Some Employees may not be
10
Specialization any subclass. Managers.
Owner ⊆ Person ∪ Company
Union Type A subclass formed from the union of
11
(Category) different superclasses.
Treating a relationship set as a higher-level Employee — Works_On —
V.
12 Aggregation entity so it can participate in another Project; Manager monitors this
U
m
relationship. assignment.
ap
Important equations and notations (copy to Word)
at
hy
Inheritance: Subclass attributes = Superclass attributes + Subclass-specific attributes
,
Pr
Specialization: Superclass → Subclass₁, Subclass₂, ..., Subclassₙ
of
./
EC
N
ot
es
, Union Type: Category ⊆ Superclass₁ ∪ Superclass₂
Generalization: Entity₁ + Entity₂ → Superclass
Total Specialization: S₁ ∪ S₂ ∪ ... ∪ Sₙ = Superclass
Disjoint Subclasses: Sᵢ ∩ Sⱼ = ∅, for i ≠ j
Overlapping Subclasses: Sᵢ ∩ Sⱼ ≠ ∅ may be possible
Exam tip: Remember the differences between specialization (top-down), generalization (bottom-up),
inheritance (property sharing), union type (multiple superclasses), and aggregation (relationship
treated as a higher-level object).
Multiple Choice QA
1. What is a superclass in the Enhanced Entity Relationship (EER) model?
A) An entity that contains no attributes
B) A higher-level entity that contains common attributes shared by subclasses
C) A relationship between two weak entities
D) An entity without a primary key
Answer: B) A higher-level entity that contains common attributes shared by subclasses
Reason: A superclass stores common attributes and relationships shared by its subclasses. For
example, Employee can be a superclass of Manager and Engineer.
Plain-text notation: Employee -> Manager, Engineer
2. Which concept allows a subclass to acquire the attributes and relationships of its superclass?
A) Aggregation
B) Generalization
V.
C) Inheritance
U
m
ap
D) Union
at
hy
Answer: C) Inheritance
,Pr
Reason: Inheritance allows a subclass to obtain the attributes and relationships of its superclass
of
./
EC
N
ot
es
, without redefining them.
Plain-text notation: Subclass attributes = Inherited attributes + Specific attributes
3. What is specialization in the EER model?
A) Combining multiple entity types into one general entity
B) Dividing a superclass into more specific subclasses
C) Converting attributes into relationships
D) Removing common attributes
Answer: B) Dividing a superclass into more specific subclasses
Reason: Specialization follows a top-down approach. For example, Vehicle can be divided into Car,
Bus, and Bike.
Plain-text notation: Vehicle -> Car, Bus, Bike
4. What is a union type (category) in the EER model?
A) A subclass whose members come from the union of different superclasses
B) A relationship containing only one entity
C) An entity without attributes
D) A superclass formed only by identical entities
Answer: A) A subclass whose members come from the union of different superclasses
Reason: A union type represents a category whose members can originate from different entity types.
V.
For example, an Owner may be a Person, a Company, or both, depending on the model's constraints.
Plain-text notation: Owner ⊆ Person ∪ Company
U
m
ap
at
hy
5. What is aggregation in the ER model?
,Pr
of
./
EC
N
ot
es
