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 

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

a CREATE TABLE contacttype id INT11 label VARCHAR255 PRIMARY KEY id INDEX label FOREIGNKEYidREFERENC... View the full answer