Brainscape's Knowledge GenomeTM

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


See full index

Database + SQL > ERD Conceptual Model > Flashcards

ERD Conceptual 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 an ERD?

A

To visualize the relationships between entities in a database

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

True or False: An ERD represents the actual data in the database.

A

False

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

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

What is a relationship in an ERD?

A

A connection or association between entities

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

What symbol is used to represent an entity in an ERD?

A

A rectangle

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

What symbol is used to represent a relationship in an ERD?

A

A diamond

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

What symbol is used to represent an attribute in an ERD?

A

An oval

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

What is cardinality in an ERD?

A

It defines 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
10
Q

What is a primary key in an ERD?

A

A unique identifier for each record in a table

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

What is a foreign key in an ERD?

A

A field in one table that refers to the primary key in another table

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

What is an associative entity in an ERD?

A

An entity that exists to represent a many-to-many relationship between two other entities

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

What is a weak entity in an ERD?

A

An entity that depends on another entity for its existence

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

What is a subtype in an ERD?

A

An entity that inherits attributes from a supertype entity

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

What is a supertype in an ERD?

A

An entity that shares common attributes with one or more subtype entities

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

What is an ERD cardinality ratio of 1:1?

A

It means each instance of one entity can be associated with only one instance of another entity

17
Q

What is an ERD cardinality ratio of 1:M?

A

It means one instance of one entity can be associated with multiple instances of another entity

18
Q

What is an ERD cardinality ratio of M:N?

A

It means multiple instances of one entity can be associated with multiple instances of another entity

19
Q

What is a weak relationship in an ERD?

A

A relationship that depends on a weak entity for its existence

20
Q

What is a derived attribute in an ERD?

A

An attribute that can be calculated or derived from other attributes in the database

21
Q

What is a multivalued attribute in an ERD?

A

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

22
Q

What is a composite attribute in an ERD?

A

An attribute that can be divided into smaller subparts with their own meanings

23
Q

What is a key attribute in an ERD?

A

An attribute that uniquely identifies an entity

24
Q

What is a simple attribute in an ERD?

A

An attribute that cannot be divided into smaller subparts

Database + SQL (6 decks)

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