All Courses
Get the App Signup / Login
Sign in Open App
Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Tests  >  Question Bank for GATE Computer Science Engineering  >  Test: ER-Model- 2 - Computer Science Engineering (CSE) MCQ

Test: ER-Model- 2 - Computer Science Engineering (CSE) MCQ


Test Description

10 Questions MCQ Test Question Bank for GATE Computer Science Engineering - Test: ER-Model- 2

Test: ER-Model- 2 for Computer Science Engineering (CSE) 2024 is part of Question Bank for GATE Computer Science Engineering preparation. The Test: ER-Model- 2 questions and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus.The Test: ER-Model- 2 MCQs are made for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: ER-Model- 2 below.
Solutions of Test: ER-Model- 2 questions in English are available as part of our Question Bank for GATE Computer Science Engineering for Computer Science Engineering (CSE) & Test: ER-Model- 2 solutions in Hindi for Question Bank for GATE Computer Science Engineering course. Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free. Attempt Test: ER-Model- 2 | 10 questions in 30 minutes | Mock test for Computer Science Engineering (CSE) preparation | Free important questions MCQ to study Question Bank for GATE Computer Science Engineering for Computer Science Engineering (CSE) Exam | Download free PDF with solutions
Test: ER-Model- 2 - Question 1
Save

Student and courses enrolled, is an example of

Detailed Solution for Test: ER-Model- 2 - Question 1

Many students can be enrolled in one or more courses and one course may have one or more students hence relation is many to many.

Test: ER-Model- 2 - Question 2
Save

A primary key if combined with a foreign key creates

Detailed Solution for Test: ER-Model- 2 - Question 2

A foreign key is a key of a relation which is primary key of some other relation. A primary key is combined with foreign key then are ferential constraint is set up between the two relation, hence it creates a parent-child relationship between the tables that connects them.

1 Crore+ students have signed up on EduRev. Have you? Download the App
Test: ER-Model- 2 - Question 3
Save

It is desired to design an object-oriented employee record system for a company. Each employee has a name, unique id and salary. Employees belong to different categories and their salary is determined by their category. The functions get Name, get ld and compute Salary are required. Given the class hierarchy below, possible locations for these functions are:
1. getld is implemented in the superclass.
2. getId is implemented in the subclass.
3. getName is an abstract function in the superclass.
4. getName is implemented in the superclass.
5. getName is implemented in the subclass:
6. getSalary is an abstract function in the superclass.
7. getSalary is implemented in the superclass.
8. getSalary is implemented in the subclass

Choose the best design

Detailed Solution for Test: ER-Model- 2 - Question 3

Each employee has a unique id, name and salary, Employees may have different salary as per their category e.g. Manager, Engineer or Secretary.
Id is unique for each employee for a given employee with Id name is unique.
Hence, get Id and get name must be implemented in Superclass as whatever their designation it will not change. Get salary must be an abstract function in superclass and implemented in subclasses.

Test: ER-Model- 2 - Question 4
Save

Let E1 and E2 be two in an E/R diagram with simple single-valued attributes R1, and R2 are two relationship between E1, and E2, where R1, is one-to many and R2 is many-to-many. R1, and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?
Detailed Solution for Test: ER-Model- 2 - Question 4

The given Relations R1 and R2 can be drawn as:

For relations R1, and R2, 3 tables are required as circled above.

Test: ER-Model- 2 - Question 5
Save

Consider the following ER diagram:

The minimum number of table needed to represent M, N, P, R1, R2 is.
Detailed Solution for Test: ER-Model- 2 - Question 5

Explanation: 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 )

Test: ER-Model- 2 - Question 6
Save

Consider the following ER diagram:

Which of the following is a correct attribute set for one of the tables for the correct answer to the above question?
Detailed Solution for Test: ER-Model- 2 - Question 6

The tables needed for the given ER-diagram are

which is covering aIl the attributes.

Test: ER-Model- 2 - Question 7
Save

Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have a relation R of cardinality 1 : m.

The attributes of E1 are A11, A12 and A13where , A11 is key attribute. The attributes of E2 are A21, A22, and A23 where A21 is the key attribute and A23 is a multi-valued attribute. Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is
Detailed Solution for Test: ER-Model- 2 - Question 7


Since each table is to in 3rd normal form for each multi-valued attribute individual table is to be created. Hence, total number of tables in the- database is 3.
1 for entity set E1, 2 for entity set E2 and 3 for attributes A23.

Test: ER-Model- 2 - Question 8
Save

​Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a class that has at least ( One boy and one girl. What does the following relational algebra expression produce? [Note: p is the rename, operator]
Detailed Solution for Test: ER-Model- 2 - Question 8

The given expression can be understood as:

gives the name of female students who have less marks than other boys.
(ii) The expression  (student)) gives the name of all the female student from (i) and
(iii) The given expression finally calculates the names of female student who have marks more than all the boys in the class.

Test: ER-Model- 2 - Question 9
Save

An ________ is a set of entities of the same type that share the same properties, or attributes.
Detailed Solution for Test: ER-Model- 2 - Question 9

An entity is a “thing” or “object” in the real world that is distinguishable from all other objects.

Test: ER-Model- 2 - Question 10
Save

The descriptive property possessed by each entity set is _________
Detailed Solution for Test: ER-Model- 2 - Question 10

Possible attributes of the instructor entity set are ID, name, dept name, and salary.

63 videos|7 docs|165 tests
Join Course
Information about Test: ER-Model- 2 Page
In this test you can find the Exam questions for Test: ER-Model- 2 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: ER-Model- 2, EduRev gives you an ample number of Online tests for practice

Top Courses for Computer Science Engineering (CSE)

Download as PDF

Top Courses for Computer Science Engineering (CSE)

Important Questions for ER-Model- 2

Find all the important questions for ER-Model- 2 at EduRev.Get fully prepared for ER-Model- 2 with EduRev's comprehensive question bank and test resources. Our platform offers a diverse range of question papers covering various topics within the ER-Model- 2 syllabus. Whether you need to review specific subjects or assess your overall readiness, EduRev has you covered. The questions are designed to challenge you and help you gain confidence in tackling the actual exam. Maximize your chances of success by utilizing EduRev's extensive collection of ER-Model- 2 resources.

ER-Model- 2 MCQs with Answers

Prepare for the ER-Model- 2 within the Computer Science Engineering (CSE) exam with comprehensive MCQs and answers at EduRev. Our platform offers a wide range of practice papers, question papers, and mock tests to familiarize you with the exam pattern and syllabus. Access the best books, study materials, and notes curated by toppers to enhance your preparation. Stay updated with the exam date and receive expert preparation tips and paper analysis. Visit EduRev's official website today and access a wealth of videos and coaching resources to excel in your exam.

Online Tests for ER-Model- 2 Question Bank for GATE Computer Science Engineering

Practice with a wide array of question papers that follow the exam pattern and syllabus. Our platform offers a user-friendly interface, allowing you to track your progress and identify areas for improvement. Access detailed solutions and explanations for each test to enhance your understanding of concepts. With EduRev's Online Tests, you can build confidence, boost your performance, and ace ER-Model- 2 with ease. Join thousands of successful students who have benefited from our trusted online resources.
© EduRev
Education Revolution
Follow Us
Signup to see your scores go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup