2nd Year Computer Chapter 3 Notes

Complete 2nd Year Computer Chapter 3 Notes written by Professor Mr. Tayyab Shahzad. These notes are very helpful in the preparation of 2nd year computer chapter 3 important questions of Computer Science for the students of the intermediate and these are according to the paper patterns of all Punjab boards.

Summary and Contents:
Topics which are discussed in the notes are given below:
  • Important Multiple Choice Questions of 2nd year computer chapter 3 mcqs of 2nd-year Computer Science.
  • Q1: Following involves the area identification and selection:
  • (a) Feasibility study     (b) Feasibility analysis     (c) Initial study     (d) Initial examination
  • Q2: In the following activity, the possible inputs for the database are obtained:
  • (a) Project planning   (b) Requirements analysis   (c) Feasibility study   (d) Data analysis
  • Q3: In the following activity, the cost factors are taken into consideration:
  • (a) Project planning    (b) Requirements analysis    (c) Feasibility study    (d) Data analysis
  • Q4: Following are the tools involved to the data Analysis:
  •  (a) Data flow diagram   (b) Decision tree   (c) Decision table  (d) All of these
  • Q5: The relationship between the entities is represented graphically by using:
  • (a) E - R diagram   (b) Data flow diagram    (c) Flow charts    (d) Decision tables
  • Important 2nd year computer chapter 3 mcqs with answers for Intermediate part-II students.
  • Q6: In an E - R Diagram, a rectangle represents a (n): (a) Entity (b) Attributes (c) Relationship (d) Field
  • Q7: In an E - R Diagram, a diamond represents a (n):  (a) Attributes (b) Relationship (c) Entity (d) Modality
  • Q8: In the ERD model, the relationships between two entities are represented by: 
  • (a) Rectangle        (b) Oval          (c) Square          (d) Diamond
  • Important 2nd year computer chapter 3 important mcqs for Intermediate part-II students.
  • Q9: An entity related to itself in an ERD model refers to relationship:
  • (a) Recursive (b) One to many (c) Many to many (d) One to one
  • Q10: Which one of the following is used to associate entities with each other? 
  •   (a) Attributes        (b) Entities           (c) Relationship        (d) Cardinals / Identifier
  • Q11: Which one is not related to an entity? (a) Person (b) Concept (c) Action (d) Object
  • Q12: Following is / are the ingredient (s) of data modeling: (a) Objects (b) Attributes (c) Relationships (d) All of these
  • Q13: Following is a type of relationship: (a) One to One (b) One to Many (c) Many to many (d) All of these
  • Q14: Following defines the nature of the relationship:  (a) Cardinality (b) Modality (c) Simple (d) Recursion
  • Important 2nd year computer chapter 3 short questions for Intermediate part-II students.
  • Define analysis: Ans: A process of studying the existing system is known as analysis. The analysis also determines what should take place in the new system. It is a very important activity for the development of database system. The person responsible for the requirement analysis is called "Analyst".
  • What is the importance of project planning?
  • Important 2nd year computer chapter 3 important long questions for Intermediate part-II students.
  • What is data modeling?: Ans: The identification of data objects and their relationships to other data objects. Data modelling is often the first step in database design. Designers first create a conceptual model of how data items relate to each other. Data modelling involves a progression from conceptual model to logical model to physical schema.
  • Define cardinality and Define Modality.
  • Important 2nd year computer chapter 3 long questions for Intermediate part-II students.
  • What is an E-R diagram?: Ans: An entity relationship E-R diagram is a specialized graphic that illustrates the interrelationships between entities in a database. ER diagram often use symbols to represent three different types of information. 
  • What is logical database design?
  • What is physical database design?
  • What is meant by centralized database distribution?
  • What is partitioned database distribution?
  • Important 2nd year computer chapter 3 long questions pdf download for Intermediate part-II students.
  • What is replicated database distribution?: Ans: Full copy of database is stored on some other computer. Any change in parent computer is replicated to the others. In this strategy more storage is required. There can be a huge communication cost while replication. Frequent synchronization is also required.

Loading your document...

Download PDF