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?