DBMS Fundamentals: Architecture, Data Models, and SQL Languages

1. DBMS – Introduction

Data

Data means raw facts and figures.

Example: 101, Vikas, CSE, 1st Year

Database

A database is an organized collection of related data that can be easily accessed, managed, and updated.

DBMS

DBMS (Database Management System) is software used to create, store, retrieve, update, and manage data in a database.

Examples: MySQL, Oracle, PostgreSQL, SQL Server.

Functions of DBMS

  • Data storage
  • Data retrieval
  • Data insertion and updating
  • Data security
  • Backup and recovery
  • Concurrency control
  • Integrity
Read More

Six Boys Stranded: The Survival Story of the Tongan Castaways

Sione (17 years old) Sione is the oldest boy in the group and naturally becomes their main leader. His wise, calm, and protective nature is essential for keeping everyone together. During moments of danger and panic, Sione serves as the voice of reason. He organizes daily chores, makes practical plans, and encourages the group so they never lose hope.. Beyond managing the camp, he constantly checks on the emotional well-being of every boy, acting as the stable anchor that holds their small community

Read More

Schema vs Instance, Data Independence, Degree vs Cardinality, and Database Keys Explained

1. Schema vs Instance — 6 Marks

A schema is the logical structure or design of a database. It describes tables, attributes, relationships and constraints.

Example: Student(Rollno, Name, Branch, Marks)

This structure is the schema.

Instance

An instance is the actual data stored in the database at a particular moment.

Example:

Roll NoNameBranchMarks
101RahulCSE78
102AmitCSE85

This actual data represents an instance.

Difference Between Schema and Instance

SchemaInstance
Structure/design of databaseActual data
Read More

PWD, Architectural Education and Modernism in India: A Complete Study Resource

PWD and the Early Institutionalisation of Architecture in India

The Public Works Department (PWD) developed during the British period to undertake and control major public infrastructure and construction works.

  1. The expansion of the British administration, railways, roads, canals and other infrastructure created a demand for trained technical personnel.

  2. The PWD expanded significantly around 1854–55, becoming an important institution for surveying, planning and construction.

  3. Its major functions included

Read More

Ethos in Early American Writing: Winthrop, Washington, and Madison

Credibility as Persuasion in Early American Writing

In his Rhetoric, Aristotle claimed that “character may almost be called the most effective means of persuasion.” Each of the early American writers knew and utilized this opportunity, but they approached it differently. All of them gained credibility for their speeches and writings, but in different manners. While John Winthrop appealed to the deity, George Washington created credibility with his arguments, and James Madison concealed his identity

Read More

English Exam Strategies: Discourse Links, Signalling Words and Hedging

1. Required Answer Structure

Memorise these phrases:

To define: “X refers to…” / “X means that…”
To exemplify: “For example,…” / “For instance,…”

Mandatory formula: Name the concept + define it in English + give the example (Definition → Explanation → Example).

2. The 5 Features of Academic Language

  • Complexity: Complex grammar and lexical density. (E.g.: union reaction instead of how the unions will react).
  • Formality: No colloquial language or contractions. (E.g.: cannot instead of can’t).
  • Objectivity:
Read More

International Business: Environment, Trade Theories, Globalization and WTO Explained

1. International Business

International Business refers to business activities involving the exchange of goods, services, capital, technology and resources between two or more countries.

Nature / Features

  • International transactions: Business takes place across national borders.
  • Large market: Firms can serve customers in different countries.
  • Different environments: Political, economic, legal and cultural conditions differ.
  • Foreign exchange: Different currencies are involved.
  • Higher risk: Political instability,
Read More

Brat Farrar by Josephine Tey: Plot, Characters and Themes Explained

1. ¿Quién es Brat Farrar? / Who is Brat Farrar?

Brat Farrar is a young English orphan who has had a difficult and lonely life. He is very good with horses. After an accident leaves him with a permanent limp, he returns to England. There he meets Alec Loding, who discovers that Brat looks very much like Patrick Ashby and asks him to pretend to be Patrick.

2. ¿Por qué Brat acepta hacerse pasar por Patrick Ashby? / Why does Brat agree to pretend to be Patrick Ashby?

At first, Brat does not want to

Read More

Brat Farrar Novel Summary: Identity, Lies and Family Secrets

1. Who is Brat Farrar? Who is Brat Farrar?: Brat Farrar is a young man who has grown up without a family. He has travelled a lot and has always had a difficult life. He is especially talented with horses. When he returns to England, he meets Alec Loding, who notices that Brat looks almost exactly like Patrick Ashby.

2. Why does Brat agree to pretend to be Patrick Ashby? Why does Brat agree to pretend to be Patrick Ashby?: Brat accepts because he is attracted to the idea of having a home and people

Read More

Secularism in India: Gandhi, Nehru, Ambedkar and Beyond

Introduction

Secularism in India is different from the strict separation of religion and state associated with some Western models. India is a religiously diverse society, and therefore the Constitution attempts to maintain religious freedom while also allowing the state to intervene when religion conflicts with equality, social reform and fundamental rights.

The Indian debate on secularism can broadly be understood through different perspectives: Gandhian secularism, Nehruvian secular-liberalism,

Read More