database

Feypone time is the time it takes from when a tohd or wite recacet is loniod in mhicis den mertit. 4= In the Parti: 1. Response time in the time it thies from when a read of write roquent is inuied to when dats tranafer begine. ( ) 2. In Hienarehical Model Eixct entity has only one children tes can bave acvenl purmt at top of the hicruchy. ( ) Rart 2; Analyre the problems and select the correct reppote to itt A: The following relation is in whleh normal form (ND) B: The followiog relation is in which normal form (NF) C: Select the correct eardinality constralnt between movies and person entities such that a person may rent zero or more movies and a movle may be rent by a person repare an E-R diagram for a neal eluate firm thits lists property for aale: [ 2.5 Roints] he firm has a number of sskin, cifiess os sosengl thatis. Atunbutes of sales office include ficenumber(identiner) and Iocrion 1) 1. When an entity inatmce mity be a meniber of maltiple mubtypes of is doef rot tave 50 be s mamber of a subtype, it is whtich of the following? a. Overtap witi total specialintion b. Overlap with partial specialization c. Disjoint with total specialization 2) A finctional dependency is a relationship between or among a. Entities b. Tables c. Atributes d. Rower 3) If one attribute is determinunt of socond, which in tam is detemingt of thind, then the relasion (wellstructured table) cannot be in 2. 3rd Normal Form b. 2nd Normal Focm c. Ist Normat Form 4) If we do not apply normalization, then it will recult in 2. Insertion anamolies b. Updation anamolies c. Deletion anomalies d. All of the mentionod 5) By normalizing relations or sets of relations, one minimizes a. Database b. Redundancy c. Fields d. Data 6) 2NF relations are those that are in INF with all the attribute types dependent on the key. a. Foreign b. Primary c. Composite 7) is the process of defining a set of subelasses of an entity type. a. Expansion b. Generaliation c. Specialization d. Division 8) Super classes and subclasses are shown as in EIER diagrams a. Rectangles b. lines c. diamond d. ovals 9) Which of the followiog errestis defirss inheritance in BER diagrams? b. When a supertyps inin. c. When a subtype exiciy irlictiti yeines of the supertype attribute 10) When an entity instance must be a meraber of only one subtype, it is which of the following? a. Disjoint with partial specialization b. Disjoint with total specialization c. Overlap with partial specialization d. Overlap with total specialization Feypone time is the time it takes from when a tohd or wite recacet is loniod in mhicis den mertit. 4= In the Parti: 1. Response time in the time it thies from when a read of write roquent is inuied to when dats tranafer begine. ( ) 2. In Hienarehical Model Eixct entity has only one children tes can bave acvenl purmt at top of the hicruchy. ( ) Rart 2; Analyre the problems and select the correct reppote to itt A: The following relation is in whleh normal form (ND) B: The followiog relation is in which normal form (NF) C: Select the correct eardinality constralnt between movies and person entities such that a person may rent zero or more movies and a movle may be rent by a person repare an E-R diagram for a neal eluate firm thits lists property for aale: [ 2.5 Roints] he firm has a number of sskin, cifiess os sosengl thatis. Atunbutes of sales office include ficenumber(identiner) and Iocrion 1) 1. When an entity inatmce mity be a meniber of maltiple mubtypes of is doef rot tave 50 be s mamber of a subtype, it is whtich of the following? a. Overtap witi total specialintion b. Overlap with partial specialization c. Disjoint with total specialization 2) A finctional dependency is a relationship between or among a. Entities b. Tables c. Atributes d. Rower 3) If one attribute is determinunt of socond, which in tam is detemingt of thind, then the relasion (wellstructured table) cannot be in 2. 3rd Normal Form b. 2nd Normal Focm c. Ist Normat Form 4) If we do not apply normalization, then it will recult in 2. Insertion anamolies b. Updation anamolies c. Deletion anomalies d. All of the mentionod 5) By normalizing relations or sets of relations, one minimizes a. Database b. Redundancy c. Fields d. Data 6) 2NF relations are those that are in INF with all the attribute types dependent on the key. a. Foreign b. Primary c. Composite 7) is the process of defining a set of subelasses of an entity type. a. Expansion b. Generaliation c. Specialization d. Division 8) Super classes and subclasses are shown as in EIER diagrams a. Rectangles b. lines c. diamond d. ovals 9) Which of the followiog errestis defirss inheritance in BER diagrams? b. When a supertyps inin. c. When a subtype exiciy irlictiti yeines of the supertype attribute 10) When an entity instance must be a meraber of only one subtype, it is which of the following? a. Disjoint with partial specialization b. Disjoint with total specialization c. Overlap with partial specialization d. Overlap with total specialization