Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to represent M, N, R1 and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to represent M, N, R1 and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3
by

1 Answer

Answer :

Answer: 4
by

Related questions

Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any attributes of their own. How many minimum number of tables are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Description : Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any ... are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Last Answer : (B) 3 

Consider the following ER diagram: Image The minimum number of tables required to represent M, N, P, R1, R2 is (A) 2 (B) 3 (C) 4 (D) 5

Description : Consider the following ER diagram:  The minimum number of tables required to represent M, N, P, R1, R2 is (A) 2 (B) 3 (C) 4 (D) 5

Last Answer : (A) 2 

Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows: (1) pk(R2)→pk(R1) (2) pk(R1)→pk(R2) (3) pk(R2)→R1∩R2 (4) pk(R1)→R1∩R2

Description : Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows: (1) pk(R2)→pk(R1) (2) pk(R1)→pk(R2) (3) pk(R2)→R1∩R2 (4) pk(R1)→R1∩R2

Last Answer : Answer: 2

In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Last Answer : (C) Tables

In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Description : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Last Answer : (A) Number of tuples

_____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference (C) Intersection (D) Product

Description : _____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference (C) Intersection (D) Product

Last Answer : A) Cartesian product

Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity. (C) A weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included. (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Description : Which of the following statements is FALSE about weak entity set ? (A) Weak entities can be deleted automatically when their strong entity is deleted. (B) Weak entity set avoids the data ... weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Last Answer : (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Which of the following statements is TRUE? D1: The decomposition of the schema R(A,B,C) into R1(A,B) and R2(A,C) is always lossless. D2: The decomposition of the schema R(A,B,C,D,E) having AD→B, C→DE, B→AE, AE→C into R1(A,B,D) and R2(A,C,D,E) is lossless. (A) Both D1 and D2 (B) Neither D1 and D2 (C) Only D1 (D) Only D2

Description : Which of the following statements is TRUE? D1: The decomposition of the schema R(A,B,C) into R1(A,B) and R2(A,C) is always lossless. D2: The decomposition of the schema R(A,B,C,D,E) having AD→B, C→DE, B→AE, AE→C ... ,D,E) is lossless. (A) Both D1 and D2 (B) Neither D1 and D2 (C) Only D1 (D) Only D2

Last Answer : (D) Only D2

The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Description : The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Last Answer : C) Relations

The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Description : The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Last Answer : (C) (a) and (c) happens 

Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless join. (2) Dependency preserving and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join.

Description : Consider a schema R(MNPQ) and functional dependencies M→N, P→Q. Then the decomposition of R into R1(MN) and R2(PQ) is ............. (1) Dependency preserving but not lossless ... and lossless join (3) Lossless join but not dependency preserving (4) Neither dependency preserving nor lossless join. 

Last Answer : Answer: 1

Let R1 and R2 be the remainders when the polynomials x^3 + 2x^2 – 5ax – 7 and x^2 + ax^2 – 12x + 6 are divided by (x + 1) and (x – 2) respectively. -Maths 9th

Description : Let R1 and R2 be the remainders when the polynomials x^3 + 2x^2 – 5ax – 7 and x^2 + ax^2 – 12x + 6 are divided by (x + 1) and (x – 2) respectively. -Maths 9th

Last Answer : answer:

In RDBMS, Data is presented as a collection of ............ A) Table B) Attributes C) Relations D) Entities

Description : In RDBMS, Data is presented as a collection of ............ A) Table B) Attributes C) Relations D) Entities

Last Answer : C) Relations

A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity. A) Weak entity B) Strong entity C) Non attributes entity D) Dependent entity

Description : A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity. A) Weak entity B) Strong entity C) Non attributes entity D) Dependent entity

Last Answer : A) Weak entity

ey to represent relationship between tables is called (A) Primary key (B) Secondary Key (C) Foreign Key (D) None of these

Description : ey to represent relationship between tables is called (A) Primary key (B) Secondary Key (C) Foreign Key (D) None of these

Last Answer : (C) Foreign Key

Consider following schedules involving two transactions: S1: r1(X); r1(Y); r2(X); r2(Y); w2(Y); w1(X) S2: r1(X); r2(X); r2(Y); w2(Y); r1(Y); w1(X) Which of the following statement is true? (1) Both S1 and S2 are conflict serializable. (2) S1 is conflict serializable and S2 is not conflict serializable. (3) S1 is not conflict serializable and S2 is conflict serializable. (4) Both S1 and S2 are not conflict serializable.

Description : Consider following schedules involving two transactions: S1: r1(X); r1(Y); r2(X); r2(Y); w2(Y); w1(X) S2: r1(X); r2(X); r2(Y); w2(Y); r1(Y); w1(X) Which of the following ... . (3) S1 is not conflict serializable and S2 is conflict serializable. (4) Both S1 and S2 are not conflict serializable.

Last Answer : S1 is not conflict serializable and S2 is conflict serializable.

Suppose that R1 and R2 are reflexive relations on a set A. Which of the following statements is correct? (A) R1∩R2 is reflexive and R1UR2 is irreflexive. (B) R1∩R2 is irreflexive and R1UR2 is reflexive. (C) Both R1∩R2 and R1UR2 are reflexive. (D) Both R1∩R2 and R1UR2 are irreflexive.

Description : Suppose that R1 and R2 are reflexive relations on a set A. Which of the following statements is correct? (A) R1∩R2 is reflexive and R1UR2 is irreflexive. (B) R1∩R2 is irreflexive and R1UR2 is reflexive. (C) Both R1∩R2 and R1UR2 are reflexive. (D) Both R1∩R2 and R1UR2 are irreflexive.

Last Answer : (C) Both R1∩R2 and R1UR2 are reflexive.

What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram ? (A) Generalization (B) Aggregation (C) Specialization (D) Adding suitable attributes

Description : What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram ? (A) Generalization (B) Aggregation (C) Specialization (D) Adding suitable attributes

Last Answer : (D) Adding suitable attributes

An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not captured in the ER diagram. (A) I, II, III & IV (B) I&IV (C) I, II & IV (D) I & III

Description : An ER Model includes I. An ER diagram portraying entity types. II. Attributes for each entity type III. Relationships among entity types. IV. Semantic integrity constraints that reflects the business rules about data not ... ; IV (B) I&IV (C) I, II & IV (D) I & III

Last Answer : (A) I, II, III & IV

The main task carried out in the …………… is to remove repeating attributes to separate tables. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Fourth Normal Form

Description : The main task carried out in the …………… is to remove repeating attributes to separate tables. A) First Normal Form B) Second Normal Form C) Third Normal Form D) Fourth Normal Form

Last Answer : D) Fourth Normal Form

The electrical diagram shown in the illustration shows _____________. EL-0021 A. 'R1', 'R2', and 'R3' are connected is series B. 'R1', 'R2', and 'R3' are connected in parallel C. the voltages measured across 'R1', 'R2' and 'R3' will be different if 'R1', 'R2' and 'R3' have different values D. the total resistance equals R1 + R2 + R3

Description : The electrical diagram shown in the illustration shows _____________. EL-0021 A. 'R1', 'R2', and 'R3' are connected is series B. 'R1', 'R2', and 'R3' are connected in parallel C. the voltages measured across ... if 'R1', 'R2' and 'R3' have different values D. the total resistance equals R1 + R2 + R3

Last Answer : Answer: B

What is a relationship called when it is maintained between two entities? (A) Unary (B) Binary (C) Ternary (D) Quaternary

Description : What is a relationship called when it is maintained between two entities? (A) Unary (B) Binary (C) Ternary (D) Quaternary

Last Answer : (B) Binary

How are relationship between tables expressed in a relational database?

Description : How are relationship between tables expressed in a relational database?

Last Answer : Tables are the basic building blocks of a relationaldatabase.

Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Description : Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Last Answer : 2) It consists of separate tables or related data

As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total power consumed by R1? EL-0036 A. 3.6 watts B. 72 watts C. 7.2 watts D. 36 watts

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total power consumed by R1? EL-0036 A. 3.6 watts B. 72 watts C. 7.2 watts D. 36 watts

Last Answer : Answer: A

As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total power consumed by the circuit? EL-0036 A. 3.6 watts B. 72 watts C. 7.2 watts D. 36 watts

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total power consumed by the circuit? EL-0036 A. 3.6 watts B. 72 watts C. 7.2 watts D. 36 watts

Last Answer : Answer: C

In the illustration, the voltage applied to the circut is 12 VDC, the resistance for R1 is 10 ohms, and R2 is 10 ohms. What is the power consumed in 'R1' of the circuit shown in the illustration? EL-0036 A. 0.6 watts B. 3.6 watts C. 7.2 watts D. 120 watts

Description : In the illustration, the voltage applied to the circut is 12 VDC, the resistance for R1 is 10 ohms, and R2 is 10 ohms. What is the power consumed in 'R1' of the circuit shown in the illustration? EL-0036 A. 0.6 watts B. 3.6 watts C. 7.2 watts D. 120 watts

Last Answer : Answer: B

weight of water, the hydraulic mean depth of the sewer and the bed slope w is the unit of the sewer, then the tractive force exerted by flowing water, is A. w r S S B. w r1/2 C. w r S D. w r2/3

Description : weight of water, the hydraulic mean depth of the sewer and the bed slope w is the unit of the sewer, then the tractive force exerted by flowing water, is A. w r S S B. w r1/2 C. w r S D. w r2/3

Last Answer : ANS: A

Which of the following statements is correct for the illustrated circuit? EL-0020 A. 'R1', 'R2', and 'R3' are connected in series. B. 'R1', 'R2', and 'R3' are connected in parallel. C. The voltages measured across 'R1', 'R2', and 'R3' are equal. D. The total resistance equals 1/R1 + 1/R2 + 1/R

Description : Which of the following statements is correct for the illustrated circuit? EL-0020 A. 'R1', 'R2', and 'R3' are connected in series. B. 'R1', 'R2', and 'R3' are connected in parallel. C. The voltages measured across 'R1', 'R2', and 'R3' are equal. D. The total resistance equals 1/R1 + 1/R2 + 1/R

Last Answer : Answer: A

A series circuit consisting of three resistors has a current of 3 amps. If R1 = 20 ohms, R2= 60 ohms, and R 3 = 80 ohms, what is the (a) total resistance and (b) source voltage of the circuit?

Description : A series circuit consisting of three resistors has a current of 3 amps. If R1 = 20 ohms, R2= 60 ohms, and R 3 = 80 ohms, what is the (a) total resistance and (b) source voltage of the circuit?

Last Answer : (a) 160 ohms. (b) 480 ohms

A top-to-bottom relationship among the items in a database is established by a A) Hierarchical schema B) Network schema C) Relational Schema D) All of the above

Description : A top-to-bottom relationship among the items in a database is established by a A) Hierarchical schema B) Network schema C) Relational Schema D) All of the above

Last Answer : A) Hierarchical schema

If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn

Description : If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn

Last Answer : (B) D1x D2x… xDn

In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ‘’ (the empty string) for string columns. (C) To leave columns in a tuple marked as “unknown” when the actual value is unknown. (D) To fill a column in a tuple when that column does not really “exist” for that particular tuple.

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) eliminating number of anomalies that could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.

Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced. 

Last Answer : reducing the number of joins required to satisfy a query.

Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to the column B in table R. One can determine that: (A) I, III and IV are the same query. (B) II, III and IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Last Answer : (D) I, III and III are the same query.

Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R diagram: Image If different symbols stand for different values (e.g., t1 is definitely not equal to t2), then which of the above could not be the relationship set for the E-R diagram ? (A) I only (B) I and II only (C) II only (D) I, II and III

Description : Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R diagram: If different symbols stand for different values (e.g., t1 is definitely not equal to t2 ... diagram ? (A) I only (B) I and II only (C) II only (D) I, II and III

Last Answer : (A) I only

Which agent enables the deliberation about the computational entities and actions? a) Hybrid b) Reflective c) Relational d) None of the mentioned

Description : Which agent enables the deliberation about the computational entities and actions? a) Hybrid b) Reflective c) Relational d) None of the mentioned

Last Answer : b) Reflective

Let R be the rectangular window against which the lines are to be clipped using 2D Sutherland-Cohen line clipping algorithm. The rectangular window has lower left-hand corner at (-5,1) and upper righthand corner at (3,7). Consider the following three lines for clipping with the given end point co-ordinates: Line AB: A(-6,2) and B(-1,8) Line CD: C(-1,5) and D(4,8) Line EF: E(-2,3) and F(1,2) Which of the following line(s) is/are candidate for clipping? (A) AB (B) CD (C) EF (D) AB and CD

Description : Let R be the rectangular window against which the lines are to be clipped using 2D Sutherland-Cohen line clipping algorithm. The rectangular window has lower left-hand corner at (-5,1) and upper righthand corner at (3,7). ... s) is/are candidate for clipping? (A) AB (B) CD (C) EF (D) AB and CD

Last Answer : (D) AB and CD

A supply of 24 V DC is applied across a circuit which consist of three resistors connected in parallel R1= 1.2KΩ, R2= 560 Ω, R3= 2.1Ω and a fourth resistor of 7.8 Ω connected in series with the parallel group. Determine the current, voltage and power across each resistor

Last Answer : Req= (1/1200 +1/560 + 1/2.1)^-1        = 2.1 ohms RT= 2.1 + 7.8      = 9.9 ohms IT = V/R = 24/9.9                = 2.4 A Veq= R I =  2.1 2 ... 7.8         = 12.096 w                 = 44.928 w _________________________________________ By: Ellis-Junior Kamatjipose [email protected]

Which one of the following set of attributes should not be encompassed by effective software metrics ? (A) Simple and computable (B) Consistent and objective (C) Consistent in the use of units and dimensions (D) Programming language dependent

Description : Which one of the following set of attributes should not be encompassed by effective software metrics ? (A) Simple and computable (B) Consistent and objective (C) Consistent in the use of units and dimensions (D) Programming language dependent

Last Answer : (D) Programming language dependent

A series circuit consists of two resistors in series. R1 = 25 ohms and R2 = 30 ohms. The circuit current is 6 amps. What is the (a) source voltage, (b) voltage dropped by each resistor, (c) total power, and (d) power used by each resistor?

Description : A series circuit consists of two resistors in series. R1 = 25 ohms and R2 = 30 ohms. The circuit current is 6 amps. What is the (a) source voltage, (b) voltage dropped by each resistor, (c) total power, and (d) power used by each resistor?

Last Answer : (a) 330 volts. (b) E1 = 150 volts. E2 = 180 volts. (c) 1.98 kilowatts. (d) P1 = 900 watts. P2 = 1.08 kilowatts component but in a parallel circuit total current divides among the available paths.

What is the total current of the illustrated circuit if the battery is 12 VDC and the resistance of R1 is 2 ohms, R2 is 3 ohms and R3 is 6 ohms? EL-0021 A. 2 amps B. 4 amps C. 6 amps D. 12 amps

Description : What is the total current of the illustrated circuit if the battery is 12 VDC and the resistance of R1 is 2 ohms, R2 is 3 ohms and R3 is 6 ohms? EL-0021 A. 2 amps B. 4 amps C. 6 amps D. 12 amps

Last Answer : Answer: D

As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 24 kohms, and R2 is 3610 ohms what is the current flowing through R1? EL-0036 A. .434 milliamps B. .005 amp C. 6.00 amps D. 2.4 milliamps

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 24 kohms, and R2 is 3610 ohms what is the current flowing through R1? EL-0036 A. .434 milliamps B. .005 amp C. 6.00 amps D. 2.4 milliamps

Last Answer : Answer: A

As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the current flowing through R1? EL-0036 A. 0.6 amp B. 0.833 amp C. 1.2 amps D. 2.4 amps

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the current flowing through R1? EL-0036 A. 0.6 amp B. 0.833 amp C. 1.2 amps D. 2.4 amps

Last Answer : Answer: A

As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total current in the circuit? EL-0036 A. 0.6 amp B. 0.833 amp C. 1.2 amps D. 2.4 amps

Description : As shown in the illustration if the applied voltage is 12 VDC, the resistance of R1 is 10 ohms, and R2 is 10 ohms what is the total current in the circuit? EL-0036 A. 0.6 amp B. 0.833 amp C. 1.2 amps D. 2.4 amps

Last Answer : Answer: A