Course Objectives: · To understand the basic concepts and the applications of database systems. · To master the basics of SQL and construct queries using SQL. · To understand the relational database design principles. · To become familiar with the basic issues of transaction processing and concurrency control. · To become familiar with database storage structures and access techniques. Course Outcomes: · Demonstrate the basic elements of a relational database management system. · Ability to identify the data models for relevant problems. . Ability to design entity relationship model and convert entity relationship diagrams into RDBMS and formulate SQL queries on the data. · Apply normalization for the development of application software

Introduction: Database System Applications, Purpose of Database Systems, View of Data, Database Languages â?? DDL, DML, Relational Databases, Database Design, Data Storage and Querying, Transaction Management, Database Architecture, Data Mining and Information Retrieval, Specialty Databases, Database Users and Administrators, History of Database Systems

Introduction to Data base design: Database Design and ER diagrams, Entities, Attributes and Entity sets, Relationships and Relationship sets, Additional features of ER Model, Conceptual Design with the ER Model, Conceptual Design for Large enterprises. Relational Model: Introduction to the Relational Model, Integrity Constraints over Relations, Enforcing Integrity constraints, Querying relational data, Logical data base Design: ER to Relational, Introduction to Views, Destroying /Altering Tables and Views.