MySQL Forums
Forum List  »  Newbie

building tables
Posted by: Ray Chambers
Date: February 12, 2009 03:17PM

i have not had any issues up till now with building databases playing around...

I was trying to build a user/employee type database and i had the following....

<asset> <employees> <applications> <application environments>

i was trying to build a table such that...

every employee will own an application which both will be part of the application env..

each of those will have assets routers switches servers cars planes whatever that are part of an application env which are part of a "application" which are owned by the employee...

the employee may own more than one of everything..

my thinking is

<asset> <employees> <applications> <application environments>

create table employee (employee key, employee name, asset_key, application_key, app_env key )

create table asset ( asset_key assetname employee_key, application key, application env key)

and so on....
is this correct?

Options: ReplyQuote

Written By
building tables
February 12, 2009 03:17PM
February 13, 2009 11:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.