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. Link to comment https://forums.phpfreaks.com/topic/106934-normalization/ 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. Link to comment https://forums.phpfreaks.com/topic/106934-normalization/#findComment-548170 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. Link to comment https://forums.phpfreaks.com/topic/106934-normalization/#findComment-550768 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. Link to comment https://forums.phpfreaks.com/topic/106934-normalization/#findComment-551618 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. Link to comment https://forums.phpfreaks.com/topic/106934-normalization/#findComment-552694 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.