murinmalengko 0 Report post Posted February 21, 2007 ermm..assalammualaikum..saya dah letak soalan ini dalam pengkalan data...saya rase soalan saya sebenarmyer lebih berkisar kepada penggunaan aspmaker ...mintak tlg pada mereka2 yg pandai.. saya tgh berusaha buat sistem online utk tuntutan elaun perjalanan ..masalahnye skrg..saya sangkut kat database..saya menggunakan aspmaker dan msAccess utk buat sistem ni...relationship antara table2 membuatkan saya semakin pening dgn sistem ni...mm...bendenye rasenye simple jer..tp sy still x tau mcmner dan apa yg sy tgh lakukan sbnrnyer...dlm sistem ni..let's say,sorang pensyarah...pergi kursus kat sabah sana..dia melibatkan satu tuntutan,byk perjalanan dan kemungkinan byk tol...die bergerak dari rumah naik kereta sendiri (tuntutan perbatuan) then kena g KLIA..katekan die kena byr tol kat sg besi...naik kpl terbang(waran,x pyh tuntut)..naik teksi kat sana(tuntutan teksi)..then stay kat hotel(yg ini melibatkan mkn , lojing,etc sumer)..lepas tu balik semenanjung semula..naik kereta...kene tol...sampai rumah...view sistem tu lebih kurang camni arr..user (user dalam sistem)tuntutan ( bole buat byk tuntutan,tp satu je dlm satu bulan)perjalanan(tol) (dalam satu tuntutan tu ade byk byk perjalanan and dlm perjalanan tu ade tol yg juga mungkin bole byk)adeii ...pening2 ...cmne nak relatekan semua rekod2 ni supaya saya bole recall semula utk history dlm sistem tu...that's mean,pensyarah tu bole buat tuntutan baru utk bulan seterusnya,tp still bole tgok dienyer tuntutan yg lama2??dlm aspmaker tu ,mmg die generate sumer table yg kite dah relatekan tu...tp masalahnye,katekan kalo kite add new perjalanan, mmg die masuk dlm database...tp user bile nak view data dlm list...user bole tgok sumer perjalanan user2 lain...sy tatau nak restrict kan die...ni kene pakai accesslevel dlm aspmaker tu ker?nak setup mcmner?bile buat tuntutan tol pon same..sy menggunakan tol id sbg PK(autonumber) ,bile saya relatedkan dgn id_tuntutan atau id_perjalanan..user kena input id tersebut...dimana mereka sudah semestinye x tahu apa2...saya guna alternative nokadpengenalan utk mudahkan input data...tp masalahnya kalo camtu..Id_tol tu x update dalam table perjalanan..bile dalam perjalanan x update...table tuntutan pon x update...and so on..waaa..pening2... blink.giftlg ek pada sape2 yg pandai...trimas Quote Share this post Link to post Share on other sites
ijurq 0 Report post Posted February 21, 2007 ce kasik tunjuk relationship diagram..tapi kalau sume ok..foreign key ok..primary key ok..normalization ok..patutnye takde masalah.. Quote Share this post Link to post Share on other sites
murinmalengko 0 Report post Posted February 21, 2007 ce kasik tunjuk relationship diagram..tapi kalau sume ok..foreign key ok..primary key ok..normalization ok..patutnye takde masalah..http://img69.imageshack.us/my.php?image=relationshipgb8.jpgni r/ship table2 ..ni dah dipermudahkan..tp still berbelit2..kalo salah tlg betul kan...http://img136.imageshack.us/my.php?image=pribdrv0.jpgni plak isi dalam table peribadi selepas di linkkan dgn table2 yg lain....saya sebenarnya x begitu faham dgn tuntutan elaun perjalanan ni..saya buat berdasarkan apa yang saya faham dan cuba selagi mampu .. ni adalah tajuk projek final projek saya..so kena jgk belajar mcm mana sistem ni berfungsi...hrp putera2 yg otai2 dptlah membantu saya...saya cuba create automated form dlm access utk input data,masalah yang kesan skrg adalah1. jika saya input data buat satu tuntutan baru,user kena manually input id_pengguna(autonumber)~saya x boleh remove sbb die linkkan master n child table...camne nak solve ek?ke kena pecahkan lagi table tu dan buat bridge utk linkkan table2 ni...saya dah xde idea nak buat ape..semua saya dah try...actually mula2 saya link dgn cara insert subdatasheet..then baru saya edit r/ship die..mcm ni baru die nak link..2.table2 lain pon bermasalah jgk~butir tol = kena input id_perjalanan~dataperjalanan = kena input id-tuntutanmm..lagi satu...camne nak calculate value dan masuk terus dalam field dalam table ...saya try pakai query utk calculate tol dan dapat jumlah total tol setiap perjalanan tp x tahu nak link kan dlm field dalam table tu...saya dah pernah try generate dalam asp maker..hasil die sama jgk..user still kena input id id tertentu dimana nilai tu mesti ada utk dipaparkan dalam pagelist dan user x tahu menahu langsung pasal nilai tersebut..ini bermakna saya kena cari coding utk auto update ker??....macammane saya nak set user utk view data dia sorang je dlm aspmaker?coding ke aper?ada sapa2 tau tak??makna nya,lepas user login,die terus masuk dalam pagelist yg hanya view maklumat tuntutan die sahaja..kire mcm history laa...tlg ek pada sape2 yg tau... Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted February 21, 2007 aku tengok table ko kena ubah la.Table Tol.kena pecahkan lagi, sebab ada medan dah berulang-ulang.dan buat rel one to many.apasal gambar tak clear? Quote Share this post Link to post Share on other sites
DarkWan 3 Report post Posted February 21, 2007 Aku cadangkan ko hindari penggunaan aspmaker tu. Sebab nanti xdpt 'nikmat' coding. Unless memang dah last minute Quote Share this post Link to post Share on other sites
ijurq 0 Report post Posted February 21, 2007 (edited) database ko ni tak cukup normal..ce buat normalization....kalau nak buat sistem...kenal pasti la sape actor, ape role masing2....and sbb ko nye ni web based..ce ko buat satu activity flow ke..and then ko kena pasti ape data yg terlibat...baru nmpk ape jenis table ko nak pakai...ni pendapat aku la.. Edited February 21, 2007 by ijurq Quote Share this post Link to post Share on other sites
murinmalengko 0 Report post Posted February 21, 2007 aku tengok table ko kena ubah la.Table Tol.kena pecahkan lagi, sebab ada medan dah berulang-ulang.dan buat rel one to many.apasal gambar tak clear?gambar tu kena klik kat die baru die magnified kalo x silap...mm...pecahkan table tol je ke ape?..medan tu berulang2 sbb dalam satu perjalanan...kalo melibatkan tol..dia akan mengambil kire perjalanan pergi dan balik...ke maksud uncle powerroot kena jadikan satu je ..maknenyer,satu id tol utk satu tol mcm kat bwh ni?...bile saya fikir2 balik ada betulnya jgk...satu tol satu id satu resit...settle psl tol..thanks cikgu powerroot.. saya dah edit dah..ni hasil r/ship baru die..http://img337.imageshack.us/my.php?image=relbrumr8.jpg saya gusar mcmner nak call total sum dr sumer2 jumlah yg ada dalam table2 yg berlainan ni..saya nak wat summary dan pengiraan utk elaun2 mkn ,kenderaan,lojing ,awam n pelbagai nanti...ni sumer berdasarkan kelas tuntutan user tu...takut nanti die bercampur dgn user lain punye data...tp xpe ke saya letak no kad pengenalan dalam setiap table??actually saya nak link kan terus pakai no kad pengenalan je...tp sbb ada byk table...takut nanti dia jadi redundan plak..lgpon nokadpengenalan tu bkan PK ...apa kata cikgu2 kat putera?? Quote Share this post Link to post Share on other sites
murinmalengko 0 Report post Posted February 21, 2007 Aku cadangkan ko hindari penggunaan aspmaker tu. Sebab nanti xdpt 'nikmat' coding. Unless memang dah last minute mm..actually mmg dah masuk fasa last minute dah ni...hehe...about one and half month to go and baper hari je lagi utk 1st review...xpe..nikmat coding still akan dirasai sbb sistem ni more pada application....waa...ni yg mentel ni..saya pilih utk guna aspmaker sbb senang nak control security die..lagipun dalam sistem saya ni ada 3 pihak...pemohon..pengesah..and admin...so view dorang lain2...rasenye kalo pakai aspmaker ni kat admin and pengesah tu dah xde masalah...generate then edit view je...tp kat pemohon ni yg susah banyak...camne tu camne ni.... Quote Share this post Link to post Share on other sites
ijurq 0 Report post Posted February 21, 2007 (edited) aku cdgkan..buatlah tableuser_profileuser_addressuser_contactbank_detailsbank_addressbank_contactbesar sistem ko ni...ce pecahkan lg table lain..tak paham la sistem ko sbb tu tak dpt nak bygkan...haha...bile databse ok..kang bab scripting senang je.. Edited February 21, 2007 by ijurq Quote Share this post Link to post Share on other sites
murinmalengko 0 Report post Posted February 21, 2007 database ko ni tak cukup normal..ce buat normalization....kalau nak buat sistem...kenal pasti la sape actor, ape role masing2....and sbb ko nye ni web based..ce ko buat satu activity flow ke..and then ko kena pasti ape data yg terlibat...baru nmpk ape jenis table ko nak pakai...ni pendapat aku la..mm..camne nak tau kitenyer normalization tu betul??normalization ni actually kite tgok ape??aktivity flow tu maknernyer ape akan berlaku mcm dlm DFD tu kan?masalahnye skrg dgn data..waa...fenin2...btw,thanks Quote Share this post Link to post Share on other sites
ijurq 0 Report post Posted February 21, 2007 Database Normalization When creating a database, it is often useful to learn from the mistakes of others. Within the Relational Database Model, a set of rules has been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is known as Normalization. In this Tutorial we will address the first of five normal forms, and the ways in which normalizing your database will help prevent problems as you add to it. The concept of database normalization is not unique to any particular Relational Database Management System. It can be applied to any of several implications of relational databases including Microsoft Access, dBase, Oracle, etc. The benefits of Normalizing your database include:• Avoiding repetitive entries • Reducing required storage space • Preventing the need to restructure existing tables to accommodate new data. • Increased speed and flexibility of queries, sorts, and summaries.There are five normal forms in all, each progressively building on its predecessor. In order to reach peak efficiency, it is recommended that relational databases be normalized through at least the third normal form. In order to normalize a database, each table should have a primary key field that uniquely identifies each record in that table. A primary key can consist of a single field (an ID Number field for instance) or a combination of two or more fields that together make a unique key (called a multiple field primary key). Quote Share this post Link to post Share on other sites
murinmalengko 0 Report post Posted February 21, 2007 aku cdgkan..buatlah tableuser_profileuser_addressuser_contactbank_detailsbank_addressbank_contactbesar sistem ko ni...ce pecahkan lg table lain..tak paham la sistem ko sbb tu tak dpt nak bygkan...haha...bile databse ok..kang bab scripting senang je..mm..ok..tu senang je..organize medan...rename balik...let see...x dpt bygkan ek...mmm....susah nak explain sbb saya pon xtahu sgt...ok..ni ade view dlm vb..apllication utk calculate mileage ni...cube tgok..maybe dpt bygkan betapa peningnye org yg kena buat ni...dah la baru belajar...tetibe kena wat sistem online plak tu..adeii...kalola bole wat application camni je kan senang...tp kena bukak buku vb balik..huhu....ni stand alone..dlm sistem saya tu ada pengesah...ada admin...dan ade pemohon...itu yg menjadikan die besar..actually kalo bg kat dewa2 dan profesor2 serta otai2 kat putera ni mesti kate nampak simple n senang je...kena kat saya ni...huhu...mmg jenuhlaa bukak buku n tanye org...ni die dah includekan dgn sample data...so...enjoy and pening2 kan kepala anda....hehe Quote Share this post Link to post Share on other sites
murinmalengko 0 Report post Posted February 21, 2007 Database Normalizationsaya dah try wat normalization pakai analyzer...rasenye saya dah faham sket...tapi saya x sure ape yg saya buat tu betul ke salah sbb hasilnye hanya nampak kat query...saya nak tanye...apa yg terjadi kalo sebenarnye database kite r/ship die MANY-TO-MANY???kite kena create bridge (junction table) jgk ek?saya bayangkan table saya ikut situasi ni...1 person in Employee table can take several courses,and the same course in the Courses table can be taken by several employees1 person in pemohon (Data Peribadi table) table can make several tuntutan,in the same tuntutan (Data Tuntutan Table) bole menuntut claims untuk several perjalanan (Data Perjalanan table) ,in the same Perjalanan can include several bayaran tol (Tol table) ke saya boleh teruskan je dgn database ni...pakai table2 yg saya dah linkkan tu? Quote Share this post Link to post Share on other sites
ijurq 0 Report post Posted February 22, 2007 kalau dah konfiden..guna je lah..sbb ko pon kata dah normalkan die....aku bole tolong takat ni...aku tak terer bab2 nih..kene tanya otai yg lainhappy scripting! Quote Share this post Link to post Share on other sites