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

Question # 1

Define Entity Integrity.

Ans 1: Entity Integrity is a constraint on primary values that states that no attribute of a primary key should contain nulls.

Question # 2

What is Normalization?

Ans 1: Normalization:Normalization is the process of converting complex data structures into simple and stable data structures. It is based on the analysis of functional dependence . In other words, Normalization is a technique for reviewing the entity/ attributes lists to that attributes are stored " where they belongs ".it is base for a relational data base system .There are three Forms of Normalization:a) First Normal Formb) Second Normal Formc) Third Normal Form

Question # 3

Write types of Anomalies?

Ans 1: Database Anomalies: Anomalies are problems that can occur in poorly planned, un-normalized database where all the data is stored in one table (a flat -file database)Types of Anomalies:a) Insertion Anomalyb) Deletion Anomalyc) Modification Anomaly

Question # 4

Define Insertion Anomaly.

Ans 1: An Insert Anomaly occurs when certain attributes cannot be inserted into the database without the presence of other attributes. For Example this is the converse of delete anomaly.we can't add a new course unless we have at least one student enrolled on the course.

Question # 5

Define 3rd normal form .

Ans 1: A relation is in third normal form (3 NF) if it is in 2 NF and no transitive dependencies exist.A more precise definition for 3 NF is : "A non-key attribute must not depend on any other non-key attributes " or if a non-key attributes value can be obtained simply by Knowing the value of another non-key attribute, the relation is not in 3 NF.

Question # 6

How is Entity Integrity attained?

Ans 1: The entity integrity can be attained by specifying primary key in a relation. When a primary key constraint is specified on a relation, the DBMS automatically applies the entity integrity on the attribute that is used as primary key .

Question # 7

Define Synonym?

Ans 1: A synonyms is created when two different names are used from the same information (Attributes) . If an attributes resides in more than one entity , make sure that all entities use the same attribute name.

Question # 8

Define Mutual Exclusive of data.

Ans 1: Mutually exclusive data exist when attributes occur whose values can be expressed as "Yes/no" indicators , cannot all be true for any single entity.

Question # 9

What is meant by referential integrity?

Ans 1: Referential Integrity is a constraint on foreign key values that states that if a foreign key exist in a relation than either the foreign key value must match the primary key value of some tuple in its home relation or the foreign key value must be completed null.

Question # 10

Define Transitive Dependency .

Ans 1: Transitive Dependency is a functional dependency in a relation between two (or more) non-key attributes.It is also defined as "It states that in a relation R, if an attribute B is functionally dependent on an attribute A,and the attribute C is functionally dependent on the attribute B This implies that the attributes C is functionally dependent on the attribute A.

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 4 Short Questions Test With Answer

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

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

Define Entity Integrity.

What is Normalization?

Write types of Anomalies?

Define Insertion Anomaly.

Define 3rd normal form .

How is Entity Integrity attained?

Define Synonym?

Define Mutual Exclusive of data.

What is meant by referential integrity?

Define Transitive Dependency .

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

Set 1

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

Define Entity Integrity.

What is Normalization?

Write types of Anomalies?

Define Insertion Anomaly.

Define 3rd normal form .

How is Entity Integrity attained?

Define Synonym?

Define Mutual Exclusive of data.

What is meant by referential integrity?

Define Transitive Dependency .

12th Computer Science Chapter 4 Preparation