I need to turn the attached ER diagram into a relational model.
This is what I have came up with, is it going the right direction or away off?
relation AB1relationship
a1 : A1
b1 : B1
primary key a1
foreign key a1 references A
foreign key b1 references B
relation A
a1 : A1
a2 : A2
a3 : A3
primary key a1
{mandatory participation of A in AB1relationship}
constraint((project A over a1) difference(project relationshipAB1over a1)) is empty
relation B
b1 : B1
b2 : B2
b3 : B3
primary key b1
{mandatory participation of B in AB1relationship}
constraint((project B over b1) difference(project relationshipAB1 over b1)) is empty
relation AB2relationship
a1: A1
b1: B1
primary key a1
foreign key a1 references A
foreign key b1 references B
relation A
a1 : A1
a2 : A2
a3 : A3
primary key a1
{mandatory participation of A in AB2relationship}
constraint((project A over a1) difference(project relationshipAB2 over a1)) is empty
relation B
b1 : B1
b2 : B2
b3 : B3
primary key b1
