12th Class Computer Science Chapter 3 Short Questions with Answers Online Preparation

Question # 1

Which activities are involved in data analysis?

Ans 1: Data analysis is an important analysis aspect while designing a database.It involves the following activities:
1. Data Flow Diagram
2. Decision Table
3. Decision Trees

Question # 2

What is meant by Data modeling?

Ans 1: Data modeling is the process of identifying the data objects and the relationship between them.
Ingredients of Data Modeling:
1. Entities/Object
2. Attributes
3. Relationship
4. Cardinaality
5. Modality

Question # 3

What is the concept of Data Distribution Strategy?

Ans 1: Data Distribution Strategy:Many organizations today have distributed computing networks . For these organizations, a significant problem in physical database design is deciding at which nodes (or sites) in the network to physically locate the data.

Basic data distribution strategies:
a) Centralized b) Partitioned
c) Replicated d) Hybrids

Question # 4

Define Attribute.Give an example.

Ans 1: Attributes defines the objects,describe their characteristics and in some cases,make references to other object i.e attributes for a TEACHER could be: Teacher,Name,Gender,Last degree,Appointment Data,Pay Scale,Nationality,Telephone No.etc.

Question # 5

Differentiate between Cardinality and Modality.

Ans 1: Cardinality : The number of record in a relation is called the cardinality of relation.
a) Whether some occurrence (s) of object -1 are related to some occurrence (s) of object -2
b) It is expressed as one or many e.g.,
c) A husband can have only one wife and
d) A Father can have many children.
Modality : Modality defines whether the participation of an entity in a relationship is mandatory or optional.
a) Optional
...................... Represented
b) Mandatory ................... Represented by 1

Question # 6

Define E- Diagram.

Ans 1: 1) By connecting all the Data Objects along with their Relationship in the above manner, an ERD (Entity Relationship Diagram) is constructed .

2) Data modeling and the entity- Relationship Diagram provide the Analyst or Database administrator with a concise of a Data Processing Application or constructing a Physical Database.

Question # 7

State the purpose of physical database design.

Ans 1: Physical database design is the last stage of the database design process. The major objective of physical database design is to implement the database as a set of stored records, files, indexes, and other data structures that will provide adequate performance and ensure database integrity, security and recoverability.

Question # 8

Name of Any Two Types of Relationships.

Ans 1: There are two types of relationships.
1) One to One
2) One to Many

Question # 9

What is entity in an ERD?

Ans 1: A data is entity or object is anything that is participating in the system.It is always properly identifiable i.e a TEACHER,a STUDENT,an AEROPLANE.

Question # 10

Define term analysis.

Ans 1: A systematic examination and evaluation of data or information by breaking it into its components parts to uncover their interrelationships is called analysis,The following are the types of analysis.
1. Data Analysis
2. Requirements Analysis
3. Project Analysis

Latest Educational News Stories

Pakistan's Largest Database of Colleges and Universities

BS Programs

University Past Papers

University Results

Exam Results 2024

Study Abroad Programs and Opportunities for Pakistani Students

ICS Part 2 Computer Science Chapter 3 Short Questions Test With Answer

Online Short Questions For Chapter 3 "ICS Part 2 Computer Science Chapter 3 Short Questions Preparation "

Computer Science - ICS Part 2 Computer Science Chapter 3 Short Questions Preparation

Which activities are involved in data analysis?

What is meant by Data modeling?

What is the concept of Data Distribution Strategy?

Define Attribute.Give an example.

Differentiate between Cardinality and Modality.

Define E- Diagram.

State the purpose of physical database design.

Name of Any Two Types of Relationships.

What is entity in an ERD?

Define term analysis.

Prepare Complete Set Wise Questions For Chapter 3 "ICS Part 2 Computer Science Chapter 3 Short Questions Preparation "

Set 1

ICS Part 2 Computer Science Chapter 3 Short Questions Preparation - Set 1

Which activities are involved in data analysis?

What is meant by Data modeling?

What is the concept of Data Distribution Strategy?

Define Attribute.Give an example.

Differentiate between Cardinality and Modality.

Define E- Diagram.

State the purpose of physical database design.

Name of Any Two Types of Relationships.

What is entity in an ERD?

Define term analysis.

12th Computer Science Chapter 3 Preparation