Sawa Bro, hapo nimekupata sawsawa, kweri swali lilikuwa ambiguity. sasa mimi nilikuwa nimeandaa table nne 1Class, 2Student, 3Teachers, 4Employee, Riport ninayotaka itowe ni kwa mfano students itowe riport ya mitihani,nk yani full doc za muhimukwa mwanafunzi.
WIch
table is related to wich
table ? Na what kind of relationship? one to one ne to many many to many. HIvi ni vitu vya muhimu kujua kwenye development ya any
Relational Database
Anoter assumption or ambiguty you sould clarify what is a
CLass? Is it a pysical room indetified by room nuber or Class mean biology class, or chemistry class wich is indetified a
composte key of teacher_Id, Subject_code and time.
Then kwenye repoti usi assume .kuwa specifc kwa mujibu wa swali ulilopewa kama inatakiwa itoe ripoti ya mitiani basi Matokeo ya mitihani ni subsytem on it own .Amabyo inaweza kuwa na table ya
Exam( Exam_no, Date,subject_code ,HOurs) Kunaweza kuwa na table ya
Result ( Student_id, Marks, Grade ). kwa haraka mpaka hapo naona the minimu number ya table zinazoweza kuwa kwenye databasa yako ni
SITA
Sidhani kama table ya
employee inahitajika unless system yako itahitaji kutoa report ya employee ambao sio
Teaching staff. Sababu Teacher nao ni epmloyee.
Kwenye swali ulilopewa lazima kuna sysytem requirement na description Japo utatakiwa kufanya your own assumptaion pale patapokuwa na utata
.Mfano kuna weza kuwa na maelezo kama haya
School XYZ has a number of
Student. Each student is registered to
cousrse . Course are tougght by
teacher in
class. One teacher can teach more than one
subject. Every year student do
exam for each subject they take.................
Maelezo kama ayo yatakusaidia kuwa na ERD au DFD depending kwenye assigment yako unatakiwa kutumia MOdelling tool gani. Correct
ERD Itakusaidi pia kujua
Relatiship type na
cardinality. Correct ERD itakusaida pia kujua ni table gani
primary key yake itahama kwenda kuwa
foreign key kwenye Table / entity nyingine. Maelezo ya swali yanaweza kukupa baadhi
field muhimu zinazotakiwa kwenye entity fulani. then wewe unaweza kuongezea zako. Maelezo kwenye swali tatakusaidi kujua ni report gani zinatakiwa so utajua report zako zitavuta data directly from table au inabidi utengeneze
query au
stored procedure au views za aina gani
Na sijui ni katika level gani ya college umepewa project hii. Sababu Unaweza kukutka unahitaji kujua na kusoma kitu kinaitwa
Entity Normalisation.( Enity kuwa na Info kuhusu kitu kimoja tu)
NB: Sijui mgawanyo wa maksi kwenye hiyo prjoeject yako ikoje lakini project nyingi zinatoa maksi nyingi kwenye design(
What) kuliko kwenye implimentation(
HOW)
Na kama dhumuni la project ni kujua simple Database develpmet Skill. ambazao ni
kuidenfy entity na
fields , Kui dentfentify
Primary key na freign keys , Ku identify
relatioship btn one table and another zako , etc go the simple
MS acess way during last stage of impliementation . Dont complicate things
Zaidi ujue hakuna one single best solution kwenye issue kama hizi. depending on Assumption utakazofanya in some scenario then mwisho wa siku kuna mwingine atakuwa na table 8 mwingine ana 6 .
