SIA

OSMANIA UNIVERSITY B-COM II YEAR / III SEM

arts and science b com osmania university
Latest (2021-22) Edition

B.com (General) II-Year III-Sem (Set Of 4 Subjects) General English, Financial Institutions And Markets, Advanced Accounting, Business Statistics-I, As Per The Latest (2019-20) CBCS Syllabus Of O.U, Latest Edition-2021-22

arts and science b com osmania university
Latest (2021-22) Edition

B.com (Computer Application) II-Year III-Sem (Set Of 4 Subjects) General English, Relational Database Management Systems, Advanced Accounting, Business Statistics-I, As Per The Latest (2019-20) CBCS Syllabus Of O.U, Latest Edition-2021-22

arts and science b com osmania university
Latest (2021-22) Edition

Text Book of Business Statistics –I, B.Com Second Year Third Semester, As Per the Prescriibed CBCS Syllabus (2019-20) Common for All Telangana State Universities 2021-22 ED

arts and science b com osmania university
Latest (2021-22) Edition

Business Statistics-I, B.Com II –Year- III Sem, As Per The Latest 2019-20 CBCS Syllabus Of B.Com (O.U) (Common For All Streams) Latest 2021-22 Edition

arts and science b com osmania university
Latest (2021-22) Edition

Al-Qira’ At Al-Arabia Al-Osmania (For B.A, B.Sc, B.Com,B.S.W & B.B.A Second Year) Second Language Arabic Paper-III Latest 2021-22 Edition

arts and science b com osmania university
Latest (2021-22) Edition

Advanced Accounting, B.Com II-Year III-Sem As Per The Latest 2019-20 CBCS Syllabus Of B.Com (O.U) (Common For All Streams) (DSC-301) Latest 2021-22 Edition

arts and science b com osmania university
Latest (2021-22) Edition

Telugu Paper-III (Second Language)II-YEAR III-Sem (O.U) (Common To B.A, B.Com, B.Sc, BBA, BSW) As Per The CBCS 2019-20 Syllabus, Latest 2021-2022 Edition

arts and science b com osmania university
Latest (2021-22) Edition

Hindi Paper-III (Second Language) II-YEAR III-Sem (O.U) (Common To B.A, B.Com, B.Sc, BBA, BSW) As Per The CBCS 2019-20 Syllabus, Latest 2021-22 Revised Edition

arts and science b com osmania university
Latest (2021-22) Edition

Sanskrit Paper-III (Second Language) II-YEAR III-Sem (O.U) (Common To B.A, B.Com, B.Sc, BBA, BSW) As Per The CBCS 2019-20 Syllabus, Latest 2021-2022 Revised Edition

arts and science b com osmania university
Latest (2021-22) Edition

Relational Database Management Systems B.Com II-Year III-Sem As Per The CBCS Syllabus Of O.U (Computer Applications) And Also Useful For B.Sc II-Year III-Sem (Computer Applications) Latest 2021-22 Edition

Relational Database Management Systems B.Com II-Year III-Sem As Per The CBCS Syllabus Of O.U (Computer Applications) And Also Useful For B.Sc II-Year III-Sem (Computer Applications) Latest 2021-22 Edition

SYLLABUS

UNIT-I

Basic Concepts: Database Management System – File Based System – Advantages of DBMS Over File Based System – Database Approach – Logical DBMS Architecture – Three Level Architecture of DBMS or Logical DBMS Architecture – Need for Three level Architecture – Physical DBMS Architecture – Database Administrator (DBA) Functions and Role – Data Files, Indices and Data Dictionary – Types of Database. Relational and ER Models: Data Models – Relational Model – Domains – Tuple and Relation – Super Keys – Candidate Keys – Primary Keys and Foreign Keys for the Relations – Relational Constraints – Domain Constraint – Key Constraint – Integrity Constraint – Update Operations and Dealing with Constraint Violations – Relational Operations – Entity Relationship (ER) Model – Entities – Attributes – Relationships – More about Entities and Relationships – Defining Relationship for College Database – E-R Diagram – Conversion of E-R Diagram to Relational Database.

UNIT-II

Database Integrity And Normalisation: Relational Database Integrity – The Keys – Referential Integrity – Entity Integrity – Redundancy and Associated Problems – Single Valued Dependencies – Normalisation – Rules of Data Normalisation – The First Normal Form – The Second Normal Form – The Third Normal Form – Boyce Codd Normal Form – Attribute Preservation – Lossless-join Decomposition – Dependency Preservation. File Organisation : Physical Database Design Issues – Storage of Database on Hard Disks – File Organisation and Its Types – Heap Files (Unordered Files) – Sequential File Organisation – Indexed (Indexed Sequential) File Organisation – Hashed File Organisation – Types of Indexes – Index and Tree Structure – Multi-key File Organisation – Need for Multiple Access Paths – Multi-list File Organisation – Inverted File Organisation.

UNIT-III

Structured Query Language (SQL): Meaning – SQL Commands – Data Definition Language – Data Manipulation Language – Data Control Language – Transaction Control Language – Queries using Order by – Where – Group by – Nested Queries, Joins – Views – Sequences – Indexes and Synonyms – Table Handling.

UNIT-IV

Transactions And Concurrency Management: Transactions – Concurrent Transactions – Locking Protocol – Serialisable Schedules – Locks Two Phase Locking (2PL) – Deadlock and its Prevention – Optimistic Concurrency Control. Database Recovery and Security: Database Recovery Meaning – Kinds of Failures – Failure Controlling Methods – Database Errors – Backup and Recovery Techniques – Security and Integrity – Database Security – Authorization

UNIT-V

Distributed And Client Server Databases: Need for Distributed Database Systems – Structure of Distributed Database – Advantages and Disadvantages of DDBMS – Advantages of Data Distribution – Disadvantages of Data Distribution – Data Replication – Data Fragmentation. Client Server Databases: Emergence of Client Server Architecture – Need for Client Server Computing – Structure of Client Server System and its Advantages.

arts and science b com osmania university
Latest (2021-22) Edition

Financial Institutions And Markets B.com II-Year III-Sem (OU) As Per The Latest (2019-20) CBCS Syllabus Of B.COM (OU) Common Paper For General & Honours Courses Latest 2021-2022 Edition