Categories
- Pharmacy
- Nursing
-
MBA
-
BBA
- U.P. State University
- Veer Bahadur Singh Purvanchal University, Jaunpur
- Chaudhary Charan Singh University, Meerut
- Dr. Bhimrao Ambedkar University, Agra
- Chhatrapati Shahu Ji Maharaj University, Kanpur
- Mahatma Jyotiba Phule Rohilkhand University, Bareilly
- Mahatma Gandhi Kashi Vidyapith, Varanasi
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Deen Dayal Upadhyaya Gorakhpur University
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj
- BCA
-
B Ed
- Lucknow University B.Ed Books
- Chaudhary Charan Singh University/Maa Shakambhari University, Saharanpur
- Dr Bhim Rao Ambedkar University, Agra
- Mahatma Gandhi Kashi Vidyapeeth, Varanasi
- Chhatrapati Shahu Ji Maharaj University
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj (PRSU)
- Mahatma Jyotiba Phule Rohilkhand University(Mjpru), Bareilly
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Bundelkhand University, Jhansi
- Deen Dayal Upadhyaya Gorakhpur University
- Veer Bahadur Purvanchal University (VBPU)
- Maharaja Suhel Dev State University ,Azamgarh (MSDSU)
- Raja Mahendra Pratap Singh State University, Aligarh (RMPSSU)
- Barkatullah Vishwavidyalaya (Bhopal)
- Jiwaji University (Gwalior)
- Vikram University (Ujjain)
- Dr. Harisingh Gour University (Sagar)
- Devi Ahilya Vishwavidyalaya (Indore)
- Rani Durgavati Vishwavidyalaya (Jabalpur)
- Awadhesh Pratap Singh University (Rewa)
- Maharaja Chhatrasal Bundelkhand University (Chhatarpur)
- D. EL. ED
- TET
-
B Com
-
B Sc
- B.Sc. U.P. State Universities Common Syllabus NEP
- Veer Bahadur Singh Purvanchal University, Jaunpur
- University of Lucknow
- Chaudhary Charan Singh University, Meerut
- Madhya Pradesh
- Chhatrapati Shahu Ji Maharaj University, Kanpur
- Dr. Bhimrao Ambedkar University, Agra
- Mahatma Gandhi Kashi Vidyapith, Varanasi
- DEEN DAYAL UPADHYAYA GORAKHPUR UNIVERSITY
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Mahatma Jyotiba Phule Rohilkhand University, Bareilly
- Uttarakhand State Universities
- B.Sc. Bihar Universities Common Syllabus NEP
- University of Rajasthan (Jaipur)
- Haryana
-
B A
- B.A. Of U.P. State Universities Common Syllabus NEP
- Veer Bahadur Singh Purvanchal University, Jaunpur
- University of Lucknow
- Chaudhary Charan Singh University, Meerut
- Chhatrapati Shahu Ji Maharaj University, Kanpur
- Dr. Bhimrao Ambedkar University, Agra
- Mahatma Gandhi Kashi Vidyapith, Varanasi
- Deen Dayal Upadhyaya Gorakhpur University
- Prof. Rajendra Singh (Rajju Bhaiya) University, Prayagraj
- Dr. Ram Manohar Lohia Avadh University, Ayodhya
- Mahatma Jyotiba Phule Rohilkhand University, Bareilly
- Madhya Pradesh
- Uttarakhand
- Bihar
- University of Rajasthan (Jaipur Syllabus as Per NEP2020)
- Haryana NEP-2020
- B Tech
COMPUTER NETWORKS JNTU-K MCA Second Sem
₹200.00
Tax excluded
Syllabus
Course Code: MCA2101
Database Management Systems
UNIT-I
Introduction to Databases: Introduction, An Example, Characteristics of the Database Approach, Actors on Scene, Workers Behind the Scene, Advantages of Using the DBMS Approach, A Brief History of Database Applications, When Not to Use a DBMS
Overview of Database Languages and Architectures: Data Models, Schemas and Instances, Three-Schema Architecture and Data Independence, Database Languages and Interfaces, The Database System Environment, Centralized and Client/Server Architecture for DBMSs, Classification of Database Management Systems
UNIT-II
Introduction to Database Design: Database Design and ER Diagrams, Entities, Attributes and Entity Sets, Relationships and Relationship Sets, Additional Features of the ER Model, Conceptual Design with the ER Model, Conceptual Design for Large Enterprises.
Relational Model: Introduction to the Relational Model, Integrity Constraints Over Relations, Enforcing Integrity Constraints, Querying Relational Data, Logical Database Design: ER to Relational, Introduction to Views, Destroying/Altering Tables and Views.
UNIT-III
Relational Algebra: Selection and Projection, Set Operations, Renaming, Joins, Division, More Examples of Algebra Queries.
SQL: Queries, Constraints, Triggers: The Form of a Basic SQL Query, UNION, INTERSECT and EXCEPT, Nested Queries, Aggregate Operators, Null Values, Complex Integrity Constraints in SQL, Triggers and Active Databases, Designing Active Databases.
UNIT-IV
Introduction to Normalization Using Functional and Multivalued Dependencies: Informal Design Guidelines for Relation Schema, Functional Dependencies, Normal Forms Based on Primary Keys, General Definitions of Second and Third Normal Forms, Boyce-Codd Normal Form, Multivalued Dependency and Fourth Normal Form, Join Dependencies and Fifth Normal Form.
UNIT-V
Transaction Management and Concurrency Control: Transaction Concept, A Simple Transaction Model, Storage Structure, ACID Properties, Serializability, Transaction Isolation Levels, Concurrency Control, Lock-Based Protocols, Validation-Based Protocols
JNTU-K2024/MCA/2/02
50 Items
New product