www.android.universityupdates.in | www.universityupdates.in | https://telegram.me/jntuh
DBMS Unit 1
Database System Applications
A Historical Perspective
Early 1960s: Hierarchical and navigational data models used, inefficient and difficult to
manage.
Late 1960s: Charles Bachman invents the first general-purpose DBMS (Integrated
Data Store) using the network model.
Late 1970s: Edgar Codd proposes the relational model, using tables for easier data
storage and retrieval.
Late 1980s: IBM develops SQL for relational databases, allowing management of large
datasets.
1980s: Introduction of user-friendly DBMS products like Oracle, Sybase, and Microsoft
SQL Server.
1990s: Object-oriented DBMS (OODBMS) emerge for complex data structures, but
adoption is limited commercially.
1991: Microsoft releases MS Access, dominating the personal DBMS market.
1997: XML integration into DBMS products begins.
2000s: Rise of web applications and cloud computing leads to new DBMS systems like
NoSQL databases.
Today: DBMS continues to evolve, focusing on scalability, performance, and cloud
support. Popular options include Oracle, SQL Server, MySQL, PostgreSQL, and
MongoDB.
Database System Applications
A Historical Perspective
File Systems versus a DBMS
The Data Model
Levels of Abstraction in a DBMS
Data Independence
Structure of a DBMS
Introduction to Database Design
Database Design and ER Diagrams
Entities, Attributes, and Entity Sets
Relationships and Relationship Sets
www.android.previousquestionpapers.com | www.previousquestionpapers.com | https://telegram.me/jntuh
, www.android.universityupdates.in | www.universityupdates.in | https://telegram.me/jntuh
Additional Features of the ER Model
Conceptual Design With the ER Model
A Historical Perspective
Data collection and storage challenges
Evolution from hierarchical to relational models
Contributions of Charles Bachman and Edgar Codd
Emergence of SQL and relational databases
Evolution into object-oriented and NoSQL databases
Contemporary trends towards cloud-based applications
Introduction to Database Management System (DBMS)
Definition of data, database, and DBMS
Role of DBMS in managing data
Importance in various sectors like banking, education, etc.
Distinction between data and information
Significance of metadata in database management
Database System Applications
1. Banking
2. Universities
3. Airlines
4. Railways
www.android.previousquestionpapers.com | www.previousquestionpapers.com | https://telegram.me/jntuh
, www.android.universityupdates.in | www.universityupdates.in | https://telegram.me/jntuh
5. Sales
6. Manufacturing
7. Telecommunication
8. Human Resources
Advantages of Database Management System
1. Efficient data storage and retrieval
2. Data independence
3. Backup and recovery facilities
4. Consistent and updated information
5. Enhanced data security
6. Centralized data administration
7. Representation of complex data relationships
Components of DBMS
1. Hardware
Importance of hardware in DBMS
Examples of hardware components
2. Software
www.android.previousquestionpapers.com | www.previousquestionpapers.com | https://telegram.me/jntuh
DBMS Unit 1
Database System Applications
A Historical Perspective
Early 1960s: Hierarchical and navigational data models used, inefficient and difficult to
manage.
Late 1960s: Charles Bachman invents the first general-purpose DBMS (Integrated
Data Store) using the network model.
Late 1970s: Edgar Codd proposes the relational model, using tables for easier data
storage and retrieval.
Late 1980s: IBM develops SQL for relational databases, allowing management of large
datasets.
1980s: Introduction of user-friendly DBMS products like Oracle, Sybase, and Microsoft
SQL Server.
1990s: Object-oriented DBMS (OODBMS) emerge for complex data structures, but
adoption is limited commercially.
1991: Microsoft releases MS Access, dominating the personal DBMS market.
1997: XML integration into DBMS products begins.
2000s: Rise of web applications and cloud computing leads to new DBMS systems like
NoSQL databases.
Today: DBMS continues to evolve, focusing on scalability, performance, and cloud
support. Popular options include Oracle, SQL Server, MySQL, PostgreSQL, and
MongoDB.
Database System Applications
A Historical Perspective
File Systems versus a DBMS
The Data Model
Levels of Abstraction in a DBMS
Data Independence
Structure of a DBMS
Introduction to Database Design
Database Design and ER Diagrams
Entities, Attributes, and Entity Sets
Relationships and Relationship Sets
www.android.previousquestionpapers.com | www.previousquestionpapers.com | https://telegram.me/jntuh
, www.android.universityupdates.in | www.universityupdates.in | https://telegram.me/jntuh
Additional Features of the ER Model
Conceptual Design With the ER Model
A Historical Perspective
Data collection and storage challenges
Evolution from hierarchical to relational models
Contributions of Charles Bachman and Edgar Codd
Emergence of SQL and relational databases
Evolution into object-oriented and NoSQL databases
Contemporary trends towards cloud-based applications
Introduction to Database Management System (DBMS)
Definition of data, database, and DBMS
Role of DBMS in managing data
Importance in various sectors like banking, education, etc.
Distinction between data and information
Significance of metadata in database management
Database System Applications
1. Banking
2. Universities
3. Airlines
4. Railways
www.android.previousquestionpapers.com | www.previousquestionpapers.com | https://telegram.me/jntuh
, www.android.universityupdates.in | www.universityupdates.in | https://telegram.me/jntuh
5. Sales
6. Manufacturing
7. Telecommunication
8. Human Resources
Advantages of Database Management System
1. Efficient data storage and retrieval
2. Data independence
3. Backup and recovery facilities
4. Consistent and updated information
5. Enhanced data security
6. Centralized data administration
7. Representation of complex data relationships
Components of DBMS
1. Hardware
Importance of hardware in DBMS
Examples of hardware components
2. Software
www.android.previousquestionpapers.com | www.previousquestionpapers.com | https://telegram.me/jntuh
