Important Question for ICS Computer Science Part-2, Important notes for ICS computer Science for all Boards and Federal Board.
Chapter-04(Data Integrity and Normalization)
|
1.
|
Redundancy in table can
create certain ____________ in the partial functional dependency.
|
|||
|
|
Anomalies
|
Possibilities
|
Integrity
|
Views
|
|
2.
|
The attributes in two
different tables having the same name are called ____________ .
|
|||
|
|
Acronym
|
Integrity
|
Homonym
|
Independent
|
|
3.
|
Normalization is the
process of converting complex data structures into ____________ .
|
|||
|
|
Neural
Data Structure
|
Operation
Data Structure
|
Access
Data Structure
|
Stable Data Structures
|
|
4.
|
____________ is
created when two different names are used for the same information.
|
|||
|
|
Expression
|
Synonyms
|
Consistent
|
Mutually
Protected
|
|
5.
|
____________ is the
process of converting complex data structures into simple data structures.
|
|||
|
|
Correctness
|
Filter
|
Fact
|
Normalization
|
|
6.
|
Which of the following
states that no attribute of a primary key should contain null value?
|
|||
|
|
Redundant
Information
|
Transitive
dependency
|
Data
Security
|
Entity Integrity
|
|
7.
|
Two or more attributes having
different names but same meaning are called:
|
|||
|
|
Homonyms
|
Aliases
|
Synonyms
|
Alternae attribute
|
|
8.
|
2NF, which form of dependency is
removed?
|
|||
|
|
Functional
|
Partial
|
Associative
|
Transitive
|
|
9.
|
Which of the following anomalies
result from a transitive dependency?
|
|||
|
|
Insertion
|
Mofificatin
|
Deletion
|
All
|
|
10.
|
A relation that contains minimal
redundency and allows easy use is called:
|
|||
|
|
Clean
|
Simple
|
Complex
|
Well Structured
|
|
11.
|
When all the non key
attributes are fully dependent on primary key then the state is known as
____________ .
|
|||
|
|
Entity
Integrity
|
Fourth
Normal Form
|
Second Normal Form
|
Functional
Dependency
|
|
12.
|
A relation R can be in
____________ if all underlying domains contains atomic values.
|
|||
|
|
Fourth Normal Form
|
First Normal Form
|
Referential
Integrity
|
Consistent
Normal Form
|
|
13.
|
____________ must refer
to the PK in another table or it must be null.
|
|||
|
|
Redundant
Information
|
Simple
Data structure
|
Transitive
dependency
|
Refrential Integrity
|
|
14.
|
Which of the following
states that no attribute of a primary key should contain null value?
|
|||
|
|
Redundant
Information
|
Transitive
dependency
|
Data Security
|
Entity Integrity
|
Q-2: Write short answers any TEN, each question
carry 2 marks. 2x10=20
i.
Write the names of three typical problem in
merging relations.
ii.
Compare normal form and normalization.
iii.
Describe transitive dependency.
iv.
Differentiate between partial dependency and transitive
dependency.
v.
What is partial dependency?
vi.
What are the database anomalies?
vii.
Describe repeating group.
viii.
Define functional dependency.
ix.
Define Normalization.
x.
Define mutual exclusiveness of data.
xi.
Define the term of redundancy.
xii.
What is meant by entity integrity?
xiii.
Define referential integrity.
xiv.
How is entity integrity attained.
Q-3: Write detail answers of the following
questions. 2x8=16
i.
What is
functional dependency? Explain with example.
ii.
Apply
first normal form on this table.
|
Dept_No
|
Dept_Name
|
Emp_no
|
Emp_Name
|
|
20
|
Stiching
|
S01
S02
|
Javid
Bilal
|
|
30
|
Finance
|
S10
S11
|
Ali
Abdal
|
|
10
|
Management
|
S12
S13
|
Khan
Usman
|
|
20
|
IT
|
S09
|
Asif
|
ICS Part-2 notes for Computer Science free download :
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
ICS Computer model paper download
ICS Computer Science important questions