Database Fundamentals and ER Model

Front

What is a Database?

Back

An organized collection of data, structured in multiple formats, stored in some form of storage medium.

Front

What does DBMS stand for?

Back

Database Management System.

Front

What is the Relational Model?

Back

A data model that organizes data into tables (relations) with rows and columns.

Front

What is an Entity in the context of ER Model?

Back

An abstract object of some sort; a thing (noun).

Front

What is an Entity Set?

Back

A collection of similar entities; a class of objects.

Front

What are Attributes in an ER Model?

Back

Properties of entities in an entity set.

Front

What is a Relationship in an ER Model?

Back

A connection among two or more entity sets.

Front

What is a Relation in the context of a Relational Model?

Back

A table or set of records.

Front

What is a Tuple?

Back

A row in a relation (record).

Front

What is a Relation Schema?

Back

The logical structure of a database, including the name and type of each field.