Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? - EduRev Computer Science Engineering (CSE) Question

Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity

Open App

Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > Consider the following ER diagram.The minimum...

Join the Discussion on the App

Consider the following ER diagram.

The minimum number of tables needed to represent M, N, P, R1, R2 is

a)
2
b)
3
c)
4
d)
5

Correct answer is 'B'. Can you explain this answer?

FREE This question is part of

Test: ER-Model- 2

Attempt Test

Attempt this Test

Verified Answer

Consider the following ER diagram.The minimum number of tables needed ...

Answer is B, i.e, 3 minimum tables. M, P are strong entities hence they must be represented by separate tables. Many-to-one and one-to-many relationship sets that are total on the many-side can be represented by adding an extra attribute to the “many” side, containing the primary key of the “one” side. ( This way no extra table will be needed for Relationship sets ) M table is modified to include primary key of P side(i.e. P1). N is weak entity, and is modified to include primary key of P (i.e, P1). Therefore there would be minimum of 3 tables with schema given below :
M (M1, M2, M3, P1)
P (P1, P2)
N (P1, N1, N2)

Note: This modification of a table in the case of one-many or many-one to include relationship set at the many side works well, but only in the case when the relationship set doesn't have its own attributes. If the relationship set has its own attribute then we need to make a separate table for the relationship set also.

View all questions of this test

View all answers Start learning for free

< Previous Question Next Question >

Explore Courses for Computer Science Engineering (CSE) exam

Similar Computer Science Engineering (CSE) Doubts

Consider the following E-R diagram.The minimum number of tables needed to represent M, N, P, R1, R2 is Correct answer is '3'. Can you explain this answer?

View answer

Consider the following ER diagram: The minimum number of table needed to representM, N, P, R1, R2 is.

View answer

Consider the following relation schema pertaining to a students database:Student (rollno, name, address)Enroll (rollno, courseno, coursenam e)where the primary keys are shown underlined. The number of tuples in the Student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where * denotes natural join ?

View answer

Consider the following relational schema pertaining to a students database. Student: (rollno. name, address) Enroll: (rollno. courseno. coursenam e) Where the primary keys are shown underlined. The number of tuples in the Student and the Enroll tables are 120 and 8 respectively. What are the maximum and the minimum number of tuples that can be present in (Student * Enroll), where * denotes natural join?

View answer

Find minimum number of tables required for converting the following entity relationship diagram into relational database? Correct answer is '3'. Can you explain this answer?

View answer

Top Courses for Computer Science Engineering (CSE)View all

GATE Computer Science Engineering(CSE) 2025 Mock Test Series

Question Bank for GATE Computer Science Engineering

General Aptitude for GATE

Computer Networks

Programming and Data Structures

Top Courses for Computer Science Engineering (CSE)

View all

Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer?

Share with a Friend

Answer this doubt

Question Description
Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer?.

Solutions for Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

Here you can find the meaning of Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer?, a detailed solution for Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? has been provided alongside types of Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Consider the following ER diagram.The minimum number of tables needed to represent M, N, P, R1, R2 isa)2b)3c)4d)5Correct answer is 'B'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.

Explore Courses for Computer Science Engineering (CSE) exam