Questions tagged [undefined-relations]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
19 views

What are the main disadvantages of adding relationship between tables at later date?

During early development I tend to create tables using running numbers as Primary Key, although there is formally a real ID column for each table. I tend to forget mapping the relationship between ...
1
vote
1answer
292 views

A many-to-many relationship

I'm designing a simple database and have a question regarding a relationship. So far, I have users, books, highlights and bookmarks. The relationship rules are as follows: Each user may 'subscribe' ...
1
vote
1answer
75 views

Can I build relationships in existing system without breaking it?

This is my first question here, so I would love help to make it work for SO:DBA. I inherited an older relational system that is sitting on a SQL Server 2005 box and the database is at SQL2000 ...
0
votes
0answers
256 views

Spotting foreign key relations in a database that doesn't define all relationships as constraints?

At work I use a rather old MS Access database which defines some relations between tables, but does not outright define all of them. If the database application used an ORM, I would think that this ...