2024 paper

1. Why do we use SQL Analyzer?

English (Deep Explanation):

SQL Analyzer is a powerful database tool used to write, test, execute, debug, and analyze SQL
queries before using them in real applications. When databases become large, queries may take
more time to run or may not give correct results. SQL Analyzer helps database developers and
administrators understand how a query is processed internally by the database engine.

It provides features such as query execution plans, which show how tables are accessed, which
indexes are used, and how much cost is involved in each step. By using SQL Analyzer, we can
identify slow-performing queries, remove unnecessary joins, optimize conditions in the
WHERE clause, and improve overall database performance. It also helps in detecting syntax
errors and logical mistakes in SQL statements. In short, SQL Analyzer is used to ensure that
SQL queries are efficient, fast, and error-free.

Roman Urdu (Deep Explanation):

SQL Analyzer aik bohat important database tool hota hai jo SQL queries likhne, test karne,
execute karne, aur analyze karne ke liye use hota hai. Jab database bohat bara ho jata hai, to
queries slow ho sakti hain ya ghalat result de sakti hain. SQL Analyzer humein yeh samajhne
mein madad karta hai ke database engine query ko andar se kaise process karta hai.

Is tool ke zariye hum execution plan dekh sakte hain jisme bataya jata hai ke kaunsi table pehle
access ho rahi hai, kaunsa index use ho raha hai, aur kitna time lag raha hai. SQL Analyzer ki
madad se hum slow queries ko fast bana sakte hain, extra joins remove kar sakte hain aur
WHERE clause ko optimize kar sakte hain. Yeh syntax aur logical errors find karne mein bhi
help karta hai. Is liye SQL Analyzer ka use queries ko fast, efficient aur error-free banane ke
liye kiya jata hai.

2. Difference between DBMS and RDBMS

English (Deep Explanation):

DBMS (Database Management System) is software that is used to store, organize, and manage
data in a database. In DBMS, data is usually stored in the form of files or simple tables, and
relationships between data are not strictly enforced. Because of this, data redundancy occurs,
meaning the same data may be stored multiple times. DBMS does not always follow rules like
normalization and data integrity constraints.

RDBMS (Relational Database Management System) is a more advanced version of DBMS. It

stores data in multiple related tables, where each table has rows and columns. RDBMS strictly
follows relational rules, such as the use of primary keys to uniquely identify records and
foreign keys to create relationships between tables. RDBMS reduces data redundancy,
maintains data integrity, supports ACID properties, and provides better security and multi-user
access.

Roman Urdu (Deep Explanation):

DBMS aik software system hota hai jo data ko store, organize aur manage karta hai. DBMS
mein data zyada tar files ya simple tables ki form mein hota hai aur tables ke darmiyan proper
relation maintain nahi hota. Is wajah se data repeat ho jata hai jise redundancy kehte hain.
DBMS mein normalization aur integrity rules itne strict nahi hote.

RDBMS, DBMS ka advanced form hota hai jo data ko multiple related tables mein store karta
hai. Har table rows aur columns par mushtamil hoti hai. RDBMS mein primary key aur foreign
key ka use hota hai jis se tables ke darmiyan relation banta hai. Is system mein data redundancy
kam, data integrity strong, aur security behtar hoti hai. Is ke sath multi-user environment bhi
easily handle hota hai.

3. Five popular platforms using MySQL

English (Deep Explanation):

MySQL is one of the most widely used relational database systems because it is open-source,
fast, secure, and scalable. Many large platforms use MySQL to handle millions of users and
huge amounts of data.

1. Facebook – Uses MySQL to store user profiles, posts, messages, and interactions.
2. YouTube – Uses MySQL to manage video metadata, users, and comments.
3. WordPress – Uses MySQL as its backend database to store posts, pages, themes,
plugins, and user data.
4. Twitter (X) – Uses MySQL to manage tweets, user accounts, and real-time data.
5. LinkedIn – Uses MySQL to store professional profiles, connections, and job-related
data.

Roman Urdu (Deep Explanation):

MySQL aik bohat popular relational database hai kyun ke yeh fast, secure aur open-source hai.
Isi wajah se bohat bari companies MySQL ka use karti hain.

1. Facebook – Users ke profiles, posts aur messages store karta hai.

2. YouTube – Videos ka data aur users ki information manage karta hai.
3. WordPress – Blogs, posts, comments aur users ka data MySQL mein store karta hai.
4. Twitter (X) – Tweets aur real-time users ka data handle karta hai.
5. LinkedIn – Professional profiles aur connections ka data manage karta hai.

4. What is meant by Query in MS-Access?

English (Deep Explanation):

In MS-Access, a Query is a database object that allows users to interact with data stored in
tables. A query can be used to retrieve specific records, sort data, filter information,
calculate values, update records, or delete data. Queries help users extract meaningful
information from large databases by applying conditions.

Queries can be created using Query Design View or SQL View. They save time, reduce manual
work, and make data management more efficient. Queries are also used to create reports and
forms in MS-Access.

Roman Urdu (Deep Explanation):

MS-Access mein Query aik database object hoti hai jo tables mein mojood data ke sath kaam
karne ke liye use hoti hai. Query ki madad se hum data ko search, filter, sort, update ya delete
kar sakte hain. Jab database bohat bara ho jaye to query bohat madadgar hoti hai.

Queries Query Design View ya SQL View ki madad se banai jati hain. Queries time bachati
hain aur data ko meaningful form mein show karti hain. Reports aur forms bhi aksar queries ki
madad se banaye jate hain.

5. SELECT command syntax with WHERE

clause
English (Deep Explanation):
The SELECT command is the most important SQL statement used to retrieve data from
database tables. The WHERE clause is used to apply conditions so that only required records
are returned.

Syntax:

SELECT column1, column2, column3

FROM table_name
WHERE condition;

The WHERE clause can include operators like =, >, <, >=, <=, AND, OR, NOT.

Example:

SELECT name, marks

FROM students
WHERE marks >= 60;

This query returns only those students who have passed.

Roman Urdu (Deep Explanation):

SELECT command database se data hasil karne ke liye use hota hai. WHERE clause ka use
condition lagane ke liye hota hai taake sirf required records show hon.

Syntax:

SELECT column1, column2

FROM table_name
WHERE condition;

Example mein sirf woh students show hon ge jin ke marks 60 ya us se zyada hain.

6. Meaning of Backup and Recovery

English (Deep Explanation):

Backup is the process of creating duplicate copies of data and storing them at a secure location
to protect against data loss. Data loss may occur due to hardware failure, virus attacks, accidental
deletion, or natural disasters. Regular backups are essential for businesses and organizations to
ensure continuity of operations.

Recovery is the process of restoring data from backup copies when the original data is lost,
damaged, or corrupted. Backup and recovery together form a critical part of database
management and disaster recovery planning. Without backup and recovery, permanent data loss
can cause serious financial and operational damage.

Roman Urdu (Deep Explanation):

Backup ka matlab hota hai data ki duplicate copy banana aur usay kisi safe jagah par store
karna. Data loss system crash, virus attack, ya ghalti se delete hone ki wajah se ho sakta hai. Is
liye regular backup lena bohat zaroori hota hai.

Recovery ka matlab hota hai backup se data ko wapas restore karna jab original data kharab
ya delete ho jaye. Backup aur recovery database management ka bohat important hissa hain aur
business ko loss se bachate hain.

Long Answers

Q.1
(a) Difference between MS-Access, SQL, and MySQL

English (Long Explanation):

MS-Access is a database management software developed by Microsoft. It is mainly used for

small-scale databases and desktop applications. MS-Access provides a graphical user
interface (GUI) where users can easily create tables, forms, queries, and reports without deep
programming knowledge. It is mostly used by beginners, students, and small offices.

SQL (Structured Query Language) is not a software, but a standard language used to
communicate with databases. SQL is used to create databases, insert data, retrieve data,
update records, and delete records. Almost all database systems like MySQL, Oracle, SQL
Server, and MS-Access use SQL commands.

MySQL is a Relational Database Management System (RDBMS). It uses SQL as its query
language and is widely used for web applications. MySQL is fast, secure, open-source, and can
handle large databases. Websites like Facebook, WordPress, and YouTube use MySQL.

👉 In short:

 MS-Access = Database software

 SQL = Database language
 MySQL = Database system that uses SQL
Roman Urdu (Long Explanation):

MS-Access Microsoft ka banaya hua aik database software hai jo choti level ki databases ke
liye use hota hai. Is mein GUI (graphical interface) hota hai jis se tables, forms, queries aur
reports asaani se ban jati hain. Ye beginners aur small offices ke liye best hota hai.

SQL koi software nahi balkay aik language hai jo database se baat karne ke liye use hoti hai.
SQL ki madad se hum data insert, update, delete aur retrieve karte hain. Har database system
SQL ko support karta hai.

MySQL aik RDBMS hai jo SQL language use karta hai. Ye zyada tar websites aur online
systems mein use hota hai. MySQL fast, secure aur free hai aur bari databases handle kar sakta
hai.

(b) Define any five SQL TEXT conversion functions

English (Long Explanation):

1. UPPER()
Converts text into uppercase letters.
Example: UPPER('sql') → SQL
2. LOWER()
Converts text into lowercase letters.
Example: LOWER('HELLO') → hello
3. LTRIM()
Removes spaces from the left side of a text string.
Example: LTRIM(' Ali')
4. RTRIM()
Removes spaces from the right side of a text string.
Example: RTRIM('Ali ')
5. SUBSTRING()
Extracts part of a text from a given position.
Example: SUBSTRING('Database',1,4) → Data

Roman Urdu:

1. UPPER() – Text ko capital letters mein convert karta hai

2. LOWER() – Text ko small letters mein convert karta hai
3. LTRIM() – Left side ke extra spaces remove karta hai
4. RTRIM() – Right side ke extra spaces remove karta hai
5. SUBSTRING() – Text ka specific hissa nikalta hai
Q.2
(a) What are the Data Types used in MS-Access? Explain any five

English (Long Answer):

In MS-Access, data types define the kind of data that can be stored in a table field. Choosing
the correct data type is very important because it helps in saving memory, improving
performance, and maintaining data accuracy. MS-Access provides different data types to
store text, numbers, dates, and other kinds of information.

Below are five commonly used MS-Access data types:

1. Text (Short Text)

The Text data type is used to store alphabetic characters, numbers, and symbols that are not
used in calculations. It is mostly used for names, addresses, phone numbers, and email addresses.
A Text field can store up to 255 characters.

2. Number

The Number data type is used to store numeric values that are used in calculations, such as age,
marks, quantity, or total items. This data type allows mathematical operations like addition,
subtraction, multiplication, and division.

3. Date/Time

The Date/Time data type is used to store dates and time values such as date of birth, joining
date, or system time. MS-Access allows different date and time formats, making it easy to sort
and filter records based on dates.

4. Currency

The Currency data type is used to store monetary values like salary, price, or account balance. It
provides high accuracy and avoids rounding errors. This data type is mostly used in financial and
accounting applications.

5. Yes/No

The Yes/No data type stores Boolean values, meaning only two possible values: Yes/No or
True/False. It is commonly used for fields like paid/unpaid, active/inactive, or pass/fail.
Roman Urdu (Long Answer):

MS-Access mein data types ka matlab hota hai ke hum field mein kis type ka data store karna
chahte hain. Sahi data type select karna bohat zaroori hota hai kyun ke is se database fast,
accurate aur secure rehta hai.

Neeche MS-Access ke 5 common data types explain kiye gaye hain:

1. Text (Short Text)

Text data type alphabets, numbers aur symbols store karne ke liye use hota hai. Isay names,
addresses aur phone numbers ke liye use kiya jata hai. Text field maximum 255 characters store
kar sakti hai.

2. Number

Number data type numeric values ke liye hota hai jaise age, marks ya quantity. Is data type par
hum mathematical calculations bhi kar sakte hain.

3. Date/Time

Date/Time data type date aur time store karne ke liye use hota hai, jaise date of birth ya joining
date. Is se records ko date ke hisaab se sort aur filter karna asaan hota hai.

4. Currency

Currency data type paison se related values store karta hai jaise salary aur price. Is mein
rounding error nahi hota, is liye accounting systems mein bohat use hota hai.

5. Yes/No

Yes/No data type sirf do values store karta hai: Yes ya No (True ya False). Ye fields jaise
active/inactive ya pass/fail ke liye use hoti hai.

(b) Examples of Database Applications used in Industry

English (Long Answer):

Database applications are widely used in almost every industry to store, manage, and retrieve
large amounts of data efficiently. These applications help organizations automate their work
and improve accuracy.

Some common database applications used in industry are:

 1. Banking Systems – Used to manage customer accounts, transactions, loans, and ATM
records.
2. Hospital Management Systems – Used to store patient records, doctor schedules, test
reports, and billing information.
3. Airline Reservation Systems – Used for flight scheduling, ticket booking, and passenger
records.
4. E-commerce Systems – Used by online shopping websites to manage products, orders,
customers, and payments.
5. Payroll Systems – Used to calculate salaries, taxes, bonuses, and employee attendance.

Roman Urdu (Long Answer):

Aaj ke dor mein database applications har industry mein use hoti hain kyun ke yeh data ko
efficiently manage karti hain.

Industry mein use hone wali kuch database applications yeh hain:

1. Banking System – Customers ke accounts, transactions aur loans ka record rakhta hai.
2. Hospital Management System – Patients, doctors aur reports ka data store karta hai.
3. Airline Reservation System – Flight booking aur passenger record manage karta hai.
4. E-commerce System – Online shopping websites ka data handle karta hai.
5. Payroll System – Employees ki salary aur attendance calculate karta hai.

Q.3
(a) What is Network Database? What are its main features?

English (Long Answer):

A Network Database is a database model in which data is organized using records and sets,
allowing a record to have multiple parent and child records. This model was developed to
overcome the limitations of the hierarchical database model. In a network database, data is
connected in the form of a graph structure, making it suitable for complex relationships.

Network databases are mainly used where many-to-many relationships are required, such as in
telecommunication systems and large organizations.

Main Features of Network Database:

 Supports many-to-many relationships

 Faster data access compared to hierarchical model
  Flexible data structure
 Allows data sharing among multiple users
 Reduces data redundancy

Roman Urdu (Long Answer):

Network Database aik database model hota hai jismein data multiple relationships ke sath
connected hota hai. Is model mein aik record ke kai parents aur kai children ho sakte hain. Ye
model hierarchical database ki limitations ko door karne ke liye banaya gaya tha.

Network database ka structure graph jaisa hota hai, is liye ye complex systems ke liye suitable
hota hai.

Network Database ki Main Features:

 Many-to-many relationships support karta hai

 Data access fast hota hai
 Structure flexible hota hai
 Multiple users data share kar sakte hain
 Data redundancy kam hoti hai

(b) What are the SQL-Server basic operators?

English (Long Answer):

SQL Server operators are symbols or keywords used to perform operations on data in SQL
queries. These operators are essential for filtering data and performing calculations.

Types of SQL Server Operators:

1. Arithmetic Operators

Used for mathematical calculations:

 + Addition
 - Subtraction
 * Multiplication
 / Division

2. Comparison Operators
Used to compare values:

 = Equal
 > Greater than
 < Less than
 >= Greater than or equal to
 <= Less than or equal to
 <> Not equal

3. Logical Operators

Used to combine conditions:

 AND – All conditions must be true

 OR – Any condition must be true
 NOT – Reverses the condition

Roman Urdu (Long Answer):

SQL Server ke basic operators queries mein data par operations perform karne ke liye use
hote hain.

SQL Server Operators ki Types:

1. Arithmetic Operators

Calculation ke liye:

 + jama
 - minus
 * guna
 / taqseem

2. Comparison Operators

Values compare karne ke liye:

 = barabar
 > bara
 < chota
 >= barabar ya bara
 <= barabar ya chota
 <> barabar nahi
3. Logical Operators

Conditions combine karne ke liye:

 AND – dono conditions true hon

 OR – koi aik condition true ho
 NOT – condition ko ulta kar deta hai

2022-23 Paper

1. SELECT command syntax with LIKE clause

English (Long Definition):

The SELECT command with LIKE clause is used to retrieve data from a database table when
we want to search records based on patterns instead of exact values. The LIKE clause is
mostly used with text fields and works with wildcard characters such as % and _.

 % represents zero or more characters

 _ represents a single character

Syntax:

SELECT column1, column2

FROM table_name
WHERE column_name LIKE 'pattern';

Example:

SELECT *
FROM emp
WHERE name LIKE 'A%';

This query displays all records where the name starts with letter “A”.

Roman Urdu (Long Definition):

SELECT command LIKE clause ke sath tab use hota hai jab humein exact value ke bajaye
pattern ke basis par data chahiye hota hai. LIKE clause zyada tar text fields ke sath use hota
hai aur is mein wildcards use hote hain.
  % ka matlab hota hai zero ya zyada characters
 _ ka matlab hota hai sirf aik character

Syntax:

SELECT column_name
FROM table_name
WHERE column_name LIKE 'pattern';

Example mein wo tamam records show hon ge jin ka name “A” se start hota ho.

2. What do you understand by Data Redundancy?

English (Long Definition):

Data Redundancy refers to the unnecessary duplication of data in a database. This occurs when
the same data is stored in multiple places or tables. Data redundancy increases storage
requirements and can cause data inconsistency, meaning different values of the same data
appear in different locations. Redundancy often occurs in non-relational or poorly designed
databases. To reduce redundancy, techniques like normalization are used.

Roman Urdu (Long Definition):

Data Redundancy ka matlab hota hai data ka bar bar repeat hona database ke andar. Jab aik hi
data multiple jagah par store ho jaye to redundancy paida hoti hai. Is se storage waste hoti hai
aur kabhi kabhi data inconsistent ho jata hai. Is problem ko door karne ke liye normalization use
ki jati hai.

3. What type of Database is SQL?

English (Long Definition):

SQL itself is not a database, but it is a standard language used with Relational Databases.
Databases that use SQL are called Relational Database Management Systems (RDBMS). SQL
works on tables consisting of rows and columns and is used to manage relational databases like
MySQL, Oracle, SQL Server, and PostgreSQL.

Roman Urdu (Long Definition):

SQL koi database nahi balkay aik language hai jo Relational Databases ke sath use hoti hai. Jo
databases SQL use karti hain unhein RDBMS kaha jata hai. SQL tables ke zariye data ko
manage karti hai jisme rows aur columns hoti hain.
4. What do you understand about Data Normalization?

English (Long Definition):

Data Normalization is the process of organizing data in a database to reduce redundancy and
improve data integrity. It involves dividing large tables into smaller related tables and
establishing relationships between them. Normalization helps eliminate insertion, update, and
deletion anomalies and improves database efficiency.

Roman Urdu (Long Definition):

Data Normalization ka matlab hota hai database ko properly organize karna taake data repeat
na ho aur database efficient rahe. Is process mein bari tables ko choti related tables mein divide
kiya jata hai. Normalization se data errors aur inconsistency kam hoti hai.

5. Meaning of “Relation’’ and “Attribute’’

English (Long Definition):

In a relational database:

 Relation refers to a table that contains data in rows and columns.

 Attribute refers to a column in a table that describes a property of an entity.

Roman Urdu (Long Definition):

 Relation ka matlab hota hai table jisme data store hota hai.
 Attribute ka matlab hota hai column jo kisi cheez ki property batata hai, jaise name, age,
salary.

6. Five strong features of MySQL

English (Long Definition):

1. Open Source – Free to use and modify

2. High Performance – Fast data processing
3. Scalability – Handles small to large databases
4. Security – Supports user authentication and encryption
5. Cross-Platform Support – Works on Windows, Linux, macOS
Roman Urdu (Long Definition):

1. Open Source – Free aur easily available

2. Fast Performance – Data jaldi process karta hai
3. Scalable – Choti aur bari databases handle karta hai
4. Secure – User security provide karta hai
5. Cross Platform – Har OS par kaam karta hai

7. Different types of Database

English (Long Definition):

1. Hierarchical Database
2. Network Database
3. Relational Database
4. Object-Oriented Database
5. Distributed Database

Roman Urdu (Long Definition):

1. Hierarchical Database – Tree structure

2. Network Database – Multiple relationships
3. Relational Database – Tables ki form mein
4. Object-Oriented Database – Objects par based
5. Distributed Database – Multiple locations par data

8. What do you mean by DBMS?

English (Long Definition):

DBMS (Database Management System) is software that allows users to create, store, retrieve,
update, and manage data efficiently. It provides security, data integrity, and multi-user access.
Examples include MySQL, Oracle, and MS-Access.

Roman Urdu (Long Definition):

DBMS aik software system hota hai jo data ko store, manage aur retrieve karne mein madad
karta hai. DBMS data security, integrity aur multi-user access provide karta hai. Examples mein
MySQL aur MS-Access shamil hain.
Long Answers

Q.1
(a) Define Fields in MS-Access

English (Deep Explanation with Example):

In MS-Access, a Field is the smallest unit of data in a database table, representing a single
piece of information about an entity. Each field has a name and a data type, which determines
what kind of data can be stored, such as text, number, date, or currency.

Fields can also have properties like field size, default value, validation rules, and format. Proper
field design is essential to maintain data accuracy, consistency, and efficient database
management.

Example:
In an Employee table, the fields could be:

 EmpID (Number, Primary Key)

 FirstName (Text, 50 characters)
 LastName (Text, 50 characters)
 DateOfBirth (Date/Time)
 Salary (Currency)

Here, each column (EmpID, FirstName, etc.) is a field that stores specific information about each
employee.

Roman Urdu (Deep Explanation with Example):

MS-Access mein Field aik table ka sab se chota unit hota hai jo kisi entity ka single
information store karta hai. Har field ka aik naam aur data type hota hai, jo decide karta hai ke
field mein kis type ka data store hoga (text, number, date, currency, etc.).

Fields ki properties bhi ho sakti hain jaise field size, default value, validation rules, aur format.
Fields ka sahi design database ko accurate, consistent aur fast banata hai.

Example:
Employee table ke fields:
  EmpID (Number, Primary Key)
 FirstName (Text)
 LastName (Text)
 DateOfBirth (Date/Time)
 Salary (Currency)

Har column ek field hai jo employee ki specific information rakhta hai.

(b) Primary Key, Foreign Key, and Candidate Key

English (Deep Explanation with Example):

Primary Key (PK):

A primary key is a field or a combination of fields that uniquely identifies every record in a
table. It cannot have NULL or duplicate values.

Example:
EmpID in Employee table can be the primary key because each employee has a unique EmpID.

Foreign Key (FK):

A foreign key is a field in one table that refers to the primary key in another table, creating a
relationship between the tables. This ensures referential integrity.

Example:
DeptID in Employee table can be a foreign key referring to DeptID in Department table.

Candidate Key:
A candidate key is any field or combination of fields that can uniquely identify a record. From
all candidate keys, one is chosen as the primary key.

Example:
In Employee table, both EmpID and EmailID could uniquely identify an employee, so both are
candidate keys. One of them (EmpID) is selected as PK.

Roman Urdu (Deep Explanation with Example):

Primary Key:
Primary key wo field hai jo table ke har record ko uniquely identify karti hai. Isme NULL ya
duplicate values nahi hoti.

Example:
Employee table ka EmpID primary key ho sakta hai kyun ke har employee ka unique EmpID hota
hai.
Foreign Key:
Foreign key aik table ki field hai jo dusre table ke primary key ko refer karti hai. Ye tables ke
darmiyan relation create karta hai.

Example:
Employee table ka DeptID foreign key ho sakta hai jo Department table ke DeptID ko refer kare.

Candidate Key:
Candidate key wo field hai jo record ko uniquely identify kar sakti hai. In me se aik ko primary
key banaya jata hai.

Example:
Employee table me EmpID aur EmailID dono uniquely identify kar sakte hain, dono candidate
keys hain. Primary key EmpID select ki jati hai.

Q.2
(a) Seven Major Components of MS-Access

English (Deep Explanation with Examples):

1. Tables: Store raw data in rows and columns.

Example: Employee table with fields like EmpID, Name, Salary.
2. Queries: Retrieve, update, or filter data.
Example: Find employees whose salary > 50000.
3. Forms: Provide user-friendly interface for data entry.
Example: Employee registration form for entering new employee details.
4. Reports: Display and print formatted data for analysis.
Example: Monthly salary report for HR.
5. Macros: Automate repetitive tasks.
Example: Open a specific form automatically when database opens.
6. Modules: Contain VBA (Visual Basic for Applications) code for complex logic.
Example: Calculate bonus for employees automatically.
7. Relationships: Define how tables are linked via keys.
Example: Linking Employee table DeptID to Department table DeptID.

Roman Urdu (Deep Explanation with Examples):

1. Tables: Rows aur columns me data store karte hain.

Example: Employee table me EmpID, Name, Salary.
2. Queries: Data search aur update ke liye.
Example: Employees jinki salary 50000 se zyada ho.
 3. Forms: User-friendly interface for data entry.
Example: Employee registration form.
4. Reports: Data ko format kar ke print/display karna.
Example: Monthly salary report.
5. Macros: Repetitive tasks automate karna.
Example: Database open hote hi form khul jaye.
6. Modules: VBA code store karte hain for complex tasks.
Example: Employee bonus calculate karna automatically.
7. Relationships: Tables ko connect karna.
Example: Employee table ka DeptID Department table ke DeptID se link.

(b) When should Currency Data Type be used?

English (Deep Explanation with Example):

Currency data type is used to store financial or monetary values. It provides high precision
and avoids rounding errors.

Example:

 Employee salaries
 Product prices
 Account balances

It is mostly used in business, accounting, and financial applications to ensure accuracy in

calculations.

Roman Urdu (Deep Explanation with Example):

Currency data type tab use hota hai jab paison ka data store karna ho. Ye rounding errors se
bachata hai aur accurate calculations provide karta hai.

Example:

 Employees ki salary
 Products ki price
 Bank account balance

Q.3
(a) Client-Server Computing

English (Deep Explanation with Diagram):

Client-Server computing is a network architecture where the client requests services and the
server provides services.

 The client is the computer or application that requests data.

 The server is a system that provides resources, processes requests, and returns results.

Example: A web browser is the client, and a web server is the server.

Diagram (Conceptual):

Client → Request → Server

Client ← Response ← Server

Roman Urdu (Deep Explanation with Diagram):

Client-Server computing aik network model hai jahan client request bhejta hai aur server
usay process karke response bhejta hai.

 Client: Computer/application jo data mangta hai.

 Server: Computer jo data provide karta hai aur process karta hai.

Example: Web browser (client) aur web server (server).

Diagram:

Client → Request → Server

Client ← Response ← Server

(b) Relationship between Tables

English (Deep Explanation with Examples):

A relationship in a database defines how data in one table is related to data in another table.
Relationships are established using primary and foreign keys.

Types of Relationships:

1. One-to-One (1:1) – Each record in Table A corresponds to one record in Table B.

Example: Employee ↔ EmployeeDetails (each employee has one details record)
2. One-to-Many (1:M) – Each record in Table A corresponds to many records in Table B.
Example: Department ↔ Employee (one department has many employees)
 3. Many-to-Many (M:N) – Many records in Table A relate to many records in Table B.
Usually implemented with a junction table.
Example: Students ↔ Courses (students can enroll in many courses, courses have many
students)

Roman Urdu (Deep Explanation with Examples):

Tables ke darmiyan relation define karta hai ke ek table ka data dusre table ke data ke sath kaise
linked hai. Ye primary aur foreign keys ke zariye hota hai.

Types of Relationships:

1. One-to-One (1:1) – Table A ka aik record Table B ke aik record se match hota hai.
Example: Employee ↔ EmployeeDetails
2. One-to-Many (1:M) – Table A ka aik record Table B ke kai records se match hota hai.
Example: Department ↔ Employee
3. Many-to-Many (M:N) – Table A ke kai records Table B ke kai records se linked hain.
Junction table use hoti hai.
Example: Students ↔ Courses

Q.4 — SQL Queries with Examples

(a) Fetch EmpId and full name of employees under manager_id = '986'
SELECT EmpId, CONCAT(FirstName, ' ', LastName) AS FullName
FROM Emp
WHERE manager_id = '986';

Explanation:
CONCAT joins first and last names. WHERE filters employees under manager 986.

(b) Count of employees working in project "P1"

SELECT COUNT(*) AS EmployeeCount
FROM Emp
WHERE project = 'P1';

Explanation:
COUNT(*) counts total rows where project = 'P1'.
(c) Find maximum, minimum, and average salary
SELECT MAX(salary) AS MaxSalary,
MIN(salary) AS MinSalary,
AVG(salary) AS AvgSalary
FROM Emp;

Explanation:
MAX(), MIN(), and AVG() calculate maximum, minimum, and average values respectively.

(d) Uppercase employee names and lowercase cities

SELECT UPPER(name) AS NameUpper,
LOWER(city) AS CityLower
FROM Emp;

Explanation:
UPPER() converts name to uppercase, LOWER() converts city to lowercase for formatting.

2024-25
1. What do you understand by Data
Redundancy?
English (Long Answer):

Data Redundancy occurs when the same piece of data is stored multiple times in a database
or in different databases. Redundant data increases storage requirements, creates data
inconsistency, and can lead to errors during updates, deletions, or insertions.

To reduce data redundancy, database normalization is used. Normalization organizes data into
smaller, related tables and eliminates unnecessary duplication.

Example:
If a company stores the address of a customer in both the Orders table and the Customer table,
the same address appears twice. If the customer changes their address, one table might be
updated while the other remains the old address, causing inconsistency.
Roman Urdu (Long Answer):

Data Redundancy tab hoti hai jab ek hi data multiple jagah store ho jaye. Is se storage zyada
lagti hai aur database inconsistent ho sakta hai.

Is problem ko solve karne ke liye normalization use hoti hai, jisme data ko choti aur related
tables mein divide kar diya jata hai.

Example:
Customer ka address Orders aur Customer table dono mein stored hai. Agar customer apna
address change kare aur sirf Orders table update ho, Customer table purana address dikhayega, jo
galat hai.

2. Write down the five (5) strong features of

MySQL
English (Long Answer):

MySQL is one of the most popular Relational Database Management Systems (RDBMS). Its
strong features include:

1. Open Source: Free to use and modify.

2. High Performance: Handles queries quickly even with large datasets.
3. Scalability: Can manage small to very large databases efficiently.
4. Security: Supports authentication, encryption, and access control.
5. Cross-Platform Support: Works on Windows, Linux, macOS, and cloud platforms.

Example:

 Websites like Facebook, WordPress, and YouTube use MySQL for their databases
because of its speed, security, and scalability.

Roman Urdu (Long Answer):

MySQL aik popular RDBMS hai. Iski strong features:

1. Open Source: Free aur modify kiya ja sakta hai.

2. High Performance: Large data sets ke sath fast queries.
3. Scalability: Choti aur bari databases efficiently handle karta hai.
4. Security: Authentication aur encryption support karta hai.
5. Cross-Platform: Windows, Linux, macOS aur cloud par kaam karta hai.
Example: Facebook, YouTube aur WordPress MySQL use karte hain.

3. What is meant by a Query in MS-Access?

English (Long Answer):

A Query in MS-Access is a database object used to retrieve, update, or manipulate data

from one or more tables. Queries allow users to filter, sort, calculate, and join data according to
specific criteria.

Types of Queries:

1. Select Query: Retrieve specific records.

2. Update Query: Modify data in tables.
3. Delete Query: Remove records from tables.
4. Make-Table Query: Create new tables from query results.

Example:

SELECT Name, Salary

FROM Employee
WHERE Salary > 50000;

This query retrieves the names and salaries of employees earning more than 50,000.

Roman Urdu (Long Answer):

MS-Access mein Query aik object hai jo tables se data retrieve, update ya manipulate karta
hai. Queries se hum filter, sort aur join kar sakte hain.

Types:

1. Select Query: Records retrieve karna

2. Update Query: Records modify karna
3. Delete Query: Records delete karna
4. Make-Table Query: New table create karna

Example:

SELECT Name, Salary

FROM Employee
WHERE Salary > 50000;

Ye query un employees ka name aur salary dikhati hai jinki salary 50000 se zyada hai.
4. What are the Data Types in MySQL?
English (Long Answer):

MySQL supports several data types grouped into three main categories:

1. Numeric Data Types: Store numbers.

o INT, FLOAT, DECIMAL, BIGINT
Example: Salary INT
2. String Data Types (Character/Text): Store letters, words, or text.
o CHAR, VARCHAR, TEXT, BLOB
Example: Name VARCHAR(50)
3. Date and Time Data Types: Store date and time values.
o DATE, DATETIME, TIMESTAMP, TIME, YEAR
Example: JoiningDate DATE

These data types help in efficient storage and proper validation of data.

Roman Urdu (Long Answer):

MySQL mein data types teen categories mein divided hain:

1. Numeric Data Types: Numbers store karte hain.

o INT, FLOAT, DECIMAL, BIGINT
Example: Salary INT
2. String Data Types: Text store karte hain.
o CHAR, VARCHAR, TEXT, BLOB
Example: Name VARCHAR(50)
3. Date/Time Data Types: Date aur time store karte hain.
o DATE, DATETIME, TIMESTAMP, TIME, YEAR
Example: JoiningDate DATE

Ye data types data ko efficient aur accurate banate hain.

5. What is a Data Dictionary?

English (Long Answer):

A Data Dictionary is a central repository of information about the database. It contains

metadata, which is data about data, such as:
  Names of tables and fields
 Data types of fields
 Size of fields
 Constraints (Primary Key, Foreign Key)
 Relationships between tables

Example:
If you have a table Employee, the data dictionary may show:

 Table Name: Employee

 Fields: EmpID (INT, PK), Name (VARCHAR), Salary (DECIMAL)

A data dictionary helps DBAs and developers understand the structure of the database.

Roman Urdu (Long Answer):

Data Dictionary aik central repository hai jo database ke bare mein information rakhta hai
(metadata).

Isme hota hai:

 Table aur fields ke names

 Fields ka data type
 Field size
 Constraints (PK, FK)
 Table relationships

Example:
Employee table ka data dictionary:

 Table: Employee
 Fields: EmpID (INT, PK), Name (VARCHAR), Salary (DECIMAL)

Data dictionary DBAs aur developers ke liye database structure samajhne mein madad karta hai.

6. Define five strong features of MS-Access

English (Long Answer):

1. User-Friendly Interface: Forms aur GUI allow easy data entry.

2. Integration: Can integrate with other Microsoft Office applications like Excel and Word.
3. Queries: Powerful query tools to filter, sort, and calculate data.
4. Reports: Easy generation of formatted reports.
 5. Relationships: Can define primary and foreign keys to maintain data integrity.

Example:

 Employee database with forms for entering employees, queries to calculate salaries, and
reports for monthly payroll.

Roman Urdu (Long Answer):

1. User-Friendly Interface: Forms aur GUI se data enter karna asaan.

2. Integration: Excel aur Word ke sath integrate kar sakta hai.
3. Queries: Data filter, sort aur calculate karna possible.
4. Reports: Formatted reports easily generate hoti hain.
5. Relationships: PK aur FK define kar ke data integrity maintain hoti hai.

Example:
Employee database: Form se employee enter karein, queries se salary calculate karein, aur report
generate karein.

Long Answers

Q.1
(a) What are the three (3) Database Models? Explain each

English (Long Answer):

A Database Model defines the logical structure of a database and determines how data is
stored, organized, and accessed. The three main database models are:

1. Hierarchical Database Model:

o Data is organized in a tree-like structure with parent and child relationships.
o Each child has only one parent, but a parent can have multiple children.
o Efficient for one-to-many relationships.
Example: Employee records in a department tree structure.
2. Network Database Model:
o Data is organized in a graph structure using records and sets.
 o Supports many-to-many relationships.
o Flexible and allows faster data access.
Example: Students enrolled in multiple courses and each course having multiple
students.
3. Relational Database Model (RDBMS):
o Data is organized in tables (relations) consisting of rows (records) and columns
(fields).
o Uses primary keys, foreign keys, and SQL for querying.
o Most widely used model today.
Example: MySQL, MS-Access, SQL Server.

Roman Urdu (Long Answer):

Database Model database ka logical structure define karta hai aur data ka organization aur
access decide karta hai. Teen main models:

1. Hierarchical Database:
o Data tree structure mein hota hai (parent-child).
o Har child ka sirf aik parent hota hai.
o One-to-many relationships ke liye efficient.
Example: Department ke employees ka tree structure.
2. Network Database:
o Data graph structure mein hota hai, records aur sets se.
o Many-to-many relationships support karta hai.
o Flexible aur fast access.
Example: Students aur Courses ka relation.
3. Relational Database (RDBMS):
o Data tables (rows aur columns) mein hota hai.
o Primary key aur foreign key use hoti hain aur SQL se query hota hai.
o Most popular model.
Example: MySQL, MS-Access.

(b) Explain Primary Key, Foreign Key, and Candidate Key

English (Long Answer):

1. Primary Key (PK):

o Field or combination of fields that uniquely identifies each record in a table.
o Cannot have NULL or duplicate values.
Example: EmpID in Employee table.
2. Foreign Key (FK):
o Field in one table that refers to primary key in another table.
o Maintains referential integrity and creates relationships.
Example: DeptID in Employee table referring to DeptID in Department table.
 3. Candidate Key:
o Any field or combination that can uniquely identify a record.
o One candidate key is selected as primary key.
Example: EmpID and EmailID both can uniquely identify employee; EmpID
chosen as PK.

Roman Urdu (Long Answer):

1. Primary Key:
o Field jo har record ko uniquely identify karti hai.
o NULL aur duplicate values allowed nahi.
Example: Employee table ka EmpID.
2. Foreign Key:
o Field jo dusre table ke PK ko refer karti hai.
o Tables ke darmiyan relation banata hai.
Example: Employee table ka DeptID Department table ke DeptID se linked.
3. Candidate Key:
o Wo field jo record ko uniquely identify kar sakti hai.
o Aik candidate key ko primary key banaya jata hai.
Example: EmpID aur EmailID dono candidate keys hain, EmpID primary key
banai gayi.

Q.2
(a) Define Comparison Operators with Description in MySQL

English (Long Answer):

Comparison operators are used to compare two values in SQL queries.

Operator Description Example

= Equal to SELECT * FROM emp WHERE age = 30;

<> Not equal to SELECT * FROM emp WHERE city <> 'Karachi';

> Greater than SELECT * FROM emp WHERE salary > 50000;

< Less than SELECT * FROM emp WHERE age < 40;

>= Greater than or equal SELECT * FROM emp WHERE salary >= 30000;

<= Less than or equal SELECT * FROM emp WHERE age <= 50;
Roman Urdu (Long Answer):

Comparison operators do values ko compare karne ke liye use hote hain.

Operator Matlab Example

= Barabar SELECT * FROM emp WHERE age = 30;

<> Barabar nahi SELECT * FROM emp WHERE city <> 'Karachi';

> Bara SELECT * FROM emp WHERE salary > 50000;

< Chota SELECT * FROM emp WHERE age < 40;

>= Bara ya barabar SELECT * FROM emp WHERE salary >= 30000;

<= Chota ya barabar SELECT * FROM emp WHERE age <= 50;

(b) Syntax and Purpose of any Five MySQL Text Functions

English (Long Answer):

1. UPPER() – Converts string to uppercase.

2. SELECT UPPER(name) FROM emp;

3. LOWER() – Converts string to lowercase.

4. SELECT LOWER(city) FROM emp;

5. CONCAT() – Concatenates two or more strings.

6. SELECT CONCAT(first_name, ' ', last_name) AS FullName FROM emp;

7. SUBSTRING() – Extracts part of a string.

8. SELECT SUBSTRING('PAKISTAN', 4, 3); -- IST

9. LENGTH() – Returns length of a string.

10. SELECT LENGTH(name) FROM emp;

Roman Urdu (Long Answer):

1. UPPER() – String ko uppercase karta hai.

2. SELECT UPPER(name) FROM emp;

3. LOWER() – String ko lowercase karta hai.

4. SELECT LOWER(city) FROM emp;

5. CONCAT() – Do ya zyada strings ko jodta hai.

6. SELECT CONCAT(first_name, ' ', last_name) AS FullName FROM emp;
 7. SUBSTRING() – String ka part extract karta hai.
8. SELECT SUBSTRING('PAKISTAN', 4, 3); -- IST

9. LENGTH() – String ka length return karta hai.

10. SELECT LENGTH(name) FROM emp;

Q.3
(a) Importance / Advantages of Database

English (Long Answer):

1. Data Integrity: Ensures accuracy and consistency.

2. Data Security: Access control and encryption.
3. Reduces Redundancy: No duplicate data.
4. Data Sharing: Multiple users can access data simultaneously.
5. Efficient Data Management: Easy to retrieve, update, and delete records.
6. Backup and Recovery: Data can be restored in case of failure.

Example: A company database ensures all employee records are accurate, secure, and up-to-
date.

Roman Urdu (Long Answer):

1. Data Integrity: Data accurate aur consistent rahta hai.

2. Data Security: Access aur encryption ke zariye secure.
3. Reduces Redundancy: Duplicate data nahi hota.
4. Data Sharing: Multiple users ek saath access kar sakte hain.
5. Efficient Data Management: Records easily retrieve aur update hote hain.
6. Backup and Recovery: Data loss ki surat mein restore ho sakta hai.

Example: Company database mein employee records hamesha accurate aur secure rehte hain.

(b) Operations on Table “emp”

(i) Create Table

CREATE TABLE emp (
empId INT PRIMARY KEY,
ename VARCHAR(50),
age INT,
city VARCHAR(50),
salary DECIMAL(10,2),
 designation VARCHAR(50)
);

(ii) Add a Record

INSERT INTO emp (empId, ename, age, city, salary, designation)
VALUES (101, 'Ali', 35, 'Karachi', 50000, 'Developer');

(iii) Modify Table Structure

ALTER TABLE emp ADD COLUMN dept VARCHAR(50);

(iv) Delete Table

DROP TABLE emp;

(v) Save Record

 When a record is added via INSERT, MySQL automatically saves it in the table.

Q.4 — MySQL Queries

(a) Pick middle three characters “IST” from “PAKISTAN”
SELECT SUBSTRING('PAKISTAN',4,3);

(b) Display all records from emp where ename starts with 'A'
SELECT * FROM emp
WHERE ename LIKE 'A%';

(c) Display products with price between 100 and 200

SELECT * FROM products
WHERE price BETWEEN 100 AND 200;

(d) Display ename and salary where age > 30 and city = 'Karachi'
SELECT ename, salary FROM emp
WHERE age > 30 AND city = 'Karachi';

(e) Delete the customer "Ahmed"

DELETE FROM Customers
WHERE cname = 'Ahmed';
(f) Show all records department-wise in ascending order
SELECT * FROM emp
ORDER BY dept ASC;

(g) Delete records from emp where designation = 'Manager'

DELETE FROM emp
WHERE designation = 'Manager';

2023-24 Paper
1. What is a Database and Database Schema?
English (Long Answer):

A Database is a structured collection of data that is stored and managed electronically. It

allows users to store, retrieve, update, and manage data efficiently. A database ensures that
data is organized, consistent, secure, and easily accessible.

A Database Schema is the logical blueprint or structure of the database. It defines how the
data is organized, including tables, fields, data types, relationships, constraints, and keys. The
schema acts as a design template for the database.

Example:
In an Employee Management System, the database may contain tables like Employee,
Department, Salary. The schema defines the structure of these tables, such as the fields in
Employee table (EmpID, Name, Age, DeptID, Salary) and their data types.

Roman Urdu (Long Answer):

Database aik structured data collection hai jo electronically store aur manage hoti hai. Ye
users ko data store, retrieve, update aur manage karne mein help karta hai. Database se data
organized, consistent, secure aur accessible rehta hai.

Database Schema database ka logical design ya blueprint hai. Ye define karta hai ke data kaise
organize hoga, jaise tables, fields, data types, relationships aur constraints. Schema database
ke design ka template hai.

Example:
Employee Management System mein tables: Employee, Department, Salary. Schema define
karta hai ke Employee table ke fields kya hain aur unke data types kya hain.
2. Components of DBMS Environment
English (Long Answer):

A DBMS Environment consists of the following components:

1. Hardware: Computers, storage devices, and network equipment that store and manage
the database.
2. Software: DBMS software (like MySQL, Oracle, MS-Access) that provides tools to
manage data.
3. Database: The actual collection of data organized in tables and relationships.
4. Users: People interacting with the database:
o Database Administrator (DBA): Manages and maintains the database.
o End Users: Access and manipulate data using queries or applications.
5. Procedures/Policies: Rules and guidelines for using the database efficiently and
securely.

Example:
In a bank, the hardware includes servers, the DBMS software could be MySQL, the database
stores customer accounts, the DBA manages it, and end users are bank staff using forms to
access customer information.

Roman Urdu (Long Answer):

DBMS Environment ke components:

1. Hardware: Computers, storage devices aur network equipment.

2. Software: DBMS software jaise MySQL, Oracle, MS-Access.
3. Database: Tables aur relationships mein organized data.
4. Users:
o DBA: Database manage aur maintain karta hai.
o End Users: Queries aur applications ke zariye data use karte hain.
5. Procedures/Policies: Database efficiently aur securely use karne ke rules.

Example:
Bank ka example: Servers hardware, MySQL software, customer accounts database, DBA
manage karta hai, aur staff end users hain.

3. Advantages of DBMS
English (Long Answer):

1. Data Integrity: Ensures accuracy and consistency of data.

2. Data Security: Controlled access to sensitive data.
3. Reduced Redundancy: Avoids duplicate data.
4. Efficient Data Management: Easy to retrieve, update, and delete records.
5. Backup and Recovery: Data can be restored in case of failure.
6. Concurrent Access: Multiple users can access the database simultaneously.
7. Enforcement of Rules: Maintains constraints, relationships, and business rules.

Example:
A hospital database ensures patients’ data is secure, consistent, accessible to authorized users,
and can be restored after system failure.

Roman Urdu (Long Answer):

1. Data Integrity: Data accurate aur consistent rahta hai.

2. Data Security: Sensitive data par control.
3. Reduced Redundancy: Duplicate data avoid hota hai.
4. Efficient Data Management: Records easily retrieve aur update hote hain.
5. Backup and Recovery: Failure par data restore hota hai.
6. Concurrent Access: Multiple users ek sath data access kar sakte hain.
7. Enforcement of Rules: Constraints aur business rules maintain hoti hain.

Example:
Hospital database mein patient records secure, accurate aur accessible hote hain aur system
failure par restore kiye ja sakte hain.

4. What is System Catalog?

English (Long Answer):

A System Catalog (or Data Dictionary) is a repository that stores metadata about the
database. Metadata is data about data. The system catalog contains information like:

 Table names and structures

 Field names, data types, and sizes
 Constraints (Primary Key, Foreign Key)
 Relationships between tables
 Views, indexes, and stored procedures

The system catalog helps DBAs and developers understand the database structure and maintain
it efficiently.
Example:
In an Employee database, the system catalog stores: Employee table fields (EmpID, Name,
Salary) and their data types.

Roman Urdu (Long Answer):

System Catalog aik repository hai jo metadata (data about data) store karti hai.

Isme hota hai:

 Table names aur structures

 Field names, data types aur sizes
 Constraints (PK, FK)
 Table relationships
 Views, indexes, aur stored procedures

DBA aur developers ke liye ye database structure samajhne aur maintain karne mein help karta
hai.

Example:
Employee database ke Employee table ka structure aur fields system catalog mein store hote
hain.

5. What is MySQL?
English (Long Answer):

MySQL is an open-source Relational Database Management System (RDBMS) that uses

SQL (Structured Query Language) to manage and manipulate data.

Key Features:

 Open source and free

 High performance
 Supports multiple users and concurrent access
 Can handle large databases efficiently
 Works on multiple platforms like Windows, Linux, and macOS

Example:
Websites like Facebook, WordPress, and YouTube use MySQL for storing user data, posts, and
media.

Roman Urdu (Long Answer):

MySQL aik open-source RDBMS hai jo SQL language use karta hai data manage karne ke
liye.

Features:

 Free aur open source

 Fast performance
 Multiple users access support
 Large databases efficiently handle karta hai
 Windows, Linux, macOS par kaam karta hai

Example:
Facebook, WordPress aur YouTube MySQL use karte hain data store karne ke liye.

6. SQL Statement: How to Delete Database

Records from a Table?
English (Long Answer):

To delete records from a table in SQL, we use the DELETE statement.

Syntax:

DELETE FROM table_name

WHERE condition;

 table_name = name of the table from which records are to be deleted

 WHERE condition = condition to specify which records should be deleted. Without
WHERE, all records will be deleted.

Example:

DELETE FROM Employees

WHERE Age > 60;

This deletes all employee records where Age is greater than 60.

Example without WHERE:

DELETE FROM Employees;

This deletes all records from Employees table (use with caution).
Roman Urdu (Long Answer):

SQL mein records delete karne ke liye DELETE statement use hoti hai.

Syntax:

DELETE FROM table_name

WHERE condition;

 table_name = jis table se delete karna ho

 WHERE condition = specify karta hai kaun se records delete karne hain. Agar WHERE nahi
hoga to saray records delete ho jayein ge.

Example:

DELETE FROM Employees

WHERE Age > 60;

Ye un employees ko delete karega jinki age 60 se zyada hai.

Example without WHERE:

DELETE FROM Employees;

Ye saray records delete kar dega. Caution ke sath use karna chahiye.

Long Answers
Q.1
(a) Explain Client–Server Architecture through diagram

English (Long Answer):

Client–Server Architecture is a network model where the system is divided into two main
components:

1. Client:
o The client is a user interface that requests services or data from the server.
o It can be a computer, application, or web browser.
2. Server:
 o The server provides resources, processes requests, and returns responses to
clients.
o Can handle multiple clients simultaneously.

Features:

 Centralized data management

 Efficient resource utilization
 Supports multiple users

Diagram:

Client 1 → Request → Server → Response ← Client 1

Client 2 → Request → Server → Response ← Client 2

Example:

 Web browser = Client

 Web server hosting website = Server

Roman Urdu (Long Answer):

Client–Server Architecture aik network model hai jahan system do main components mein
divided hota hai:

1. Client:
oUser interface jo server se request bhejta hai.
oComputer, browser ya application ho sakta hai.
2. Server:
o Server request process karta hai aur response bhejta hai.
o Multiple clients simultaneously serve kar sakta hai.

Features:

 Centralized data management

 Efficient resources
 Multiple users support

Diagram:

Client 1 → Request → Server → Response ← Client 1

Client 2 → Request → Server → Response ← Client 2

Example: Web browser client, Web server server.

(b) Similarities between SQL and MySQL

English (Long Answer):

1. Both SQL and MySQL use Structured Query Language (SQL) for managing
databases.
2. Both allow data retrieval, insertion, deletion, and updates.
3. Both support data types like INT, VARCHAR, DATE.
4. Both can use queries with conditions, joins, and aggregates.
5. Both provide functions for string, numeric, and date operations.

Example:

SELECT * FROM Employee WHERE Salary > 5000;

This query works in both SQL (standard) and MySQL (implementation).

Roman Urdu (Long Answer):

1. SQL aur MySQL dono SQL language use karte hain.

2. Data retrieve, insert, delete aur update karna dono mein possible hai.
3. INT, VARCHAR, DATE jaise data types support karte hain.
4. Queries with joins, conditions aur aggregates possible.
5. String, numeric aur date functions available.

Example:

SELECT * FROM Employee WHERE Salary > 5000;

Ye query SQL aur MySQL dono mein kaam karegi.

Q.2
(a) List out all MySQL Data Types

English (Long Answer):

1. Numeric Data Types:

o INT, TINYINT, SMALLINT, MEDIUMINT, BIGINT, DECIMAL, NUMERIC, FLOAT, DOUBLE
2. String / Character Data Types:
o CHAR(n), VARCHAR(n), TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT, BLOB
3. Date and Time Data Types:
o DATE, DATETIME, TIMESTAMP, TIME, YEAR
Example:

CREATE TABLE Employee (

EmpID INT,
Name VARCHAR(50),
Salary DECIMAL(10,2),
JoiningDate DATE
);

Roman Urdu (Long Answer):

1. Numeric: INT, TINYINT, SMALLINT, BIGINT, DECIMAL, FLOAT, DOUBLE

2. String/Character: CHAR, VARCHAR, TEXT, BLOB
3. Date/Time: DATE, DATETIME, TIMESTAMP, TIME, YEAR

Example: Employee table mein INT, VARCHAR, DECIMAL aur DATE use kiye gaye.

(b) Advantages and Disadvantages of MySQL

English (Long Answer):

Advantages:

1. Open Source and free

2. High performance and speed
3. Scalable for small and large databases
4. Cross-platform support
5. Secure with authentication and encryption

Disadvantages:

1. Limited support for very complex queries compared to Oracle or SQL Server
2. Limited stored procedures and triggers
3. Not fully compliant with some advanced SQL features

Example: Websites like WordPress use MySQL because of its speed and open-source nature,
but for extremely complex enterprise applications, Oracle may be preferred.

Roman Urdu (Long Answer):

Advantages:

1. Free aur open-source

2. Fast aur high performance
3. Choti aur bari databases handle karta hai
 4. Windows, Linux, macOS par kaam karta hai
5. Secure aur authentication provide karta hai

Disadvantages:

1. Complex queries mein limited support

2. Limited stored procedures aur triggers
3. Advanced SQL features ka full support nahi

Example: WordPress MySQL use karta hai speed aur free hone ki wajah se.

Q.3
(a) Short Note on Backup and Recovery Importance

English (Long Answer):

Backup and Recovery is the process of creating copies of database data to prevent loss and
restoring data in case of accidental deletion, corruption, or system failure.

Importance:

1. Protects against hardware failure

2. Protects against accidental data loss
3. Ensures business continuity
4. Maintains historical records

Example: Daily backup of bank transactions ensures that in case of server failure, all customer
transaction data can be restored.

Roman Urdu (Long Answer):

Backup and Recovery data ka copy create karna aur restore karna hota hai accidental
deletion ya corruption ki surat mein.

Importance:

1. Hardware failure se protect

2. Accidental data loss se protect
3. Business continuity ensure karta hai
4. Historical records maintain karta hai

Example: Bank ke transactions daily backup hote hain taake server failure par restore ho sake.
(b) Define Basic Four Network Topology with Diagram

English (Long Answer):

1. Bus Topology:
o All devices share a single communication line.
o Simple and cheap, but one failure can break the network.
Diagram:
2. PC1---PC2---PC3---PC4

3. Star Topology:
o All devices connected to a central hub/switch.
o Hub failure affects all, but easy to maintain.
Diagram:
4. PC1
5. |
6. PC2---Hub---PC3
7. |
8. PC4

9. Ring Topology:
o Devices connected in a circular manner.
o Data travels in one direction.
Diagram:
10. PC1 → PC2 → PC3 → PC4 → PC1

11. Mesh Topology:

o Every device connected to every other device.
o Very reliable but expensive.
Diagram:
12. PC1---PC2
13. | \ |
14. | \ |
15. PC3---PC4

Roman Urdu (Long Answer):

1. Bus Topology: Sab devices aik line share karte hain, sasta, lekin failure se network
down.
2. Star Topology: Sab devices central hub se connected, maintain easy, hub failure se sab
down.
3. Ring Topology: Devices circular connected, data ek direction travel karta.
4. Mesh Topology: Har device sab ke sath connected, reliable lekin mehnga.
Q.4 — SQL Queries (Long Answer)
(a) Maximum, Minimum, and Average Salary
SELECT MAX(salary) AS MaxSalary,
MIN(salary) AS MinSalary,
AVG(salary) AS AvgSalary
FROM Emp;

Explanation:

 MAX() returns highest salary, MIN() lowest, AVG() average.

(b) Employees with Salary Between 5000 to 10000

SELECT * FROM Emp
WHERE salary BETWEEN 5000 AND 10000;

Explanation:

 BETWEEN includes 5000 and 10000.

(c) Count of Permanent Employees with Salary > 5000

SELECT COUNT(*) AS PermanentCount
FROM empSalary
WHERE salary > 5000 AND employment_type = 'Permanent';

Explanation:

 COUNT(*) counts rows matching criteria.

(d) Select Names with 3rd Character “H”

SELECT name FROM emp
WHERE SUBSTRING(name,3,1) = 'H';

Explanation:

 SUBSTRING(name,3,1) checks the 3rd character of the name.

Agar chaho to main is poore Q.1–Q.4 ka PDF-style exam notes bana doon diagrams, tables
aur examples ke sath, jo 1-page mein revision aur viva ke liye ready ho ✍️📘.