Page 1 of 1

Database Design -- Suggestion / Help

Posted: Sun Mar 09, 2003 3:14 am
by kaskothi
Hello All,
I am new to DB and need guidance from DB gurus in this scenario.

I have been assigned to put up a web site to track disk usage of file servers at three sites.

Initally I had thought of four tables for each site; But then I reduced this to two tables ; one containing filer name, site name and filer id. And second table has date, disk_used, filer id.

In second table I tried using filer id as foreign key. But it seems mysql won't accept foreign key in create table statement.

I also looked at references. But this also does not seem to fit in.

Could some one suggest alternatives ?

TIA
RAM