Tables with a shared primary key

Question

What term describes the relationship between tables that have a common primary key?

Here is an example:

Table 1
property (property_id, property_location, property_price, ...);

Table 2
flat (property_id, flat_floor, flat_bedroom_count, ...);

Answer 1

, . , flat property, property flat, . - - ( , flat property) .

Answer 2

, Supertype/Subtype. , (), , (), .

, Person (), , , Name. Employee (), , , . , . PersonID, , , Person.

Google " " . .

• http://www.learndatamodeling.com/dm_super_type.htm
• http://technet.microsoft.com/en-us/library/cc505839.aspx

Answer 3

( ). , "" . " ", , "" .

, , " " "" " ". ( - - .)

, , , property_id PK property_id PK, FK .

Answer 4

" "?

Answer 5

" " " " . ( , , - .)

, , " ", " ", , , . , , , , , .

Answer 6

( .)

" "... ? ""

: 1 , 2 . , [] , [s], . .

, " " " ", , , " " " ", , , , .

"Can you give an example with two tables with shared primary keys, where one table will not contain all the key values ​​that appear in another?" "

Table 1: column A of type integer, primary key A Table 2: column A of type integer, primary key A

Rows in table 1: {A: 1}. Satisfies the primary key for table1. Rows in table 2: {A: 2}. Satisfies the primary key for table2.

I am convinced?