DBMS-I (Theory)

Paper Code: 
24CBCA305
Credits: 
04
Periods/week: 
04
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: 

Course

Learning Outcome

 (at course                level)

Learning and teaching strategies

Assessment Strategies

Course

 Code

Course

Title

24CBCA

305

 

 

DBMS-I

(Theory)

 

 

CO151. Apply    the concepts of data and file structure in real-world scenario.

CO152. Critically assess database systems covering applications, architecture, and history.

CO153.Analyse database requirements and develop the logical design of the database.

CO154. Assess relational model and create database using normalization principles.

CO155. Apply Structured Query Language (SQL) for Database definition and database manipulation.

CO156. Contribute effectively in course-specific interaction.

Approach in teaching: Interactive Lectures, Discussion, Reading assignments, Demonstration.

 

Learning activities for the students: Self learning assignments, Effective questions, Seminar presentation, Giving tasks, problem-based learning, problem formulation.

Class test, Semester end examinations, Quiz, Assignments, Presentation of case studies.

 

 

12.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).

 

12.00
Unit II: 

Introduction to Database System:

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.

 

12.00
Unit III: 

Entity-Relationship Model:

Introduction to Database design and Basic concepts, Entities-Weak & Strong Entities, Attributes and its types, Relationships and Relationship sets, Degree of Relationship Set, Weak Entity Sets, Constraints, Reduction to Relational Schemas, ER-Design Issues, Conceptual Design with ER Design, Applications & Examples

 

12.00
Unit IV: 

Relational Model:

Introduction, CODD Rules, DBMS Terms- Relation, Tuple, Attribute, , Domain Database Schema, Schema Diagrams, Integrity Constraints over Relations, Enforcing Integrity constraints, Keys - Super Key, Candidate key, Primary Key, Foreign Key.

Relational-Database Design:  Introduction to Normalization: Functional Dependencies, Normal Forms – First, Second, Third and Boyce Codd Normal forms with advantages and limitations

 

12.00
Unit V: 

Introduction to SQL:

SQL Data Definition, SQL Data Types, Types of SQL, Create Table, Describe Command, changing data with DML commands (Insert / Update Delete), SQL Operators, Order by, Distinct Keyword, Column Alias, Searching for NULL, Aggregate Functions

 

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

 

REFERENCES: 

Suggested READINGS:

  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/computer-science
  4. https://onlinecourses.nptel.ac.in/

 

Academic Year: 
2024-25
  • Printer-friendly version