Test your knowledge in Entity Relationship Diagram

Question 1

What best describes a database?

Accepted Answer

It is a way of storing data in an organized and logical way

Question 2

How can we make a Conceptual Database model ?

Accepted Answer

By using a technique named Entity Relationship Diagram

Question 3

Relations are represented by rectangles

Accepted Answer

False

Question 4

What best describes a Relational Database?

Accepted Answer

Has more than one table and the tables are linked using keys

Question 5

What are the 4 steps that you will have to go through when you want to design a database?

Accepted Answer

Database req., Database Modeling, Database Implementation, Database Deploy.

Question 6

How can you easily identify whether something is an entity?

Accepted Answer

By searching for nouns

Question 7

What is an Attribute?

Accepted Answer

An attribute is the smallest piece of information in an E-R Diagram

Question 8

What happens when you go from a Conceptual DB Model (E-R Diagram) to a Logical db model?

Accepted Answer

Data is described more detailed. You map E-R Diagram to a logical DB Model

Question 9

The basic components of a Entity-Relationship Model include:

Accepted Answer

Entity, attribute, relationship and cardinality

Question 10

Cardinality describes how many entity instances can be in the relationship

Accepted Answer

True

Question 11

Attributes are represented by ovals.

Accepted Answer

True

Question 12

The goal with the Entity Relationship Model is to

Accepted Answer

Design how a database should look like - a blueprint of a database

Question 13

Which kind of E-R Model do you see on the picture?

Accepted Answer

This is a generalization(top/down) or specialization(down/top)

Question 14

A recursive relationships is a relationships between an entity and itself.

Accepted Answer

True

Question 15

What is SQL?

Accepted Answer

A declarative lang. for storing, manipulating and retrieving data from DB

Question 16

Can a relationship have one or more attributes?

Accepted Answer

True

Question 17

Entities are represented by rectangles

Accepted Answer

True

Question 18

What are the names of the basic three different relationships?

Accepted Answer

Binary-, recursive- and ternary relationships

Question 19

How can you uniquely identify every instances of an entity in a E-R Diagram?

Accepted Answer

By having a unique identifier (id) as an attribute

Question 20

How can you easily identify whether something is an relationship?

Accepted Answer

search for verb

Questions 20