Timedora
Free Online Flashcard Deck

ER Modeling Fundamentals Free Online Flashcards

Study ER Modeling Fundamentals with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

What is an entity in an ER model?

Back

An entity is a kind of thing the system records, such as Student or Course.

02
Front

What is an instance of an entity type?

Back

An instance is an individual example of an entity type, such as one particular student.

03
Front

In the ER example, how do Student and an individual student differ?

Back

Student is an entity type; an individual student is an instance of that type.

04
Front

What is an attribute in an ER model?

Back

An attribute is a property of an entity, such as StudentName or CourseTitle.

05
Front

What does StudentName represent in an ER model?

Back

StudentName is an attribute example: it describes a property of the Student entity.

06
Front

What does CourseTitle represent in an ER model?

Back

CourseTitle is an attribute example: it describes a property of the Course entity.

07
Front

What should be defined for an ER-model attribute?

Back

An attribute should have a defined meaning and an appropriate value type.

08
Front

What makes an attribute or attribute set a key?

Back

A key is an attribute, or set of attributes, that uniquely identifies an entity instance.

09
Front

What is a candidate key?

Back

A candidate key is an attribute or set of attributes that could uniquely identify rows.

10
Front

How is a primary key selected from candidate keys?

Back

The primary key is the candidate key selected to identify rows uniquely.

11
Front

Can a key consist of more than one attribute?

Back

An entity may be uniquely identified by one attribute or by a set of attributes.

12
Front

What does an entity-relationship diagram (ERD) present?

Back

An ERD visually presents the information a system needs and the associations among that information.