samona Posted May 23, 2008 Share Posted May 23, 2008 Hi all, I need some help in checking whether this database is normalized: COMPANY Comany_ID --> Company_Name, Company_ISP, Company_Address, Company_Phone ISP ISP_ID-->ISP_Name, ISP_Address, Monthly_Cost, Year_to_Date_Cost EMPLOYEE Employee_ID -->Name, Address, Type PRODUCT Product_ID -->Product_Description, Employee_ID USER User_ID -->User_Name, Employee_ID, Email_Address, Password COMPUTER Computer_Name--> Computer_ID, IP_Address, Last_Update, OS, Usage Any help will be appreciated. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 23, 2008 Share Posted May 23, 2008 There are some excellent stickies on DB normalization. Quote Link to comment Share on other sites More sharing options...
samona Posted May 27, 2008 Author Share Posted May 27, 2008 Hi, After reading the tutorials on normalization and many tries of normalizing my database, I would like to ask you guys if it looks like a scalable database. Quote Link to comment Share on other sites More sharing options...
samona Posted May 28, 2008 Author Share Posted May 28, 2008 Hi, I am wondering how would I include backup computers in the above ER diagram. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 29, 2008 Share Posted May 29, 2008 I am wondering how would I include backup computers in the above ER diagram. Depends... you could have this as another line item in the computers table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.