Describe all of the relationships between the tables in the attached image file TableRelationships.jpg

 

a) describe all the foreign key and primary keys, either by detailing them 1 by 1 or define the CREATE table statements for all the tables (10 marks)

b) describe the relationship between each table ( 1..1 (exactly one match) 1..n (one or more matches)) (5 marks)

REFER THE PICTURE UPLOADED WITH IT 

 

contacttype id INT(11) label VARCHAR(255) Indexes contact pid INT(11) ctid INT (11) value TEXT Indexes person id INT(11) frstname VARCHAR(255) lastname VARCHAR(255) dob DATE managerid INT (11) Onotes TEXT created TIMESTAMP Indexes projectperson prid INT(11) pid INT(11) rid INT (11) Indexes role id INT(11) label VARCHAR(255) Indexes project id INT(11) label VARCHAR(255) budget DOUBLE Indexes