PROGRAMMING LANGUAGE

[jelo kid]

thanks siR carpediem at siR bobbylost..
-try ko dito mag'updaTe nung ginagawa naming(ako lang pala..haha) systeM..
msg ko kayo sakaling kailanganin ng tulonG.

[jelo kid]

tan0ng..
panu ba mag'normalize ng database??
sql gamit namin

[bobbylost]

Sa pagnonormalize ng tables, ang objective is to minimize redundancy.
Mas madali sana kung maiillustrate ko pero marami sa google. Type mo lang how to normalize database tables.
Example ng Hindi Normalize:
Table 1: Student
EmployeeId
Fname
Lname

Table2: Subject
EmployeeId
Fname
Lname
SubjectId
Subjectdesc

Normalize:
Table 1: Student
StudentId
Fname
Lname

Table 2: Subject
SubjectId
Subject

Table3: StudSubj
StudentId
SubjectId

Sa Ex2, everytime na may bagong subject si student, hindi mo kailangang iupdate lahat ng tables.
Ang kailangan mo lang iupdate is yung table3. All you have to do is add yung studentId and yung new subjectid  sa table2. Kapag naman may bagong subject, kahit wala pa'ng assignment sa student, pwede mo nang iupdate si Table2.

Mas maiintindihan mo kapag nilagyan mo ng sample data tong sample ko.
Minsan kasi mahirap magets pag table structure lang tinitingnan mo.
Practice din.

Hope this helps kahit papaano.

[marvinofthefaintsmile]

merong mga tinatawag na normal forms.. bale 6 ito..
1st normal form
2nd normal form
3rd normal form
boyce-codd normal form
4th normal form
at fifth normal form.

bale meron itong mga rules kada form for normalization. dapat ma-meet mo sila like transitivity chenez for 3rd. so maglalaro ka ng mga foreign keys dito.

[jelo kid]

^di ko nagets!wahaha:D
btw,ahead yung project namin(akin lang pala) sa mga classmates ko..
eto palang nagagawa ko eh,
-login ng admin
-create poll,edit,update,delete
-create list of candidates(per poll),edit,delete,update

[jelo kid]

NEW UPDATE.
finals pa pasahan ng project pero malapit na kami matapos(lapit na midterm).
salamat kasi dalawa kaming programmer sa grupo ko..
yun lang eh nasa critical stage na kami nung project which is yung voting process..