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