« previous next »

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

HCHenry

  • Hero Member
  • *****
  • Posts: 591
on: Jul 7, 2018
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
Modern Systems Analysis and Design ¦ Valacich, George ¦ 8th Edition
Buy Test-Bank


ebonylittles

  • Sr. Member
  • ****
  • Posts: 318
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Cutaway Model of Earth Cutaway Model of Earth
The crania, and especially the faces of KNM-ER 1813 and 1470, differ enough that some scientists inc The crania, and especially the faces of KNM-ER 1813 and 1470, differ enough that some scientists inc
Type of Interactions, Model, Examples and Dependence of Energy on Distance Type of Interactions, Model, Examples and Dependence of Energy on Distance
A model for the action of RecBCD, (c) sites, and RecA in initiating homologous recombination A model for the action of RecBCD, (c) sites, and RecA in initiating homologous recombination
A model of transcription initiation as deduced from the crystal structure of TFIIB complexed A model of transcription initiation as deduced from the crystal structure of TFIIB complexed
A Model of Directional Selection against a Recessive Lethal Allele A Model of Directional Selection against a Recessive Lethal Allele
Video: Acid-base imbalances - respiratory acidosis and alkalosis

For a complete list of videos, visit our video library