« previous next »

Author Question: How are 1:1, 1:N and N:M relationships handled in Microsoft Access? What will be an ideal ... (Read 108 times)

schs14

  • Hero Member
  • *****
  • Posts: 569
on: Jul 7, 2018
How are 1:1, 1:N and N:M relationships handled in Microsoft Access?
 
  What will be an ideal response?

Question 2

Discuss SQL data types.
 
  What will be an ideal response?


LVPMS

  • Sr. Member
  • ****
  • Posts: 323
Reply #1 on: Jul 7, 2018
Answer to Question 1

By default, when Microsoft Access creates a relationship between two tables, it creates a 1:N relationship. N:M relationships are created in Microsoft Access, as in all other DBMS products, as two 1:N relationships linking the two tables (based on the original two entities) through an intersection table. As far as Microsoft Access is concerned, there are no N:M relationships To create a 1:1 relationship between two tables in Microsoft Access, the Indexed property of the foreign key column in the table containing the foreign key must be set to Yes (No Duplicates) before the relationship is created. With the property set, the relation is automatically created as a 1:1 relationship.

Answer to Question 2

Common examples of standard SQL data types are Char, VarChar, Integer, and Numeric. The Char data type is for fixed-length character data. VarChar is for variable-length character data. Integer is for numeric data that are whole numbers only. Numeric is for numeric data that may include decimals. Char, VarChar, and Numeric must be qualified by a length specification to indicate the amount of storage space to be allocated for each data item. For example, Char(10 ) indicates fixed-length character data that is always stored as 10 characters.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

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?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Proposed relationships between living and fossil platyrrhines and catarrhines. Proposed relationships between living and fossil platyrrhines and catarrhines.
This chart illustrates the four quadrants in which we can place the relationships between the state This chart illustrates the four quadrants in which we can place the relationships between the state
Apply deep effleurage to triceps. Position arm with elbow pointing upward to access the triceps ... Apply deep effleurage to triceps. Position arm with elbow pointing upward to access the triceps ...
Access to clean drinking water is just as important as adequate nutrition for human health Access to clean drinking water is just as important as adequate nutrition for human health
Lab: Mass Relationships in Chemical Reaction Lab: Mass Relationships in Chemical Reaction
Evolutionary Relationships Among Honeycreepers Evolutionary Relationships Among Honeycreepers
Video: Parkinson's Disease

For a complete list of videos, visit our video library