Page 1 :
4.2 DATABASE MANAGEMENT SYSTEM, , ae, —, aU, , RATIONALE, , The diploma holders in Computer Science and Engineering need to understand about, Relational Data base to manage the data at backend for different applications. They, should be able to develop basic table and write query to fetch the required data. Hence, this subject., , LEARNING OUTCOMES, , After undergoing the subject, the students will be able to:, e understand the concept of Database system and Client Server Architecture, e understand and develop the concepts of Data Modeling, Security and Integrity., e convert and compare the designs and differentiate between the keys, ¢ understand and execute different SQL queries and PL / SQL programs, ¢ convert database in the form of table, e normalize the database using normal forms., e understand the concept of query processing and Transaction processing, , DETAILED CONTENTS, 12. Database System Concept & Data Modeling (10 Periods), , Basic concepts, Advantages of a DBMS over file processing system, Data Abstraction,, Database Languages, Data Independence. , Components of a DBMS and overall, structure of a DBMS. ,Three views of Data (External View, Conceptual View, Internal, View), Three level architecture of DBMS, Data Independence, , Client Server, Architecture, , 13. Data Model (10 Periods), , Define data model, Data Models : Network Model Hierarchical Model, E-R Model,, Advantage & Disadvantages of each Data Model, , ER Model :