Skip to main content

DATABASE MANAGEMENT SYSTEMS


MC9213          DATABASE MANAGEMENT SYSTEMS        L T P C                      3 0 0 3

UNIT I         INTRODUCTION                                                                       9       
Historical perspective - Files versus database systems - Architecture - E-R model - Security and Integrity - Data models.

UNIT II            RELATIONAL MODEL                                                                              9
The relation - Keys - Constraints - Relational algebra and Calculus - Queries - Programming and triggers

UNIT III           DATA STORAGE                                                                                      9
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based indexing

UNIT IV   QUERY EVALUATION AND DATABASE DESIGN                                           9
External sorting - Query evaluation - Query optimization - Schema refinement and normalization - Physical database design and tuning - Security

UNIT V            TRANSACTION MANAGEMENT                                                            9
Transaction concepts - Concurrency control - Crash recovery - Decision support - Case studies
                                                                             
                                                                                                      TOTAL = 45

REFERENCES:

1.            Raghu RamaKrishnan and Johannes Gehrke, “Database Management Systems”, McGraw Hill International Editions, 2000.
2.            C. J. Date, “An Introduction to Database Systems”, Seventh Edition, Addison Wesley, 1997.
3.            Abraham Silberschatz, Henry. F. Korth and S. Sudharshan, “Database system Concepts”, Third Edition, Tata McGraw Hill, 1997.

 

 
Labels:

Comments

Post a Comment

Popular posts from this blog

ACCOUNTING AND FINANCIAL MANAGEMENT

MC9215          ACCOUNTING AND FINANCIAL MANAGEMENT            T P C 3 1 0 4 UNIT I             FINANCIAL ACCOUNTING                                                                       9               Meaning and Scope of Accounting-Principles-Concepts-Conventions-Accounting Standards-Final Accounts-Trail Balance-Trading Account-Profit and Loss Account-Balance Sheet-Accounting Ratio Analysis-Funds Flow Analysis-Cash Flow Analysis                                                                                                                               UNIT II             ACCOUNTING                                                                                           9            Meaning-Objectives-Elements of Cost-Cost Sheet-Marginal Costing and Cost Volume Profit Analysis-Break Even Analysis-Applications-Limitations-Standard Costing and Variance Analysis-Material-Labor-Overhead-Sales-Profit Variances                                                       
1 comment
Read more

SOFTWARE PROJECT MANAGEMENT

MC9252          SOFTWARE PROJECT MANAGEMENT                  L T P C  3 0 0 3 UNIT I                  INTRODUCTION TO SOFTWARE PROJECT MANAGEMENT          9 Project Definition – Contract Management – Activities Covered By Software Project Management – Overview Of Project Planning – Stepwise Project Planning. UNIT II            PROJECT EVALUATION                                                                         9 Strategic Assessment – Technical Assessment – Cost Benefit Analysis – Cash Flow Forecasting – Cost Benefit Evaluation Techniques – Risk Evaluation. UNIT III           ACTIVITY PLANNING                                                                               9 Objectives – Project Schedule – Sequencing And Scheduling Activities – Network Planning Models – Forward Pass – Backward Pass – Activity Float – Shortening Project Duration – Activity On Arrow Networks – Risk Management – Nature Of Risk – Types Of Risk – Managing Risk
Read more

VISUAL PROGRAMMING

MC9243          VISUAL PROGRAMMING                                                                                       L T P C 3 0 0 3 UNIT I              WINDOWS PROGRAMMING                                                                   8 The windows programming Model – Event driven programming –  GUI concepts – Overview of Windows programming – Creating and displaying the window – Message Loop – windows procedure – WM_PAINT message – WM_DESTROY message – Data types – Resources  –  An Introduction to GDI – Device context –  Text output –  Scroll Bars – Keyboard – Mouse – Menus. UNIT II            VISUAL BASIC PROGRAMMING                                                          10 Visual Basic Applications – Form and properties – Variables and Constants –  Variant type – Procedure scope – Main –  Control statements –  control arrays –  Creating and using Controls – Menus and Dialogs – Programming fundamentals – Objects and instances – Debugging – Responding
Read more