Test: ER-Model- 1

# Test: ER-Model- 1

Test Description

## 10 Questions MCQ Test Question Bank for GATE Computer Science Engineering | Test: ER-Model- 1

Test: ER-Model- 1 for Computer Science Engineering (CSE) 2022 is part of Question Bank for GATE Computer Science Engineering preparation. The Test: ER-Model- 1 questions and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus.The Test: ER-Model- 1 MCQs are made for Computer Science Engineering (CSE) 2022 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: ER-Model- 1 below.
Solutions of Test: ER-Model- 1 questions in English are available as part of our Question Bank for GATE Computer Science Engineering for Computer Science Engineering (CSE) & Test: ER-Model- 1 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- 1 | 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
 1 Crore+ students have signed up on EduRev. Have you?
Test: ER-Model- 1 - Question 1

### The data flow model of an application mainly shows:

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

A Data Flow Diagram (DFO) is a graphical representation of the flow of data through as information system, modelling its process aspects.

Test: ER-Model- 1 - Question 2

### Which of the following desired features are beyond the capability of relational algebra?

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

Relational algebra can not preform the following:
(a) Aggregate computation (avg, sum, etc. must be used).
(b) Multiplication
(c) Finding transitive closure
These operations are beyond the capability of relational algebra.

Test: ER-Model- 1 - Question 3

### In airline reservation system, the entities are date, flight number, place of departure, destination, type of plane and seats available. The primary key is:

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

The primary key is used to identify uniquely each and every entity. In which no attribute is redundant. By using the flight number and date we can identify the information regarding any plane.

Test: ER-Model- 1 - Question 4

The column of a table is referred to as the:

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

Every column of the table is referred to as attribute. Row of the table are called as tuples. Number of columns in the table defines the degree of the table.

Test: ER-Model- 1 - Question 5

In an E-R diagram ellipses represent ______.

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

In a E-R diagram, a rectangle represents entity set, relationship among entity set are represented by diamond box. Attributes are represented by ellipse and the link between attributes and entity set are represented by straight lines.

Test: ER-Model- 1 - Question 6

The set of permitted values for each attribute is called its:

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

Domain is defined as the set of permitted values for each attribute. The values of that attribute must lie within the defined domain.

Test: ER-Model- 1 - Question 7

A data model is a collection of conceptual tools for describing​

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

Data models are the basic entities through which abstraction in a DBMS in introduced, It actually defines how data is connected to each other and how they are processed and stored inside the system.

Test: ER-Model- 1 - Question 8

Choose the correct statements:

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

An alternate key is a key associated with one or more columns whose values uniquely identify every row in the table, but where is not the primary key. So, it can be said that an alternate key is a candidate key which is not a primary key.

Test: ER-Model- 1 - Question 9

E-R modeling technique is a:

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

It is a top-down method.
An entity–relationship model (ER model) describes inter-related things of interest in a specific domain of knowledge. An ER model is composed of entity types (which classify the things of interest) and specifies relationships that can exist between instances of those entity types.

In software engineering an ER model is commonly formed to represent things that a business needs to remember in order to perform business processes. Consequently, the ER model becomes an abstract data model that defines a data or information structure that can be implemented in a database, typically a relational database.

Some ER modelers show super and subtype entities connected by generalization-specialization relationships, and an ER model can be used also in the specification of domain-specific ontologies.

Test: ER-Model- 1 - Question 10

8. Statement 1: A tuple is a row in a relation
Statement 2: Existence of multiple foreign keys in the same relation is possible

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

A tuple is a row is a relation. There can exist multiple foreign keys in the same relation because there can exist multiple attributes in the relation that are primary keys in two or more other relations.

## Question Bank for GATE Computer Science Engineering

61 videos|7 docs|102 tests
 Use Code STAYHOME200 and get INR 200 additional OFF Use Coupon Code
Information about Test: ER-Model- 1 Page
In this test you can find the Exam questions for Test: ER-Model- 1 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: ER-Model- 1, EduRev gives you an ample number of Online tests for practice

## Question Bank for GATE Computer Science Engineering

61 videos|7 docs|102 tests