Department Events
DATABASE MANAGEMENT SYSTEMS
COURSE OBJECTIVE:
This module is designed to help students to know about the fundamental concepts of database management.
Course Outcomes (At Course Level) | Learning And Teaching Strategies | Assessment Strategies |
The Students will : CO61. Understand the fundamental concepts of a database system | Approach in teaching: Interactive Lectures, Discussions, student centered approach, Through video Tutorials Learning activities: Presentations, Quizzes and Assignments | Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects and peer review.
|
Introduction: Database definition, History of Database Systems, Database System Applications, Database Systems versus conventional File Systems, View of Data, Data Abstraction, Data Independence.
Introduction to Data Models (Network, Hierarchical, Relational), Database Languages, Database Users and Administrators.
Entity-Relationship Model: E-R diagram, Constraints, Keys (Candidate key, Alternate key, Primary Key, Foreign Keys), Weak Entity Sets.
Relational Algebra: Basics of relational algebra [Select, Project, Union, Set Difference, Cartesian-Product, Natural join]
Relational-Database Design: Normalization, Functional Dependencies, Normalized forms [1NF, 2NF, 3NF].
ORACLE: Introduction, Oracle Server and Oracle Database, Two and Three-tier architecture, Login Screen, Entering Name and Password.
Data Types, Null values, comments, SQL command syntax.
SQL SELECT Statement: Selecting All the Columns, Reordering columns in Query Results, Selecting Specific Column, Duplicate rows and their elimination (DISTINCT keyword).SQL: Displaying Table Structure (DESC command), Limiting Rows during selection (using WHERE clause), concatenating strings.
Operators: Relational operators, Logical operators. Condition based on a range (BETWEEN Operator), Condition based on a list (IN Operator), Condition based on pattern match (LIKE Operator). Searching and Sorting: Searching for NULL (IS NULL), Sorting results (ORDER BY Clause). Making simple queries based on these operations.
SQL Functions and Grouping: Types of SQL Function (Single Row/Multiple Row).
Character Functions - Case Conversion, Character Manipulation.
Numeric Functions, Date Functions.
Grouping result – Group By command, placing conditions on groups – Having Clause. Simple Queries based on these operations.
- Avi Silberschatz, Henry F. Korth, S. Sudarshan,” Database System Concepts”, Seventh Edition, McGraw-Hill, ISBN 9780078022159
2. A. Leon & Leon, “SQL: A Complete Reference”, Tata McGraw-Hill Education, 1999.
SUGGESTED READINGS:
1. R. Ramakrishnan and J. Gehrke, “Database Management System”, Tata McGraw Hill, Latest edition 2007
2. C. J. Date, “An introduction to Database Management System”, Pearson Education Asia, 8th Edition.
3. Sheela Newsheeba M and Sudhakar D, “Simple SQL QUERIES: with practical implementation”, Paper book Sept, 2021.
4. Russell Newton, “SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL”, Walter Shields, Nov 2015, ClydeBank Media
JOURNALS:
- https://www.journals.elsevier.com/international-journal-of-information-management-data-insights
- https://journalofcloudcomputing.springeropen.com/
- https://braininformatics.springeropen.com/
E- RESOURCES:
- https://www.tutorialspoint.com/dbms/pdf
- https://engineeringinterviewquestions.com/dbms-lab-viva-questions-and-answers
- https://www.jbiet.edu.in/coursefiles/cse/HO/cse2/DBMSI-III.pdf
- https://gfgc.kar.nic.in/raibag/FileHandler/270-101d616b-255a-4add-8d9b-dd2e22fec7c1.pdf
- https://mu.ac.in/wp-content/uploads/2021/08/USIT304-Database-Management-Systems.pdf
- https://mrcet.com/downloads/digital_notes/ECE/III%20Year/DATABASE%20MANAGEMENT%20SYSTEMS.pdf
