Thank you for the replies guys.. Especially Ray.. I appreciate your help.. I'll ask questions again if I need some advice.. thanks again =P

Ray K (10/28/2010)

---

I would remove ALL references to dates/times in the room and subject tables, and put them in the schedule table, maybe something like this:

room

r_no

(remove these)

r_starttime

r_endtime

r_day

r_type

(Note: if you're dealing...

To tell you the truth.. I am completely clueless with normalizations. But I do understand the concept. I've already finished a working program in netbeans w/out losing data integrity and...