Member Avatar for respree

Hi all.

I'm in the beginning stages of learning relational database design (in Access) and am trying to understand the concept of referential intregrity.

I can see why this is important to insure the integrity of the data, so that foreign keys aren't left pointing to nowhere.

However, by default, Access has it turned off, whereas it seems like one would want to use it, more often than not.

Under what conditions would it be appropriate to having it turned off (i.e. no referential integrity)?

Any help would be appreciated.

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by suRoot
Member Avatar for suRoot

if no 2 tables are or would be used together then they don't need to be linked

ie if u have a lookup table(a list)

also remember don't do many to many as it means your normalisation is wrong..
no one can stress to anyone enough how imortant normalisation is, as it can result in a right balls up

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.