CS 306, Spring 2018 Quiz 4 1. The primary key of Club is the composite key (name
ID: 3738966 • Letter: C
Question
CS 306, Spring 2018 Quiz 4 1. The primary key of Club is the composite key (name, address) and the primary key of Security is name. 1. Security ires Club a) What do the multiplicities of this relationship mean in the example? b) Which table should have a foreign key to maintain this relationship? c) Give the relation schemas (in text form) of these two tables, showing all known attributes based on the above description and diagram. You must indicating primary and foreign keys, if there is any. You may rename certain attributes.Explanation / Answer
1)
a) The multiplicities tells that the association of the relationship between the two entities named Club and Security. Here based on the given ER Diagram snapshot it is defined that for one Club there might be one or many Sucurity will be there.
b) Obviously Security table will have the foreign key relationship because to impose foreign key relationship on one table it must be primary key on the other table .Here in Club name is defined as primary key , so that in security table clubname will be foreign key and have a link to the Club table.
c) The two relational schemas are
Club ( name,address, phone )
Security ( name, phone, clubName ( Foreign key) )