Tagged Questions
1
vote
1answer
81 views
Separating tables vs having one table
At the moment I have a table setup that looks somewhat like this:
create table tbl_locationcollections
(
id int(11) PRIMARY KEY IDENTITY, --(Primary Key),
name varchar(100) not null,
...
-1
votes
1answer
76 views
What is the real-world purpose of an optional 1:1 relationship?
I know that one-to-one relationships can be used to split data into multiple tables for performance or security and that it is used to create a is-a-relationsship.
But aside from that things, what is ...
1
vote
1answer
68 views
Relation candidate keys
I have the following relation:
R = ABCDE
F: AB->DE, AC->B, DE->C, AE->C, C->AB
I need to determine this relations candidate keys.
Now, if I understood the defintion correctly:
...
