Bissoy.com
Doctors Medicines MCQs Q&A

In an Entity-Relationship (ER) model, suppose ? is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in ? and that the cardinality of E1 is greater than the cardinality of E2. Which one of the following is true about ??

In an Entity-Relationship (ER) model, suppose ? is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in ? and that the cardinality of E1 is greater than the cardinality of E2. Which one of the following is true about ?? Correct Answer Every entity in E1 is associated with exactly one entity in E2.

As the number of entries in E1 is greater than the number of entries in E2

As participation is total,

R is an onto function from E1 to E2

As participation of both the entity sets is total and number of entries in E1 is greater than E2, R is an onto function.

: :  Partial/Optional participation

: : Total/Mandatory participation or Existence dependency

Related Questions

Among 170 students of a class, 155 students participate in one or more of the three classes: Guitar, Drum and Violin. Total 21 students participate on any and only two of three classes. 54 students participate in Drum class only, whereas 43 students participate in Violin class only. 5 students participate in all the three classes. How many students participate in Guitar class only?
In a class of 75 students, every student participates in at least one of the three events – music, drama and poetry. 12 students participate in all 3 events. 21 student participate in any two events. If 14 students participate in music only and 15 students participate in drama only, then how many students participate in poetry only? 
User level threads are threads that are visible to the programmer and are unknown to the kernel. The operating system kernel supports and manages kernel level threads. Three different types of models relate user and kernel level threads. Which of the following statements is/are true ? (a) (i) The Many - to - one model maps many user threads to one kernel thread (ii) The one - to - one model maps one user thread to one kernel thread (iii) The many - to - many model maps many user threads to smaller or equal kernel threads (b) (i) Many - to - one model maps many kernel threads to one user thread (ii) One - to - one model maps one kernel thread to one user thread (iii) Many - to- many model maps many kernel threads to smaller or equal user threads
There are six friends who have different height and they stand according to their height information as given below. Q is greater than P and S. M is greater than P. T is greater than P who is greater than O. M is greater than Q. T is smaller than Q. Who among the following is the smallest in height?
If cardinality of (A U B) = cardinality of A+ cardinality of B. This means ____________
Study the following information to answer the questions given below: A company wants to hire young professionals where students of any graduate stream can participate in the drive. But company put some eligibility criteria. There are two rounds, round one consist of aptitude test and 2nd round is personal interview. 1) Student having no backlogs is eligible to participate in the drive. 2) Student must have at least 68 percentages in 10th and 12th. 3) Student having greater than 85 percentages in graduation without any backlogs are eligible for direct interview round. If the 1st or 2nd criteria not fulfilled then, 1) If a candidate has a work experience of 1 year in any field he is eligible to appear in aptitude round. But if the candidate has not clear his backlogs he is not eligible to participate in the drive. Amit a commerce student has a score of 69 percentages in 10th and 12th. He is currently working in an IT company for 15 months. In graduation he scored only 65 percentages and also clears his backlogs.
In a batch of 68 students, 23 students do not participate in any of the two games i.e. cricket and squash, 17 students participate in cricket only, 24 students participate in cricket and squash. How many students participate in squash only?
In a class of 120 students, 100 students participate in either Golf or Skating or both. Among them, total 60 students participate in Golf. A total of 56 students participate in Skating. How many students participate only in Skating?
Study the following information to answer the questions given below: A company visited an Engineering college for placement drive where students of any branch can participate in the drive. But company put some eligibility criteria. 1) Student having no backlogs are eligible to participate in the drive. 2) Student having greater than 9.8 CGPA without any backlogs are eligible for direct interview round. 3) Student must have at least 70 percentage in 10th and 12th. If the 1st and 2nd criteria not fulfilled then, a) If student has 1 or 2 backlog and the result is awaiting but having a CGPA 8.5 then he has to participate in presentation round before the interview round. Sameer a Mechanical student is the topper of the college having 90 percentage in both 10th and 12th. But he is having a 1 backlog in his 4th semester and the result is awaiting. His CGPA is 8.8.
Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________