, 2007 23:07
To: OKi98
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] PC Inventory System
Hi ...
I would modify solution 3:
Table user
user_id
First_name
last_name
Table pc
pc_id
user_id (FK)
Table component
component_id
component_type (enum)
stuff_code
desc
Table pc_component
pc_id (fk
Hi ...
I would modify solution 3:
Table user
user_id
First_name
last_name
Table pc
pc_id
user_id (FK)
Table component
component_id
component_type (enum)
stuff_code
desc
Table pc_component
pc_id (fk)
component_id (fk)
On 3/23/07, OKi98 <[EMAIL PROTECTED]> wrote:
christine wrote:
> Hi all,
christine wrote:
Hi all,
I need some help to decide the best db design for PC Inventory System.
There are 2 solution that I thought, you can see it at the attachment.
Which is the best solution ? Is there another solution ?
Regards & Thanks,
Christine
Solution 3:
Table pc
pc_id
Table co
Hi all,
I need some help to decide the best db design for PC Inventory System.
There are 2 solution that I thought, you can see it at the attachment.
Which is the best solution ?
Is there another solution ?
Regards & Thanks,
Christine
db_solution.xls
Description: MS-Excel spreadsheet
-