Author Question: How are 1:1, 1:N and N:M relationships handled in Microsoft Access? What will be an ideal ... (Read 111 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?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

For a complete list of videos, visit our video library