|
|
Bangalore University - B.Com 5th Sem - Relational Data Base Management [RDBMS] & MS-Access (Information Systems and Management)
RELATIONAL DATA BASE MANAGEMENT [RDBMS] & MS-ACCESS (Elective Paper - XI)
Module – I: 6 hours
Database and Database management Systems: Introduction. History of Database Management Systems, Characteristics of DBMS, Meaning and Definition of Database, objectives of database, advantages of database and disadvantages of traditional file environment systems, meaning and definition of Database Management Systems [DBMS], Designing Databases – Hierarchical Data model, Network Data model, and Relational Data models. Database trends: Distributed Databases, data warehousing, and data mining, Object-oriented hypermedia Databases, linking databases to the web.
Module – II: 10 hours
Relational Database [RDBMS]: The Relational Database Model – Techniques, Components of Relational Model, Definition of Relational Terms, Features of RDBMS, CODD’s 12 rules for a fully RDBMS. Relational implementation – Primary and Foreign Keys, Relationships in the relational model –introduction to ER – Model, one-to-one, one-to- many, many – to – many relationship, Examples of Data definition language, Quarries: - Maintaining Integrity – Defining Data Integrity, Integrity Rules, Relational Integrity Rules, Referential Integrity, Entity Integrity, Domain Integrity, Entity Integrity, User-defined Integrity, Integrity Constraints, Domain Constraints, Normalisation - Benefits of normalization, Functional Dependency and Determinants, Normalisation Theory, -Review of Normal Forms. Structured Quarry Language [SQL], Characteristics of SQL. Types of SQL [DCL, DDl, DML], Basic quarries in SQL – Single table, Multi table, Retrievals, Nested Quarries, Deletion, Insertion, and Update in SQL, Additional features of SQL.
Module – III: 12 hours
Object Modeling and Database Design: Introduction, Types of Data Models (Conceptual, Logical and Physical Data modeling), Model Development – Attributes of Modeling, types of Model viz., ER model, the object-oriented model, record based models, physical data models, Stages of Data modeling, Modeling – Three Schema Architecture, Entity Relationship [ER] – model, Entities Attributes and Relation [EAR] models, Entity Relationship Diagrams, Other Styles of ER Diagram, The Data Dictionary, Transforming from Logical to Physical, Storage Structure – types, Sorting and Indexes, Pointer chains, Advantages & Disadvantages of Pointer Chains, Sorting Data in a file, Necessity of files, Working parts of a DBMS, File Formats, Fixed Format Files, File Processing Activities, File organization & Methods, Clustered Indexes, Non – Clustered Indexes, Covering Indexes, Index Selection, Database Design: - Selecting your data, normalization, identifying domains, naming standards, denormalisation and the rules of reconstruction, physical design of databases, rule of reconstruction, over normalization, Reverse Engineering of Databases, Good Database Design, Designing DBMS for Enterprises.
Module – IV: 10 hours
Brief note on different types of DBMS, Introduction to MS-Access Opening a Database, Using table, quarry, form, reports etc., Creating a Database Table using table wizard, and table window in design view, defining fields, primary key fields, using datasheet, modifying the design of a table, making a backup copy, etc. Working with Data: - Adding and Editing Data, Finding Records, Quick Sorts, Changing the Format of the Data Sheet, Working with columns, other format changes, printing the datasheet. Querying and filtering your Data: - Working with simple Queries, Working with more complex queries, filters. Fast Forms, Reports, and Mailing Labels: - Using Forms, Auto Forms, Creating and using forms, the form wizard, working with data in the Form window, creating a sample form, using report- auto reports, creating and using reports, the report wizard, mailing labels and creating sample mailing labels. Relational Databases in Ms-Access:- Creating a Default Relationships, Creating a Sample Database, Queries with Relational Databases, Reports and Forms on Relational Databases, Using Lookup Fields for Data Entry.
Module –V: 12 hours
Designing Custom Forms in Ms-Access, Working with Expressions, Designing Custom Reports, Using Advanced queries, Saving Time with Macros, Utilities and Special Techniques.
Books for Reference:
1. Alexis Leon & C.K. Thomas “DB2 (IBM’s Database 2) The Complete Book for Application Programmers” – Comdex Computer Publication a division of Pustak Mahal.
2. R.K. Taxali “ dBASE III PLUS Made Simple With dBASE IV and FoxBASE +” – Tata McGraw – Hill Publishing Company Limited, New Delhi.
3. Er. V. K. Jain “ DATABASE MANAGEMENT SYSTEMS”- Dreamtech press, New Delhi.
4. Prof. S. Nandagopalan “ Database Management Systems- A Practical Approach” – Sapna Book House, Bangalore.
5. James Martin “ Principles of Data-Base Management” – Printice Hall of India New Delhi.
6. Dr. R. N. De “ Introduction to dBASE III PLUS for Beginners including programming” – The New book Stall, Calcutta.
7. Carol McCullough “Oracle 9i for Dummies” - Dieter
8. Wallace Wang & Roger C. Parker “ Ms- Office 200 Windows for Dummies”
9. P.S. Despande “ SQL PL/SQL for Oracle 8 & 8i”
10. Graeme C. Simsion “Data Modellling Essentials: The Ultimate Reference – 2nd Edition
11. John Kaufeld “ Access 2002 for Dummies” – Willy Dreamtech India Pvt. Ltd.,
12. Charles Siegel “ Teach yourself Access for Windows 95” – BPB Publications, New Delhi.
|