2023 2024 Student Forum > Management Forum > Jobs

 
  #1  
17th April 2015, 12:32 PM
Unregistered
Guest
 
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?
Similar Threads
Thread
Madras University DBMS Syllabus
DBMS Syllabus MDU
Anna University Chennai DBMS Syllabus
BBM Syllabus Osmania University
MBA DBMS Syllabus
Osmania University EEE Syllabus
LLB 3 YDC Syllabus Osmania University
AMIE DBMS AMIE DBMS Question Papers
LLB Syllabus Osmania University
DBMS Notes For B.Sc Osmania University
Osmania University DBMS Syllabus
MBA DBMS Syllabus
Osmania University Syllabus for MBA
Osmania University Syllabus
IBPS SO DBMS Syllabus
BCA Syllabus Osmania University
MCA Syllabus Osmania University PDF
MDU DBMS syllabus
JNTU MCA DBMS Syllabus
Anna Univ. DBMS Syllabus
  #2  
20th July 2018, 09:45 AM
Unregistered
Guest
 
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
Super Moderator
 
Join Date: Aug 2012
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;
Attached Files
File Type: pdf DBMS syllabus for Osmania University.pdf (834.8 KB, 205 views)


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 07:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4