(SEM V) THEORY EXAMINATION 2023-24 INTELLIGENT DATABASE SYSTEM

Subject Code: KAI053

Subject Name: Intelligent Database System

Course: B.Tech (Semester V)

Maximum Marks: 100

Duration: 3 Hours

Exam Year: 2023–24

Sections: A, B, and C

SECTION A – Short Answer Questions (2 × 10 = 20 Marks)

All questions are compulsory (each carries 2 marks).

a. Highlight two general characteristics of Intelligent Database Systems (IDBSs) and explain their significance.
b. Give an informal definition of the domain of IDBS with a concise overview.
c. Describe the installation process of LAMP (Linux, Apache, MySQL, PHP) and key steps.
d. Explain the importance of configuring and setting up connections between back end and front end in web development.
e. State two guidelines for effectively using Intelligent Database Systems.
f. Provide a short definition of IDBS.
g. Enumerate two characteristics of IDBSs and their importance.
h. Why is it essential to establish clear objectives while implementing IDBS?
i. Outline the main components of the LAMP stack.
j. Discuss the importance of secure connections and error handling in setup.
 

SECTION B – Medium-Length Questions (10 × 3 = 30 Marks)

Attempt any three of the following.

Using SQL, outline two phases (DDL, DML, DCL) to create a sample database for Language.

Describe, in steps, how to create Java/PHP pages with database access.

Explain the ODMG standard and its role in object-oriented database systems.

Discuss the features and challenges of active database systems, including architecture.

Explain nested and semantic data models, emphasizing their importance in design.
 

SECTION C – Long / Analytical Questions (10 × 5 = 50 Marks)

Q3. DATALOG & Knowledge-Based Systems

a. Explain the process of working with DATALOG commands.
OR
b. Summarize characteristics of knowledge-based systems and their significance in AI.

Q4. Deductive Database Systems

a. Provide a point-wise overview of deductive database systems and basic concepts.
OR
b. Outline conclusions from the study of deductive databases in the context of knowledge-based systems.

Q5. Knowledge Base Construction

a. Explain lexical approaches for constructing large Knowledge Bases (KBs).
OR
b. Discuss other projects based on conceptual representation within advanced knowledge-based systems.

Q6. Advanced Knowledge Systems

a. Provide an overview of the CYC project and its contributions to knowledge-based systems.
OR
b. Explain characteristics of TELOS, a language for very large integral systems.

Q7. Temporal & Multi-Agent Systems

a. Describe the implementation process of temporal databases.
OR
b. Explain key issues in designing multi-agent systems and identify open research challenges.
 

Key Topics to Prepare

Intelligent Database Systems (IDBS):

Integration of AI with DBMS

Knowledge-based querying

Adaptive and self-learning databases

LAMP Stack Setup:

Components (Linux, Apache, MySQL, PHP)

Configuration and backend–frontend connectivity

ODMG Standard: Object Data Management Group’s impact on OODBMS interoperability.

Active Databases: Event–condition–action (ECA) rules and triggers.

Deductive Databases: Logical inference and rule-based querying using DATALOG.

Knowledge-Based Systems: CYC, TELOS, and conceptual representation in knowledge engineering.

Temporal Databases: Time-dependent data and transaction management.

Multi-Agent Systems: Collaboration, negotiation, and open problem frameworks.

Study Tips

Understand core principles — focus on how AI concepts (rules, reasoning, learning) enhance database functionality.

Review SQL and DATALOG examples — write small code snippets.

Learn architecture diagrams — LAMP, Active DB, and Knowledge-based systems.

Prepare short notes on CYC, TELOS, and lexical knowledge base construction.

Revise challenges in multi-agent and temporal databases — often asked in long questions.