PK, FK and Relationships

I have a database my tables are

Project
Bidpackage
Contractor

Project
primary key is pID

Bidpackage
primary key is bID
foreign key is pID

Contractor
primary key is cID
foreign key is bID

when a user select project it release the bidpackage base on the project and when a user select bidpackage it release only the contractors base on the bidpackage

Here is my question.
Did I set the foreign key relationship up right?

I would like to now before I write the code for the make, model, year scenario.

asked Dec 27 '10 at 05:31 AM in Default

postonoh
205 ● 6 ● 15 ● 22

(comments are locked)

1 answer:

What you have there seems fine, the project can have many bid and many contractors but bids and contractors can only relate to one project. If you should want something different - such as each contractor relating to more than one project then you will need a middle table to achieve the many-to-many relationship. Also, you currently have no relationship between the contractor and the bid. Does that fit your business rule?

answered Dec 27 '10 at 05:46 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

It looks to me like there IS a relation between contractor and bid. In Contractor, there's a FK on bID, which I would assume relates to bID in bidpackage.

Dec 27 '10 at 06:01 AM Magnus Ahlkvist

Yes, I will have contractor connected to more then one project. Do you mean contractor to project

Dec 27 '10 at 06:02 AM postonoh

sorry, yes, was on phone and couldnt see Q as I wrote A . . . memory sadly affected by Christmas excesses.

Dec 28 '10 at 01:02 AM Fatherjack ♦♦

(comments are locked)