DBMS-I

Paper Code: 
CBCA 305
Credits: 
3
Periods/week: 
3
Max. Marks: 
100.00
Objective: 

The course will enable the students to

  1. Know about the fundamental concepts of database management
  2. Observe that how the real world data is stored, retrieved, and communicate under the DBMS environment
  3. Design a logical model which having the unique relation between the Data.

Course Outcomes (COs):

Course Outcome (at course level)

Learning and teaching strategies

Assessment Strategies

The students will:

CO118. Apply    the    concepts   of database     into real-world scenario.

CO119. Analyze database requirements,    identify  the entities involved in the system and   determine  their relationship to one another.

CO120. Develop the logical design of the   database   using   data modeling concepts and deduce into relational schema.

CO121. Learn and apply Structured Query Language (SQL) for database  definition   and database manipulation.

CO122. Create database   for   any application  using normalization prinicples.

Interactive Lectures, Discussion,

Tutorials, reading assignments,

Demonstrations, G-suite. Self-

learning assignments, Effective

questions, Simulation, Seminar

presentation

Class test, Semester

end examinations,

Quiz, Solving

problems in tutorials,

Assignments,

Presentation, Individual and group

projects

 

9.00
Unit I: 

Data Processing Fundamentals: Introduction, Data, Information and Data Processing, Data structure, Need for Data Processing, Data Processing Cycle, Methods of Data Processing, Applications of Data Processing, Advantages and Disadvantages of Electronic Data Processing.

File structure: Files, Logical and physical file, Basic File Operations, Types of File Organizations (Unordered or heap or serial files, Ordered or sequential file, Hash file, Indexed Sequential, Direct access and Random files).

 

9.00
Unit II: 

Introduction: Database, Database System Applications, Database Systems versus File Systems, Purpose of Database Systems, View of Data, Database Languages, Relational Databases, Database Design, Data Storage and Querying, Database Architecture, Data Mining and Information Retrieval, Specialty Databases, Database Users and Administrators, History of Database Systems.

 

9.00
Unit III: 

Entity-Relationship Model: Basic concepts, Constraints, Removing Redundant Attributes in Entity Sets, Reduction to Relational Schemas, ER-Design Issues, E-R diagram, Weak Entity Sets.

 

9.00
Unit IV: 

Relational Model: Structure, Database Schema, Keys, Schema Diagrams, Relational Operations.

Introduction to SQL: SQL Data Definition, Basic Structure, Additional Basic Operations, Set Operations, Null Values, Aggregate Functions, Modification of the Database. Intermediate SQL: Join Expressions, Views, Transactions, Integrity Constraints, SQL Data Types and Schemas, Authorization, Roles.

 

9.00
Unit V: 

Relational-Database Design: FirstNormal Form, Pitfalls in Relational-Database Design, Functional Dependencies, Decompositions, Third Normal Forms, Boyce-Codd Normal Form.

 

ESSENTIAL READINGS: 
  1. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 7th Edition, McGraw Hill, 2019.

 

REFERENCES: 
  1. R. Elmarsi and S.B. Navathe, “Fundamentals of Database Systems”, Addison Wesley, 7th Ed., 2015.
  2. James R. Groff & Paul N. Weinberg, “The Complete Reference SQL”, McGraw Hill Education, 3 Edition, 2017
  3. Bipin Desai, “An Introduction to Database Systems”, Galgotia Publications, 2015.

 

Journals:  

  1. https://www.journals.elsevier.com/international-journal-of-information-management-data-insights
  2. https://journal-bcs.springeropen.com/

 

E-Resources:

  1. https://spoken-tutorial.org/
  2. https://www.slideshare.net/
  3. https://pll.harvard.edu/subject/computre-science
  4. https://onlinecourses.nptel.ac.in

 

Academic Year: 
2022-23
  • Printer-friendly version