Re: PC Inventory System

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <oki98@xxxxxxxxxx> wrote:

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 component
component_id
component_type (enum)
stuff_code
desc

Table pc_component
pc_id (fk)
component_id (fk)

OKi98

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux