DBMS Solved Answers: File Systems, Three-Schema Architecture, Constraints, ER-to-Relational Mapping and Relational Algebra
Worked for 36s
DBMS – Solved Answers
1. File Processing System vs DBMS
| File Processing System | DBMS |
|---|---|
| Data stored in separate files | Data stored in an integrated database |
| High data redundancy | Redundancy is controlled |
| Difficult data sharing | Easy data sharing |
| Program–data dependence | Program–data independence |
| Limited security | Strong security and authorization |
| Difficult backup/recovery | Provides backup and recovery |
| Poor concurrency control | Supports concurrency control |
Limitations of File Processing System
- Data redundancy
Religion, Spirituality & Worldview: Core Concepts Explained
Religion: Core Ideas
Religion is an organized system of beliefs, practices, symbols, and traditions that help people connect to what they see as sacred and find meaning in life.
Religion provides meaning, comfort, community, moral guidance, rituals, and explanations of the sacred.
Spirituality and Worldview
Spirituality is the personal search for meaning, purpose, connection, and transcendence. A worldview is the lens through which a person understands life.
Worldviews are shaped by family, culture,
Read MoreDatabase Schema vs Instance, Data Independence, Keys, Integrity Constraints and Relational Algebra Explained
1. Schema vs Instance
- Schema is the logical structure of a database.
- It defines the design of the database.
- It specifies tables and their attributes.
- It defines relationships between tables.
- It also defines database constraints.
- Schema is created during database design.
- Instance is the actual data stored in the database at a particular time.
- It represents the current state of the database.
- It changes when data is inserted.
- It changes when data is updated or deleted.
- An instance can be different at different
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
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
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 No | Name | Branch | Marks |
|---|---|---|---|
| 101 | Rahul | CSE | 78 |
| 102 | Amit | CSE | 85 |
This actual data represents an instance.
Difference Between Schema and Instance
| Schema | Instance |
|---|---|
| Structure/design of database | Actual data |
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.
The expansion of the British administration, railways, roads, canals and other infrastructure created a demand for trained technical personnel.
The PWD expanded significantly around 1854–55, becoming an important institution for surveying, planning and construction.
Its major functions included
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 MoreEnglish 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:
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,