DBMS-I

Paper Code: 
25CBCA305
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

Course Objectives:

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

 

25CBCA305

 

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 relationalmodel and create database using normalization principles.

CO155. A pply 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: 

 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: