i would like to store the computer parts in a database in which each part are tied with purchase order so that i can look at the warranty status of any part that i like

let say a computer1 has hard disk, ram, cdrom, processor

so all those devices in computer1 can be considered as one component and each of them are tied to purchase order if each of the are bought separately.

but how do i store in database where some computers can be a component where it itself ties with a purchase order. which mean there is some computer are bought from Dell, HP and etc and not being buildup from parts

so how to design this database that tied with purchase order?

thanx.

sounds like a homework assignment

what have you done so far?