Softex IT Solutions Aug.2013 | Page 38

Page no:38 IT22 - Database Management System Objective : The concepts related to database, database techniques, SQL and database operations are introduced in this subject. This creates strong foundation for application data design. Sr. No 1 Nos. of Session Reference Books Chapter Details Basic concepts 1.1 Database and Need for DBMS 1.2 Characteristics of DBMS 1.3 Database Users 1.4 3-tier architecture of DBMS (its advantages over 2-tier) 1.5 Data Models 1.6 Views of data-schemas and instances 1.7 Data Independence 1.8 Conventional data models & systems 1.8.1 NDM & HDMExpressing relationships, DBTG set Database Design using ER model 2.1 Entities 2.2 Relationships 2.3 Representation of entities, attributes, relationship attributes, relationship set 2.4 Generalization, aggregation 2.4 Structure of relational Database and differe ?\\???^\? ???^?\??[??N???[][??[][?[[?[ ?H??8?&\??[\? ???[][?[]H[?[ ??[][?[[?X??H ???T?[][?[[?[???\ ?????[][?[[?[????Z[?? ????[][?[[?X??H ???[][?[]X?\?H[??XY?H]HY?[?][?[??S ?Y]??[?]Y\?Y\?[??S ?X?Y?Z[??????Z[??[?[?^\?[??S ?X?Y?Z[??????Z[??X[?Y?[Y[??\?[\??X?K[??\??[][?[]X?\?H\?Y? ?H]X?\?H\?Y?8?$?T???[][?[ ???[??[?[\[?[??Y\?????K ? ????????K ?  K????B??K ? K K L?????? K ? L??