Bachelor of Computer Application (BCA) Community Share and Help

Syllabus BCA-SEM-II-CC-110

Database Management System - I

Gujarat University FY BCA Sem - II New Syllabus (Revised) Effective from June, 2011

Course Introduction:
This course introduces students to information of data, working of related data to gain knowledge. Students also will design the real life application.

Objectives:
Students would be able
  1. To understand the concept, role and importance of Database.
  2. To recognize the elements of Database for real applications.
  3. To identify the key relationship between the Database components.
  4. To comprehend the type of relational model to apply according to the scenery of applications.
  5. To be aware of the real functions of Database Management Software.
  6. To normalize the Tables to remove the anomaly existing in the Database.
  7. To deal with every tiny elements of the Database.
No. of Credits: 3
Theory Sessions per week: 4
Teaching Hours: 40 hours


UNIT
TOPICS / SUBTOPICS
 TEACHING HOURS
 
 
1. Database System and Data Models
10 Hours
  • Data and Information
1 Hours
  1. Data Vs. Information
  • Database
3 Hours
  1. Introduction of the Database and the DBMS
  2. Role and Advantage of DBMS
  3. Types of Database
  • Database Systems
3 Hours
  1. The Database System Environment
  2. DBMS Functions
  • Data Model Basic Building Block
3 Hours
  1. The Hierarchical Model
  2. The Network Model
  3. The Relational Model
2. The Relational Database Model
10 Hours
  • A logical view of Data
1 Hours
  1. Tables and Their characteristics
  • Keys
1 Hours
  • Integrity Rules
1 Hours
  • Concept of Functional Dependency
1 Hours
  • Relational Set Operators
2 Hours
  • The Data Dictionary and The System Catalog
1 Hours
  • Relationship within the Relational Database
3 Hours
  1. The 1 : M Relationship
  2. The 1 : 1 Relationship
  3. The M : N Relationship
3. Entity Relationship Modeling
10 Hours
  • The Entity Relationship Model
7 Hours
  1. Entities
  2. Attributes
  3. Relationships
  4. Connectivity and Cardinality
  5. Existence Dependence
  6. Relationship Strength
  7. Weak Entities
  8. Relationship Participation
  9. Relationship Degree
  10. Recursive Relationship
  11. Composite Entities
  • Developing an ER diagram
3 Hours
4. Normalization of Database Tables
10 Hours
  • The need of Normalization
2 Hours
  • The Normalization process
8 Hours
  1. Conversion to First normal form
  2. Conversion to Second normal form
  3. Conversion to Third normal form

Textbook:  
   
Database System Concepts (First Edition: 2008)  
Publisher: Cengage Learning  
By Peter Rob and Carlos Coronel  
Chap-1(1.1, 1.2, 1.6), chap-2(2.5(2.5.1, 2.5.2, 2.5.3)),Chap-3(3.1, 3.2, 3.3, 3.4, 3.5, 3.6), chap-4(4.1, 4.2), chap-5(5.2, 5.3)  
   
   

Reference Books:
 
Introduction to Database Management Systems (First Edition 2006)
Publisher: Tata McGraw-Hill
By ISRD Group

Reference Books:
 
An Introduction to Database Systems (Eighth Edition 2006)
Publisher: Pearson
By C. J. Date, A. Kannan & S. Swamynathan

Reference Books:
 
An Introduction to Database Systems
Publisher: Pearson
By ITL Education Solutions Limited.

Advertisement