stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Test your knowledge in Entity Relationship Diagram Flashcards | StudBud
Explore
/
Test your knowledge in Entity Relationship Diagram
Test your knowledge in Entity Relationship Diagram
14 terms
·
StudBud Administration
·
13 plays
Test your knowledge in ERD. #modellingtechnique #erd #entityrelationshipdiagra
Flashcards
14 cards
F
Practice quiz
P
Host live
L
Questions
14
Answers
1
Attributes are represented by ovals.
TRUE
FALSE
2
The goal with the Entity Relationship Model is to
Design how a database should look like - the intention of db
Facilitate a programming method
Facilitate organizational learning-behaviour
3
What is an Attribute?
An attribute is used to represent the relationship entities
An attribute is the smallest piece of information in an E-R Model
An attribute is an objects or concepts that can store data
4
Cardinality describes how many entity instances can be in the relationship
TRUE
FALSE
5
How can you uniquely identify every instances of an entity in a E-R Diagram?
By having a relationship
By having a unique identifier (id) as an attribute
By inserting the cardinality on the E-R Diagram
6
How can we make a Conceptual Database model ?
By using a WireFrame to create a conceptual database model
By using a technique named Entity Relationship Model
By using SQL to create a conceptual database model
7
Entities are represented by rectangles
FALSE
TRUE
8
What is this cardinality representing:
1:M
A many-to-one relationship
A one-to-many relationship
A many-to-many relationship
A broken-up many-to-many relationship
9
What best describes a database?
It is a way of storing data in an unorganised, illogical way
It is a way of storing data in an organisedand logical way
10
What cardinality is represented in the graphic?
1:M
1:1
M:1
M;M
11
Can a relationship have one or more attributes?
FALSE
TRUE
12
Relations are represented by rectangles
TRUE
FALSE
13
The basic components of a Entity-Relationship Model include:
Column name, Security key, File types, Attributes
Primary Key, Storage details, attributes
Entity, attribute, relationship and cardinality
14
Entity associated with a relationship is expressed as...
Specialization
Weak Entity
Cardinality
Attributes