« previous next »

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

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Water striders serve as a model organism for the study of sexual conflict between males and females. Water striders serve as a model organism for the study of sexual conflict between males and females.
Model of a nursing clinical decision support system Model of a nursing clinical decision support system
Two models of sensory system organization: The former model was hierarchical, functionally ... Two models of sensory system organization: The former model was hierarchical, functionally ...
A Mental Model of the Craftsman Experiment A Mental Model of the Craftsman Experiment
Ethical Decision-Making Model Cont Ethical Decision-Making Model Cont
Model of a complex systems Model of a complex systems
Video: Types of disease resistance: innate defenses & immunity

For a complete list of videos, visit our video library