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

schs14

  • Hero Member
  • *****
  • Posts: 569
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
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
 

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

For a complete list of videos, visit our video library