Author Question: What is a relational database model? How do relations differ from nonrelation tables? What will ... (Read 112 times)

HCHenry

  • Hero Member
  • *****
  • Posts: 591
What is a relational database model? How do relations differ from nonrelation tables?
 
  What will be an ideal response?

Question 2

The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A.
 
  A) Cardinality
  B) Relationship
  C) Identifier
  D) Association


ebonylittles

  • Sr. Member
  • ****
  • Posts: 318
Answer to Question 1

The relational database model represents data in the form of related tables, or relations. A relation is a named, two-dimensional table of data. Each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows. Each column in a relation corresponds to an attribute of that relation. Each row of a relation corresponds to a record that contains data values for an entity. Relations have several properties that distinguish them from nonrelational tables: 1. Entries in cells are simple. An entry at the intersection of each row and column has a single value. 2. Entries in a given column are from the same set of values. 3. Each row is unique. Uniqueness is guaranteed because the relation has a nonempty primary key value. 4. The sequence of columns can be interchanged without changing the meaning or use of the relation. 5. The rows may be interchanged or stored in any sequences.

Answer to Question 2

A



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

For a complete list of videos, visit our video library