« previous next »

Author Question: What is a relational database model? How do relations differ from nonrelation tables? What will ... (Read 65 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?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Heart Model Heart Model
W(illiam) E(dward) B(urghardt) Du Bois (1868–1963) spent his lifetime studying relations between ... W(illiam) E(dward) B(urghardt) Du Bois (1868–1963) spent his lifetime studying relations between ...
Marx's Model of Historical Change Marx's Model of Historical Change
Intervention Model-Response to Client Misconduct Intervention Model-Response to Client Misconduct
A model for voltage-gating in the channel A model for voltage-gating in the channel
The attenuation model regulating the tryptophan operon The attenuation model regulating the tryptophan operon
Video: Gastroesophageal Reflux Disease (GERD)

For a complete list of videos, visit our video library