Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database + SQL > ERD Logical Model > Flashcards

ERD Logical Model Flashcards

1
Q

What does ERD stand for?

A

Entity Relationship Diagram

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the purpose of a Logical Model ERD?

A

To visually represent the logical structure of a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

True or False: Logical Model ERD focuses on the relationships between entities in a database.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is an entity in an ERD?

A

A person, place, object, event, or concept in the real world that can be uniquely identified

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is an attribute in an ERD?

A

A characteristic or property of an entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

True or False: An ERD can include both primary and foreign keys.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a relationship in an ERD?

A

Describes how entities are related to each other

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What symbols are used to represent entities in an ERD?

A

Rectangles

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What symbols are used to represent attributes in an ERD?

A

Ovals

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What symbols are used to represent relationships in an ERD?

A

Diamonds

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is cardinality in an ERD?

A

Describes the number of instances of one entity that can be associated with the number of instances of another entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is a weak entity in an ERD?

A

An entity that cannot be uniquely identified by its attributes alone

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a composite attribute in an ERD?

A

An attribute that can be further subdivided into smaller parts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is an associative entity in an ERD?

A

An entity that resolves a many-to-many relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a recursive relationship in an ERD?

A

A relationship where an entity is related to itself

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

In an ERD, what does a double diamond represent?

A

A many-to-many relationship

17
Q

What is a subtype in an ERD?

A

A subset of entities that share common attributes or relationships distinct from other subsets

18
Q

What is a supertype in an ERD?

A

An entity that contains common attributes or relationships shared by multiple subtypes

19
Q

What is a generalization in an ERD?

A

The process of defining a supertype and its subtypes

20
Q

What is specialization in an ERD?

A

The process of defining subtypes based on common characteristics

21
Q

What is an ERD constraint?

A

A rule that restricts the data values that can be stored in a database

22
Q

What is a multi-valued attribute in an ERD?

A

An attribute that can have multiple values for a single entity instance

23
Q

What is a derived attribute in an ERD?

A

An attribute whose value is derived from other attributes

24
Q

What is a partial participation constraint in an ERD?

A

When an entity can exist without being related to another entity

25
Q

What is a total participation constraint in an ERD?

A

When an entity must be related to another entity

Database + SQL (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions