ICS Computer Science Chapter-3 part-2 BISE
Important Question for ICS Computer Science Part-2
Chapter-03 (Database Design Process)
|
1.
|
Data stored data single site is in
____________ database model. In Centralized database system, all the data is
stored at a single site.
|
|||
|
|
Design
|
Centralized
|
Partitionized
|
Storage
|
|
2.
|
In
ERD model, the relationship between two entities is represented by a:
|
|||
|
|
Diamond Symbol
|
Rectangular
box
|
Oval
symbol
|
Line
|
|
3.
|
A
data model is
|
|||
|
|
A
logical representation of the structure of the database
|
Shown
as an entity-relationship diagram
|
Transformed
into tables and relationship
|
All
|
|
4.
|
An
Index may be created on:
|
|||
|
|
Primary
Key
|
Secondary
Key
|
Foreign
Key
|
All
|
|
5.
|
Which
of the following is used to associate entities with one another?
|
|||
|
|
Entity
|
Attribute
|
Relationship
|
Identifier
|
|
6.
|
A
relationship can be:
|
|||
|
|
One
to One
|
One
to many
|
Many
to many
|
All
|
|
7.
|
In
an E-R diagram, a rectangle represents a (n)
|
|||
|
|
Entity
|
Attribute
|
Relationship
|
None
|
|
8.
|
Which
of the following are basic data distribution strategies?
|
|||
|
|
Centralized
|
Partitioned
|
Replication
|
All
|
|
9.
|
Which
of the following represent the entities?
|
|||
|
|
Teacher
|
Student
|
Principal
|
All
|
|
10.
|
A
technique for physically arranging the records of a file on secondary storage
devices is called:
|
|||
|
|
Physical
pointer
|
File organization
|
Retrieval
program
|
Update
Program
|
|
11.
|
Which
of the following is related to Modality?
|
|||
|
|
Optional
|
Mandatory
|
Unidirectional
|
A and B
|
|
12.
|
Which
of the following is an example of one to one relationship?
|
|||
|
|
Mother-daughter
|
Bike-Record
|
Student-RegNo
|
Client-phone-no
|
|
13.
|
A
relationship between countries and capitals is an example of ___________
relationship.
|
|||
|
|
One
to many
|
One to One
|
Many
to many
|
Many
to one
|
|
14.
|
____________ are the basis of usage paterns
of the database. Data volume and Usage analysis are used to estimate the size
or volume and the usage patterns of the database.
|
|||
|
|
Decision
Tables
|
Normalize Relations
|
Usage Analysis
|
Logical Design
|
Q-2: Write short answers any TEN, each question
carry 2 marks. 2x10=20
i.
Define
maximum cardinality and minimum cardinality.
ii.
Distinguish
between an entity class and an entity instance.
iii.
Define
Database integrity.
iv.
List
major inputs to physical design.
v.
State
the purpose of Database design process.
vi.
Write
the use of ER Diagram.
vii.
What is
the purpose of feasibility study?
viii.
Why is
requirement analysis conducted?
ix.
Define
an Attribute with example.
x.
Define
modality.
Q-3: Write detail answers of the following
questions. 2x8=16
i.
Explain
different components of logical model in detail.
ii.
Briefly
describe basic data distribution strategies.
ICS Part-1 notes for:
FBISE Islamabad ICS Part-2 computer science notes
BISE Lahore ICS Part-2 computer science notes
BISE Multan ICS Part-2 computer science notes
BISE Gujranwala ICS Part-2 computer science notes
BISE Rawalpindi ICS Part-2 computer science notes
BISE Bahawalpur ICS Part-2 computer science notes
BISE Peshawar ICS Part-2 computer science notes
BISE Abbottabad ICS Part-2 computer science notes
BISE Kohat ICS Part-2 computer science notes
BISE Bannu ICS Part-2 computer science notes
BISE Mardan ICS Part-2 computer science notes
BISE Swat ICS Part-2 computer science notes
BISE Malakand ICS Part-2 computer science notes
BISE Hyderabad ICS Part-2 computer science notes
BISE Sukkur ICS Part-2 computer science notes
BIE Karachi ICS Part-2 computer science notes
Copyright all data
www.studyspk.blogspot.com
for more info and sugestion please contact
Studyspk@gmail.com
Model paper 12th class
class 12th model paper free download