Database Design Theory

_________is a person, place, object, event or concept in the user environment about which company wishes to maintain the data

• attribute

• entity

• relationship

• primary key

Which attribute is the DERIVED ATTRIBUTE?

• Name

• Address

• Age

• Salary

Each entity is described by __________.

• Attribute

• Key

• Entity

• Relationship

This shape is symbol for ?

• Entity

• Attribute

• Primary Key

• Foreign Key

Which attribute is the COMPOSITE ATTRIBUTE?

• Employee

• Birthdate

• Name

• Address

A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.

• Record

• Field

• Foreign Key

• Primary Key

This key uniquely identifies each record in an entity.

• Composite Key

• Primary Key or Key Identifier

• Secondary Key

• Foreign Key

Every student can take many subject AND every subject can have many students

This statement above referring to...

• Many to Many (M:N)

• One to One (1:1)

• One to Many (1:M)

______________is a relationship set where two entity sets participate in a relationship set.

• Unary Relationtiop

• Binary Relatioship

• Ternary Relationship

• Key Relationship

An attribute that holds multiple values for a single entity.

• Single Valued Attributes

• Multi Valued Attributes

• Composite Attributes

• Derived Attributes