You must sign in Login/Signup

New student? Register here

An important facility for 12th class students preparing for short questions computer science 12th class chapter 3 of BISE. Get hundreds of questions to prepare and get better marks in 12th computer science
Generic placeholder image

0

Our database contains a total of 0 questions for computer science Short Questions. You’ll prepare using this huge databank.

Question: 1
Which activities are involved in data analysis?
Answer: 1
1-16
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
Define Cardinality.
Answer: 2
2-16
The number of record in a relation is called the cardinality of relation.
1. Whether some occurrence (s) of object -1 are related to some occurrence (s) of object -2
2. It is expressed as one or many e.g.
a) A husband can have only one wife and
b) A Father can have many children .
3. The relationship can be
a) One to One b) One to many
c) Many to many d) Recursive e) None

Question: 3
Write the purpose of feasibility study.
Answer: 3
3-16
The purpose of feasibility study is called preliminary investigation of the required database,It involves the area of identification and selection i.e which area or aspect is to be selected to start with.After the project is selected,it is allocated a specific fund and a proper planning is chalked out of its practical implementation.
Question: 4
What is entity in an ERD?
Answer: 4
4-16
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: 5
What is meant by Data modeling?
Answer: 5
5-16
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: 6
Differentiate between Cardinality and Modality.
Answer: 6
6-16
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: 7
Define term analysis.
Answer: 7
7-16
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
Question: 8
Define Relationship.
Answer: 8
8-16
The relationship indicates how the entities.objects are connected or related each other.
  • All the relationship defines the relevant connection between both objects.
  • All the relationship are bi-directional.
Question: 9
Define Attribute.Give an example.
Answer: 9
9-16
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: 10
What is the importance of Project Planning?
Answer: 10
10-16
In project planning a proper schedule is laid down to accomplish the activities of a project.All the cost factors are taken into consideration i.e the salaries of team members,their logistics involved,other expenses such as marriage gifts,insurance etc.
Question: 11
What is difference between Relation and Relationship.
Answer: 11
11-16
Relation:A two dimensional array or table of data containing descriptive information about an entity.The entity must have a unique identifier,which is composed of a combination of one or more attributes and each attributes must have one and only one value.
Question: 12
Name of Any Two Types of Relationships.
Answer: 12
12-16
There are two types of relationships.
1) One to One
2) One to Many
Question: 13
What is the concept of Data Distribution Strategy?
Answer: 13
13-16
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: 14
Define E- Diagram.
Answer: 14
14-16
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: 15
State the Purpose of database design process.
Answer: 15
15-16
The major objective of database design process is to map the conceptual data model to an implementation model that is acceptable to all users throughout the organizations . In today's is complete and up-to-date and they expect to be able to access this information quickly and easily .
Question: 16
State the purpose of physical database design.
Answer: 16
16-16
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.