« previous next »

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

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

The wild radish, Raphanus sativus, has become a model for studying the mating behaviour of plants. The wild radish, Raphanus sativus, has become a model for studying the mating behaviour of plants.
Heart Model Heart Model
Model for control of cytoplasmic polyadenylation and translation initiation Model for control of cytoplasmic polyadenylation and translation initiation
Single-cell circulation model Single-cell circulation model
Relations Between Iconic Memory, Short-Term Memory, and Long-Term Memory Relations Between Iconic Memory, Short-Term Memory, and Long-Term Memory
IPCC model projections depend on greenhouse gas emissions IPCC model projections depend on greenhouse gas emissions
Video: Cortisol (protein catabolism, gluconeogenesis, vasoconstriction & anti-inflammation)

For a complete list of videos, visit our video library