Introducing the Database and the DBMS.
Design life cycle of Databases, Data modelling and Data model Case Study
Database Design
Entity Relation (ER) Model.
Extended Entity Relationship Model.
Relational Data Model Concepts.
Mapping of ER & EER-Model to Relational Model.
Basics of SQL: DDL Statements, DML Statements, Constraints and, Basic Retrieval Queries.
Relation Algebra
Functional Dependencies.
Normalization Basics and Need for Normalization
Physical Database design
Query Processing and Optimization
Transaction Processing.
Concurrency Control Techniques.
Explain fundamental database concepts.
Design conceptual, logical and physical database schemas using different data models.
Identify functional dependencies and resolve
Explain fundamental database concepts to build code of Structured Query Language.(Lab)
Use SQL in database definition and manipulation in any DBMS for utilizing effective group techniques.(Lab)
Lectures (audio/video aids), Written Assignments/ Quizzes, Tutorials, Case Studies relevant to engineering disciplines, Semester Project, Guest Speaker, Industrial/ Field Visits, Group discussion, Report Writing
Mid Term, Report writing/ Presentation, Assignments, Project Report, Quizzes, Final Term
Database System Concepts latest Edition by Abraham
Fundamentals of database by Elmasri, latest edition
Date, C, J.: “An Introduction to Database Systems”, latest Edition, Pearson,Boston
There are 133 total credit hours to complete the Software Engineering degree.
