Skip to content
CampusPrep
BT-205 · Basic Computer Engineering/Quick Revision Short Notes

Basic Computer Engineering (BT-205) - Unit 5 Short Notes

How unit 5 is examined

The unit covers DBMS (architecture, data independence, DBA, DDL/DML, data dictionary, transactions) and cloud computing (infrastructure, service and deployment models, pros and cons); both topics carry high marks.

Data base Management System: Introduction, File oriented approach and Database approach, Data Models, Architecture of Database System, Data independence, Data dictionary, DBA, Primary Key, Data definition language and Manipulation Languages

<span style="display:inline-block;padding:.16em .6em;border:1.5px solid currentColor;border-radius:999px;font-size:.68em;font-weight:700;letter-spacing:.06em;text-transform:uppercase;opacity:.75">High weight</span>

Definition. <mark>A DBMS is software that lets users define, create, store, retrieve, update and control a shared, organised collection of related data (the database) while keeping it consistent and secure.</mark>

File approach vs database approach.

Point File-oriented Database (DBMS)
Redundancy Same data repeated in many files Controlled, data stored once
Consistency Copies disagree One copy, consistent
Program-data link Data format inside programs Data independence
Sharing and security Poor Multi-user, access control
Backup and recovery Manual Built in

Data models. A data model describes structure and relationships: hierarchical (tree), network (graph of records), relational (tables of rows and columns, most widely used) and object-oriented.

Diagram.

<figure class="ds-fig" style="margin:1.4rem 0;overflow-x:auto"><svg xmlns="http://www.w3.org/2000/svg" id="dsfig-u5-01" viewBox="0 0 338 406.8" width="338" height="406.8" role="img" aria-label="Three-level architecture. U1-U3 = external views (users), CON = conceptual level (whole logical schema), INT = internal level (physical storage), DB = disk"><style>#dsfig-u5-01 .e{stroke:#454C5A;stroke-width:1.4;fill:none}#dsfig-u5-01 .e.hi{stroke:#2340B8;stroke-width:2.6}#dsfig-u5-01 .n{fill:#FFFFFF;stroke:#16181D;stroke-width:1.4}#dsfig-u5-01 .n.hi{fill:#E3E9FC;stroke:#2340B8;stroke-width:2.2}#dsfig-u5-01 .n.rb-b{fill:#16181D;stroke:#16181D}#dsfig-u5-01 .n.rb-r{fill:#BD3227;stroke:#BD3227}#dsfig-u5-01 text{font-family:"JetBrains Mono",ui-monospace,Menlo,Consolas,monospace;font-size:13px}#dsfig-u5-01 .t{fill:#16181D;font-weight:500}#dsfig-u5-01 .t.inv{fill:#FFFFFF;font-weight:700}#dsfig-u5-01 .kd{stroke:#16181D;stroke-width:1.2}#dsfig-u5-01 .dot{fill:#16181D}#dsfig-u5-01 .ann{fill:#2340B8;font-size:11px;font-weight:700}#dsfig-u5-01 .lbl{fill:#6F7787;font-family:system-ui,-apple-system,sans-serif;font-size:12px;font-weight:700}#dsfig-u5-01 .ptr{fill:#2340B8;font-size:12px;font-weight:700}#dsfig-u5-01 .ah{fill:#454C5A}#dsfig-u5-01 .ah.hi{fill:#2340B8}#dsfig-u5-01 .wl rect{fill:#FFFFFF;stroke:#DCE0E7}#dsfig-u5-01 .wl .t{font-size:12px;font-weight:700}#dsfig-u5-01 .wl.hi rect{fill:#2340B8;stroke:#2340B8}#dsfig-u5-01 .wl.hi .t{fill:#FFFFFF}html.dark #dsfig-u5-01 .e{stroke:#B1B7C3}html.dark #dsfig-u5-01 .e.hi{stroke:#8FA3FF}html.dark #dsfig-u5-01 .n{fill:#161920;stroke:#E6E8ED}html.dark #dsfig-u5-01 .n.hi{fill:#1E2748;stroke:#8FA3FF}html.dark #dsfig-u5-01 .n.rb-b{fill:#E6E8ED;stroke:#E6E8ED}html.dark #dsfig-u5-01 .n.rb-r{fill:#FF7E71;stroke:#FF7E71}html.dark #dsfig-u5-01 .t{fill:#E6E8ED}html.dark #dsfig-u5-01 .t.inv{fill:#0F1115}html.dark #dsfig-u5-01 .kd{stroke:#E6E8ED}html.dark #dsfig-u5-01 .dot{fill:#E6E8ED}html.dark #dsfig-u5-01 .ann{fill:#8FA3FF}html.dark #dsfig-u5-01 .lbl{fill:#858D9C}html.dark #dsfig-u5-01 .ptr{fill:#8FA3FF}html.dark #dsfig-u5-01 .ah{fill:#B1B7C3}html.dark #dsfig-u5-01 .ah.hi{fill:#8FA3FF}html.dark #dsfig-u5-01 .wl rect{fill:#161920;stroke:#2A2E37}html.dark #dsfig-u5-01 .wl.hi rect{fill:#8FA3FF;stroke:#8FA3FF}html.dark #dsfig-u5-01 .wl.hi .t{fill:#0F1115}</style><defs><marker id="ah12" viewBox="0 0 10 10" refX="9" refY="5" markerWidth="7" markerHeight="7" orient="auto-start-reverse"><path class="ah" d="M0,1 L9,5 L0,9 z"/></marker><marker id="ahh12" viewBox="0 0 10 10" refX="9" refY="5" markerWidth="7" markerHeight="7" orient="auto-start-reverse"><path class="ah hi" d="M0,1 L9,5 L0,9 z"/></marker></defs><path class="e" d="M55.9,53.8 L153.1,138" marker-end="url(#ah12)" marker-start="url(#ah12)"/><path class="e" d="M169,61 L169,130.8" marker-end="url(#ah12)" marker-start="url(#ah12)"/><path class="e" d="M282.1,53.8 L184.9,138" marker-end="url(#ah12)" marker-start="url(#ah12)"/><path class="e" d="M169,172.8 L169,242.6" marker-end="url(#ah12)" marker-start="url(#ah12)"/><path class="e" d="M169,284.6 L169,345.8" marker-end="url(#ah12)" marker-start="url(#ah12)"/><circle class="n" cx="40" cy="40" r="18"/><text class="t" x="40" y="40" dy=".35em" text-anchor="middle">U1</text><circle class="n" cx="169" cy="40" r="18"/><text class="t" x="169" y="40" dy=".35em" text-anchor="middle">U2</text><circle class="n" cx="298" cy="40" r="18"/><text class="t" x="298" y="40" dy=".35em" text-anchor="middle">U3</text><circle class="n" cx="169" cy="151.8" r="18"/><text class="t" x="169" y="151.8" dy=".35em" text-anchor="middle">CON</text><circle class="n" cx="169" cy="263.6" r="18"/><text class="t" x="169" y="263.6" dy=".35em" text-anchor="middle">INT</text><circle class="n" cx="169" cy="366.8" r="18"/><text class="t" x="169" y="366.8" dy=".35em" text-anchor="middle">DB</text></svg><figcaption style="font-size:.82em;opacity:.72;margin-top:.45rem">Three-level architecture. U1-U3 = external views (users), CON = conceptual level (whole logical schema), INT = internal level (physical storage), DB = disk</figcaption></figure>

Key points.

  1. The external (view) level shows each user only the part of the database relevant to them, hiding the rest.
  2. The conceptual (logical) level describes the whole database: entities, attributes, relationships and constraints, independent of storage.
  3. The internal (physical) level describes how data is stored: files, indexes, record layout and access paths.
  4. Physical data independence means the internal schema can change (new index, new file organisation) without changing the conceptual schema.
  5. Logical data independence means the conceptual schema can change (add a field or table) without changing external views or programs; it is harder to achieve.
  6. Functionally, the query processor (DDL interpreter, DML compiler, query evaluation engine) works with the storage manager (buffer, file, authorization and transaction managers) over the data files and data dictionary.
  7. The data dictionary is a central repository of metadata: table and column names, data types, keys, constraints, users and privileges. Example: EMP(ID int primary key, Name varchar(30)) is recorded as entries in it.
  8. The primary key is a minimal attribute set that uniquely identifies each row and cannot be NULL (for example, RollNo).
  9. DBA functions: schema definition, storage structure, user authentication and access rights (security), integrity constraints, backup and recovery, and performance tuning through indexing and query optimisation.
  10. A transaction is a logical unit of work executed as one indivisible task; COMMIT saves it and ROLLBACK undoes it after failure, which prevents inconsistent states. ACID: Atomicity (all or nothing), Consistency (valid state to valid state), Isolation (concurrent transactions do not interfere), Durability (committed data survives crashes).

DDL and DML.

DDL (defines structure) DML (handles data)
Commands CREATE, ALTER, DROP, TRUNCATE SELECT, INSERT, UPDATE, DELETE
Example CREATE TABLE Emp(Id INT PRIMARY KEY, Name VARCHAR(30)); INSERT INTO Emp VALUES(1,'Ravi');
More ALTER TABLE Emp ADD Salary INT; DROP TABLE Emp; UPDATE Emp SET Salary=500 WHERE Id=1; DELETE FROM Emp WHERE Id=1; SELECT * FROM Emp;

DML is procedural (user says what and how) or non-procedural (only what, as in SQL).

Answer frame. Architecture: open with the three-level definition; draw the diagram; develop points 1-5 then 6; close with data independence. DDL/DML: define both, give the table with one example each. DBA: list functions under performance, integrity, security. Transaction: define, then ACID, then commit and rollback.

Pitfall: Do not confuse physical independence (storage changes) with logical independence (schema changes).

Asked: [7 marks] (Jun 2022, Dec 2024) Draw and explain the architecture of database systems; describe the key components of a DBMS architecture. Asked: [7 marks] (Nov 2022) Explain DDL and DML commands with suitable examples. Asked: [7 marks] (Jun 2023) Describe data independence and DBA in detail. Asked: [7 marks] (Jun 2024) What is a database transaction and why is it important in maintaining data integrity? Asked: [7 marks] (Jun 2025) Describe the functions of a DBA in maintaining performance, integrity and security of a database. Asked: [14 marks] (Dec 2023) Explain with example: a) Data dictionary b) Cloud infrastructure. Asked: [14 marks] (Jun 2024) Short notes: i) DDL and DML commands ii) Remote Sensing and GIS iii) I/O Device. Asked: [14 marks] (Nov 2022) Short notes: a) Cloud Infrastructure b) DBA c) Logic Bombs. Asked: [14 marks] (Jun 2022) Short notes: a) Good computer security habits b) Data Manipulation Language c) IaaS and PaaS. Asked: [14 marks] (Dec 2024) Short notes: i) Logical operators in C++ ii) Data Independence iii) Service delivery models in cloud computing.

Cloud computing: definition, cloud infrastructure, cloud segments or service delivery models (IaaS, PaaS and SaaS), cloud deployment models/ types of cloud (public, private, community and hybrid clouds), Pros and Cons of cloud computing

<span style="display:inline-block;padding:.16em .6em;border:1.5px solid currentColor;border-radius:999px;font-size:.68em;font-weight:700;letter-spacing:.06em;text-transform:uppercase;opacity:.75">High weight</span>

Definition. <mark>Cloud computing is the on-demand delivery of computing resources (servers, storage, databases, software) over the Internet on a pay-as-you-go basis.</mark>

Diagram.

<figure class="ds-fig" style="margin:1.4rem 0;overflow-x:auto"><svg xmlns="http://www.w3.org/2000/svg" id="dsfig-u5-02" viewBox="0 0 604 194" width="604" height="194" role="img" aria-label="Cloud classification"><style>#dsfig-u5-02 .e{stroke:#454C5A;stroke-width:1.4;fill:none}#dsfig-u5-02 .e.hi{stroke:#2340B8;stroke-width:2.6}#dsfig-u5-02 .n{fill:#FFFFFF;stroke:#16181D;stroke-width:1.4}#dsfig-u5-02 .n.hi{fill:#E3E9FC;stroke:#2340B8;stroke-width:2.2}#dsfig-u5-02 .n.rb-b{fill:#16181D;stroke:#16181D}#dsfig-u5-02 .n.rb-r{fill:#BD3227;stroke:#BD3227}#dsfig-u5-02 text{font-family:"JetBrains Mono",ui-monospace,Menlo,Consolas,monospace;font-size:13px}#dsfig-u5-02 .t{fill:#16181D;font-weight:500}#dsfig-u5-02 .t.inv{fill:#FFFFFF;font-weight:700}#dsfig-u5-02 .kd{stroke:#16181D;stroke-width:1.2}#dsfig-u5-02 .dot{fill:#16181D}#dsfig-u5-02 .ann{fill:#2340B8;font-size:11px;font-weight:700}#dsfig-u5-02 .lbl{fill:#6F7787;font-family:system-ui,-apple-system,sans-serif;font-size:12px;font-weight:700}#dsfig-u5-02 .ptr{fill:#2340B8;font-size:12px;font-weight:700}#dsfig-u5-02 .ah{fill:#454C5A}#dsfig-u5-02 .ah.hi{fill:#2340B8}#dsfig-u5-02 .wl rect{fill:#FFFFFF;stroke:#DCE0E7}#dsfig-u5-02 .wl .t{font-size:12px;font-weight:700}#dsfig-u5-02 .wl.hi rect{fill:#2340B8;stroke:#2340B8}#dsfig-u5-02 .wl.hi .t{fill:#FFFFFF}html.dark #dsfig-u5-02 .e{stroke:#B1B7C3}html.dark #dsfig-u5-02 .e.hi{stroke:#8FA3FF}html.dark #dsfig-u5-02 .n{fill:#161920;stroke:#E6E8ED}html.dark #dsfig-u5-02 .n.hi{fill:#1E2748;stroke:#8FA3FF}html.dark #dsfig-u5-02 .n.rb-b{fill:#E6E8ED;stroke:#E6E8ED}html.dark #dsfig-u5-02 .n.rb-r{fill:#FF7E71;stroke:#FF7E71}html.dark #dsfig-u5-02 .t{fill:#E6E8ED}html.dark #dsfig-u5-02 .t.inv{fill:#0F1115}html.dark #dsfig-u5-02 .kd{stroke:#E6E8ED}html.dark #dsfig-u5-02 .dot{fill:#E6E8ED}html.dark #dsfig-u5-02 .ann{fill:#8FA3FF}html.dark #dsfig-u5-02 .lbl{fill:#858D9C}html.dark #dsfig-u5-02 .ptr{fill:#8FA3FF}html.dark #dsfig-u5-02 .ah{fill:#B1B7C3}html.dark #dsfig-u5-02 .ah.hi{fill:#8FA3FF}html.dark #dsfig-u5-02 .wl rect{fill:#161920;stroke:#2A2E37}html.dark #dsfig-u5-02 .wl.hi rect{fill:#8FA3FF;stroke:#8FA3FF}html.dark #dsfig-u5-02 .wl.hi .t{fill:#0F1115}</style><defs><marker id="ah13" viewBox="0 0 10 10" refX="9" refY="5" markerWidth="7" markerHeight="7" orient="auto-start-reverse"><path class="ah" d="M0,1 L9,5 L0,9 z"/></marker><marker id="ahh13" viewBox="0 0 10 10" refX="9" refY="5" markerWidth="7" markerHeight="7" orient="auto-start-reverse"><path class="ah hi" d="M0,1 L9,5 L0,9 z"/></marker></defs><line class="e" x1="250" y1="37" x2="108" y2="101"/><line class="e" x1="250" y1="37" x2="392" y2="101"/><line class="e" x1="108" y1="101" x2="40" y2="165"/><line class="e" x1="108" y1="101" x2="108" y2="165"/><line class="e" x1="108" y1="101" x2="176" y2="165"/><line class="e" x1="392" y1="101" x2="251.5" y2="165"/><line class="e" x1="392" y1="101" x2="338.5" y2="165"/><line class="e" x1="392" y1="101" x2="437.5" y2="165"/><line class="e" x1="392" y1="101" x2="532.5" y2="165"/><rect class="n" x="181.5" y="22" width="137" height="30" rx="8"/><text class="t" x="250" y="37" dy=".35em" text-anchor="middle">Cloud computing</text><rect class="n" x="43" y="86" width="130" height="30" rx="8"/><text class="t" x="108" y="101" dy=".35em" text-anchor="middle">Service models</text><rect class="n" x="14" y="150" width="52" height="30" rx="8"/><text class="t" x="40" y="165" dy=".35em" text-anchor="middle">IaaS</text><rect class="n" x="82" y="150" width="52" height="30" rx="8"/><text class="t" x="108" y="165" dy=".35em" text-anchor="middle">PaaS</text><rect class="n" x="150" y="150" width="52" height="30" rx="8"/><text class="t" x="176" y="165" dy=".35em" text-anchor="middle">SaaS</text><rect class="n" x="315.5" y="86" width="153" height="30" rx="8"/><text class="t" x="392" y="101" dy=".35em" text-anchor="middle">Deployment models</text><rect class="n" x="218" y="150" width="67" height="30" rx="8"/><text class="t" x="251.5" y="165" dy=".35em" text-anchor="middle">Public</text><rect class="n" x="301" y="150" width="75" height="30" rx="8"/><text class="t" x="338.5" y="165" dy=".35em" text-anchor="middle">Private</text><rect class="n" x="392" y="150" width="91" height="30" rx="8"/><text class="t" x="437.5" y="165" dy=".35em" text-anchor="middle">Community</text><rect class="n" x="499" y="150" width="67" height="30" rx="8"/><text class="t" x="532.5" y="165" dy=".35em" text-anchor="middle">Hybrid</text></svg><figcaption style="font-size:.82em;opacity:.72;margin-top:.45rem">Cloud classification</figcaption></figure>

Key points.

  1. The Internet is the transport backbone of the cloud: users reach remote data centres through a browser or app, so the cloud cannot work without it.
  2. Characteristics are on-demand self-service, broad network access, resource pooling, rapid elasticity and measured service.
  3. Cloud infrastructure is the hardware and software that powers the cloud: physical servers, storage, network, a virtualization layer that splits hardware into virtual machines, and a management layer for provisioning and billing. Example: AWS EC2, Microsoft Azure.
  4. IaaS gives virtual machines, storage and networks; the user manages OS and applications (AWS EC2, Google Compute Engine).
  5. PaaS gives a runtime and development tools; the user manages only the application and data (Google App Engine, Heroku).
  6. SaaS gives ready-to-use software through a browser; the provider manages everything (Google Workspace, Office 365).
  7. Public cloud is shared over the Internet and cheap (AWS, Azure); private cloud serves one organisation and is more secure; community cloud is shared by organisations with common needs; hybrid cloud combines public and private.
  8. Pros: lower cost, scalability, anywhere access, automatic updates, disaster recovery. Cons: internet dependency and downtime, security and privacy worries, vendor lock-in, limited control.

Cloud vs traditional computing.

Point Traditional (on-premise) Cloud
Cost Large CapEx up front OpEx, pay per use
Scalability Buy new hardware Elastic, instant
Access Local network Anywhere via Internet
Maintenance Own staff Provider
Setup time Weeks Minutes

Responsibility. IaaS: user runs OS, middleware, app; PaaS: user runs app only; SaaS: user runs nothing.

Answer frame. Cloud definition: open with the definition, link to the Internet, draw the classification tree, then points 2-3, 4-6, 7. Deployment types: one line per type with example. Pros and cons: two short lists of four each. Service models: open with the three, close with the responsibility line.

Asked: [7 marks] (Jun 2022) Write down the pros and cons of cloud computing. Asked: [7 marks] (Nov 2022) Explain different types of clouds. Asked: [7 marks] (Jun 2023) What do you understand by cloud computing? Describe cloud infrastructure in detail. Asked: [7 marks] (Dec 2024) What is cloud computing and how does it differ from traditional computing models? Asked: [7 marks] (Jun 2024) Explain cloud computing and its relationship to the Internet. Asked: [7 marks] (Jun 2025) Discuss the different cloud service delivery models.

Last-minute revision

  • DBMS: software to define, store, retrieve and control shared data with less redundancy.
  • Three levels: external, conceptual, internal.
  • Physical independence: change storage, schema stays; logical independence: change schema, views stay.
  • Data dictionary stores metadata.
  • Primary key: unique and not NULL.
  • DDL: CREATE, ALTER, DROP, TRUNCATE; DML: SELECT, INSERT, UPDATE, DELETE.
  • ACID: Atomicity, Consistency, Isolation, Durability.
  • Cloud: on-demand Internet delivery, pay as you go.
  • IaaS, PaaS, SaaS: EC2, App Engine, Office 365.
  • Deployment: public, private, community, hybrid.

Memory hooks

  • E-C-I: External, Conceptual, Internal, top to bottom.
  • ACID: All-or-nothing, Correct, Isolated, Durable.
  • "I-P-S": the user manages less at each step (Infrastructure, Platform, Software).
  • DDL defines the table, DML fills it.

Coverage checklist

  • Data base Management System: Introduction, File oriented approach and Database approach, Data Models, Architecture of Database System, Data independence, Data dictionary, DBA, Primary Key, Data definition language and Manipulation Languages: covers all DBMS questions (architecture, DDL/DML, data independence, DBA, transaction, data dictionary).
  • Cloud computing: definition, cloud infrastructure, cloud segments or service delivery models (IaaS, PaaS and SaaS), cloud deployment models/ types of cloud (public, private, community and hybrid clouds), Pros and Cons of cloud computing: covers all cloud questions (pros/cons, types, infrastructure, traditional comparison, Internet, service models).
Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in