#1
17th April 2015, 12:32 PM
| |||
| |||
DBMS Syllabus For Osmania University
I am studying in BCA 2nd Year at Osmania University. I have a subject named ’DBMS’ in my course. But the syllabus of DBMS was changed in last semester. I have new syllabus but in only points. So I want new detailed syllabus of DBMS to compare last time syllabus of Osmania University?
|
#2
20th July 2018, 09:45 AM
| |||
| |||
Re: DBMS Syllabus For Osmania University
Hello sir, Im student of Osmania University looking for Data base management system syllabus. Please provide me DBMS syllabus for Osmania University?
|
#3
20th July 2018, 09:48 AM
| |||
| |||
Re: DBMS Syllabus For Osmania University
The Osmania University is provides syllabus for DBMS. A database-management system is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data. A database is an organized collection of data, stored and accessed electronically. A database-management system (DBMS) is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data. DBMS syllabus for Osmania University DBMS syllabus for Osmania University: B.Sc(Computer Science): III Year THEORY PAPER III Database Management Systems Unit-1 : Database Systems Introduction and Fundamentals. Database Systems: Introducing the database and DBMS, Why the database is important Historical Roots: Files and File Systems, Problems with File System Data Management, Database Systems. Data Models: The importance of Data models, Data Model Basic Building Blocks, Business Rules, The evaluation of Data Models, Degree of Data Abstraction. The Relational Database Model: A logical view of Data, Keys, Integrity Rules, Relational Set Operators, The Data Dictionary and the system catalog, Relationships with in the Relational Database, Data Redundancy revisited, Indexes, Codds relational database rules. Unit-2 : Data Modeling and Normalization Entity Relationship Model: The ER Model, Developing ER Diagram, Database Design Challenges: Conflicting Goals. Advanced Data Modeling: The Extended Entity Relationship Model, Entity clustering, Entity integrity: Selecting Primary keys, Design Cases: Learning Flexible Database Design. Normalization of database tables: Database Tables and Normalization, The need for Normalization, The Normalization Process, Improving the design, Surrogate Key Considerations, High level Normal Forms, Normalization and database design, denormalization. Unit-3 : Interaction with Databases and Construction of Information System Introduction to SQL: Data Definition Commands, Data Manipulation Commands, Select queries, Advanced Data Definition Commands, Advanced Select queries, Virtual Tables, Joining Database Tables. Advanced SQL: Relational Set Operators, SQL Join Operators, Subqueries and correlated queries, SQL Functions, Oracle Sequences, Updatable Views, and Procedural SQL. Database Design: The Information System, The Systems Development Life Cycle, The Database Life Cycle, Database Design Strategies, Centralized Vs Decentralized design. Unit-4 : Transaction Management in DBMS Environment. Transaction Management and Concurrency Control: What is transaction, Concurrency control, Concurrency control with locking Methods, Concurrency control with time stamping methods, concurrency control with optimistic methods, database recovery management. Distributed Database Management Systems: The evolution of Distributed Database Management Systems, DDBMS advantages and Disadvantages, Distribution Processing and Distribution Databases, Characteristics of Distributed database management systems, DDBMS Components, Levels of Data and Process distribution, Distributed database Transparency Features, Distributed Transparency, Transaction Transparency, Performance Transparency and Query Optimization, Distributed Database Design, Client Server VS DDBMS. Unit-5 : Data Warehouse Concepts and Database Administration. The Data Warehouse: The need for data analysis, Decision support systems, The data warehouse, Online analytical processing, Star schemas, Data mining, SQL extension for OLAP. Database Administration: Data as a Corporate asset, The need for and role of databases in an organization, The evolution of the database administration function, The database environments Human Component, Database administration Tools, The DBA at work: Using Oracle for Database Administration. Here is PDF for DBMS syllabus for Osmania University; |