IT214

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Right

Given a bridge with a candidate key with two attributes, it is usually not recommended to create a surrogate key for the bridge

Wrong

Given a multi-value attribute, with a variable number of values, for which we need to process independently the values, it is not recommended to consider a new department entity to represent the values.

Right

Given a multi-value attribute, with two values, for which we need to process independently the values, but without preforming global processing on all the values, it is not recommended to consider a new department entity to represent the values.

Right

Given an entity that has only candidate keys with 4 or more attributes, it is usually recommended to create a surrogate key for the entity.

MANY to ONE

A student has one advisor but an advisor advises many students.

simple

A ______ primary key is composed of a single attributes

Right

A database organized in terms of the relational model is a relational database

entity

A(n) ___________ has a distinct existence as an individual unit

attribute

A(n) _____________ is a characteristic or quality of an entity

instance

An entity ____________ is described by the values of its attributes

Right

An entity is a thing that exists either physically or logically

Right

Given an entity with a set of related attributes describing one of its characteristic, having a lot of duplicated tuples that must be modified together, risking data anomalies. For instance, for games in a soccer tournament is is stored the addresses of the field where the game will take place. In this situation it is recommended to consider a new entity describing theses attributes.

Right

Relationship names are verbs, linking two or more nouns

Wrong

Relationships names are adjectives in relation with a noun

attribute

The domain of an _______________ may represent an entity itself (e.g. an address of a person, city in which a person is living, the phone number of a person).

is a database organized based on the relational model

What is a relational database?


संबंधित स्टडी सेट्स

the 5 major types of species interactions; science

View Set

NUR 236 PrepU Chapter 37: Nursing Care of the Child With an Infectious or Communicable Disorder

View Set

Texas Statutes and Rules Common to All Lines

View Set