Complete RGPV exam-oriented page covering Database Management System, file oriented and database approach, data models, DBMS architecture, data independence, data dictionary, DBA, primary key, DDL, DML, cloud computing, cloud infrastructure, IaaS, PaaS, SaaS and types of cloud.
Basic Computer Engineering Unit 5 important topics
Easy revision notes for RGPV exam
DBMS is software used to create, manage and control databases. It provides data storage, retrieval, security, backup and sharing.
DBMS reduces data redundancy, improves security, supports easy data management and allows data sharing among users.
In file oriented approach, data is stored in separate files. It causes data redundancy, inconsistency, difficult access and poor security.
Data model defines the structure of database. Important models are hierarchical model, network model, relational model and object oriented model.
Three-level DBMS architecture contains external level, conceptual level and internal level. It provides data abstraction and data independence.
Data independence means ability to modify database structure without affecting applications. Its types are logical data independence and physical data independence.
Data dictionary stores information about database structure such as table names, attributes and constraints.
Database Administrator is responsible for database security, backup and recovery, performance monitoring and overall database management.
Primary key uniquely identifies each record in a table. It must be unique and cannot contain NULL values.
Cloud computing means delivery of computing services over internet. Services include storage, servers, databases, networking and software.
IaaS provides virtual hardware, PaaS provides platform for development and SaaS provides software over internet.
Public cloud is available to public, private cloud is used by one organization, community cloud is shared by common organizations and hybrid cloud combines public and private cloud.
Very important for exam examples
DDL Commands:
CREATE, ALTER, DROP, TRUNCATE
DML Commands:
INSERT, UPDATE, DELETE, SELECT
Example:
CREATE TABLE Student(
RollNo INT PRIMARY KEY,
Name VARCHAR(50)
);
INSERT INTO Student VALUES(101, 'Amit');
SELECT * FROM Student;
Must remember points for exam
High chance RGPV exam questions
Repeated questions from uploaded RGPV PYQ papers
| Topic | Repeated Questions | Frequency | Priority |
|---|---|---|---|
| DBMS | DBMS definition, advantages, applications and database approach | Very High | ★★★★★ |
| Cloud Computing | Cloud computing, cloud infrastructure, advantages and disadvantages | Very High | ★★★★★ |
| DDL & DML | DDL commands, DML commands and SQL examples | Very High | ★★★★★ |
| Database Architecture | Three-level architecture, diagram and data independence | High | ★★★★ |
| Cloud Service Models | IaaS, PaaS and SaaS with examples | High | ★★★★ |
| Data Models | Hierarchical, network, relational and object oriented models | High | ★★★★ |
| Primary Key & DBA | Primary key, data dictionary and DBA responsibilities | Medium | ★★★ |
| Cloud Deployment Models | Public, private, community and hybrid clouds | Medium | ★★★ |
Keep these PDFs in the same folder as this HTML file
Common student doubts
DBMS, cloud computing, DDL and DML, database architecture, cloud service models and data models are most important.
DBMS architecture diagram, cloud service model diagram and cloud deployment model diagram are important.
File oriented vs database approach, DDL vs DML, public vs private cloud, IaaS vs PaaS vs SaaS and hierarchical vs relational model are important.