DBMS conceptual

Question

suppose i  m making a website where i have 3 group of people G1,G2,G3 ..i need to perform various operation ,depending on groups..But operations will be on any one group(no inter group operation).

For example there will be NO sql query like G1.pid=G2.pid..Nothing Mixed..

now suppose i have 3 persons(name,age) under 3 groups. total 9 records..then what design should i take among these two?

Design 1:

One single table Person Details(GID,Pid,Name,age) where PK(gid,pid) and insert 9 tuples here.

design 2:

three different table for three groups ,each of 3 records.then perform operation on them

now second approach is more modular.

But according to performance, speed Which one should i take?

Comments

if only 3 entries are required then , you should be going with one table as in that case there is very very minute diffference of speed from approach 2, i am assuming you are talking about the case when you have thousand enteries like this , then that modular approach will come in handy as in that case you won't be processing the records you don;t need like in case of range quries, you will be procssing the whole table if you go with 1st approach which will lower the speed but with modular approach it will give you far better result.

---

Didn't fullu understand . But first you have to find functional dependies and do normalization to get the best table.

---

yes of course talking abt 1000 entries in mind

---

thnaks mohit for clearing