BCA-CTIS

1.  understand the basic concepts and structure of database technologies

2.  understand the various models used in the database

3.  understand various ways to manipulate the data in the database

4.  understand the relational model and data representation in a structured manner.

5*. to perform various operations on databases.

Internal Assessment Marks:30(20(T)+10(P)) End Term Exam Marks: 70(50(T)+20(P))

The examiner will set a total of nine questions. Out of which the first question will be compulsory. The remaining eight questions will be set from four units selecting two questions from each unit. The examination will be of three-hour duration. All questions will carry equal marks. The first question will comprise short answer-type questions covering the entire syllabus. The candidate will have to attempt five questions in all, selecting one question from each unit.

The practicum will be evaluated by an external and an internal examiner. The examination will be of three-hour duration.

Database Users: Data and Database Administrator, Role and Responsibilities      of               Database                             Administrator,    Database Designers, Application Developers etc. Database System Architecture – 1-Tier, 2-Tier & Three Levels of Architecture, External, Conceptual, and Internal Levels, Schemas, Mappings and Instances, Data Independence – Logical and Physical Data Independence.

Entity-Relationship Model: Entity, Entity Sets, Entity Type, Attributes: Type of Attributes, Keys, Integrity Constraints, Designing of ER Diagram, Symbolic Notations for Designing ER Diagram,

Joint   Operations   and   Sub-queries.   Constraints   and   its Implementation in SQL.

Relational Algebra: Basic Operations: Select, Project, Join, Union, Intersection, Difference, and Cartesian Product, etc.

Relational Calculus: Tuple Relational and Domain Relational Calculus.

Normalization: Benefits and Need of Normalization, Normal Forms Based on Primary Keys- (1NF, 2NF, 3NF, BCNF),

Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain Key Normal Form.

Programming Lab:

·        Performing various SQL statements. Creating various tables and performing all possible queries based on the syllabus.

·        Creating and populating a simple database, performing basic CRUD operations.

·        Understanding relational model concepts

·        Understanding normalization

·        Designing a database schema for a given problem, and normalization of the schema.

➢      Theory

·     Class Participation: 5

·     Seminar/presentation/assignment/quiz/class test etc.: 5

·     Mid-Term Exam: 10

➢      Practicum

·     Class Participation: NA

·     Seminar/Demonstration/Viva-voce/Lab records etc.: 10

·     Mid-Term Exam:   NA

A three-hour exam for both theory and practicum.

·        Elmasri & Navathe, Fundamentals of Database Systems, Pearson Education.

·        A Silberschatz, H Korth, S Sudarshan, Database System and Concepts, McGraw-Hill.

·        Thomas Connolly Carolyn Begg, Database Systems, Pearson Education.

·        C. J. Date, An Introduction to Database Systems, Addison Wesley.