mcq_m8 - System Analysis and Design Logical Database Design...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
System Analysis and Design/ Logical Database Design Multiple Choice Questions V. Rajaraman/IISc. Bangalore M8/V1/July 04/ 1 8.1.1 An entity is (a) a collection of items in an application (b) a distinct real world item in an application (c) an inanimate object in an application (d) a data structure 8.1.2 Pick entities from the following: (i) vendor (ii) student (iii) attends (iv) km/hour (a) i, ii, iii (b) i, ii, iv (c) i and ii (d) iii and iv 8.1.3 A relationship is (a) an item in an application (b) a meaningful dependency between entities (c) a collection of related entities (d) related data 8.1.4 Pick the relationship from the following: (a) a classroom (b) teacher (c) attends (d) cost per dozen 8.1.5 Pick the meaningful relationship between entities (a) vendor supplies goods (b) vendor talks with customers (c) vendor complains to vendor (d) vendor asks prices 8.1.6 The entity set is a (a) set of entities (b) collection of different entities (c) collection of related entities (d) collection of similar entities 8.1.7 Pick entity set from the following (a) all vendors supplying to an organization (b) vendors and organizations they supply (c) vendors and transporters (d) a vendor supplying to many organizations 8.1.8 Attributes are (i) properties of relationship (ii) attributed to entities (iii) properties of members of an entity set (a) i (b) i and ii (c) i and iii (d) iii 8.1.9 The attributes of relationship teaches in teacher teaches course should be
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
System Analysis and Design/ Logical Database Design Multiple Choice Questions V. Rajaraman/IISc. Bangalore M8/V1/July 04/ 2 (a) teacher code, teacher name, dept, phone no (b) course no, course name, semester offered, credits (c) teacher code, course no, semester no (d) teacher code, course no, teacher name, dept, phone no 8.1.10 The expansion of E-R diagram is (a) Entity-Relationship diagram (b) Entity-Relative diagram (c) Entity-Relation diagram (d) Entity-Rationalized diagram 8.1.11In an E-R diagram entities are represented by (a) circles (b) rectangles (c) diamond shaped box (d) ellipse 8.1.12 In an E-R diagram relationship is represented by (a) circles (b) rectangles (c) diamond shaped box (d) ellipse 8.1.13 Entities are identified from the word statement of a problem by (a) picking words which are adjectives (b) picking words which are nouns (c) picking words which are verbs (d) picking words which are pronouns 8.1.14 Relationships are identified from the word statement of a problem by (a) picking words which are adjectives (b) picking words which are nouns (c) picking words which are verbs (d) picking words which are pronouns 8.1.15 One entity may be (a) related to only one other entity (b) related to itself (c) related to only two other entities (d) related to many other entities 8.2.1 By relation cardinality we mean (a) number of items in a relationship (b) number of relationships in which an entity can appear (c) number of items in an entity (d) number of entity sets which may be related to a given entity 8.2.2 If an entity appears in only one relationship then it is (a) a 1:1 relationship (b) a 1:N relationship (c) a N:1 relationship (d) a N:M relationship
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 15

mcq_m8 - System Analysis and Design Logical Database Design...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online