Database Design and Implementation

Flashcards covering key concepts, definitions, and facts from the Database Design and Implementation lecture.

An entity instance is a concrete thing, eg __.

J.Bloggs

A binary relationship has __ participating entities.

two

A ternary relationship has __ participating entities.

three

Attributes can be __, eg Date of Birth.

BASE

A __ is an abstract connection between entity types.

relationship type

Attributes that describe the properties of things are called __.

attributes

A __ constraint is often simplified into two relationships; 1:1 and m:1.

m:m

The primary key for the Loan table is __.

BookID, StudentID, Date

Each department belongs to a __.

University

A __ relationship has just one participating entity and is recursive.

unary

A weak entity depends on a strong entity for its own __.

existence

A one-to-many relationship means one entity can relate to__ other entities.

many

In Chen Notation, a one-to-many relationship is represented with __.

a line with a crow's foot at the many end

The __ identifies the uniqueness of records in an entity.

primary key

Many-to-many (m:m) relationships must be resolved into __ relationships.

1:m

In the context of a university, students __ courses.

enroll

In a library system, a student may borrow many __.

books

In the ER model, every relationship is __ related to the entities involved.

abstractly

Conceptual, logical and physical are types of __ models.

database