E-exams: Database model and business rules implementation using Oracle ADF

U radu je prikazan model baze podataka „e-ispiti“ za potrebe TE Plomin kojim bi se olakšao proces izvođenja ispita iz zaštite na radu i koji se opisuje kroz tri faze oblikovanja, konceptualnog, logičkog i fizičkog. Prije same izrade konceptualnog modela baze podataka potrebno je utvrditi korisničke zahtjeve, a zatim u konceptualnom dijelu na temelju njihove analize utvrditi entitete, veze i njihove atribute te izgraditi E-R model. Na taj način se dolazi do relacijske faze oblikovanja u kojoj se svaki tip entiteta iz E-R modela prikazuje jednom relacijom dok njegovi atributi postaju atributi relacije. Također su definirana i poslovna pravila koja omogućuju funkcionalnost baze podataka, a dio programske logike se rješava u samoj bazi kako bi se smanjila opterećenost aplikacije. Nakon toga je opisana arhitektura ADF-a te je u sloju poslovnog servisa, ADF Business Components, izrađen model u kojem su na deklarativan način implementirana poslovna pravila.The Thesis presents an „e-tests“ database model for the purpose of Plomin Power Plant in order to facilitate the examination process concerning security at work, and which is described throuh three framing phases, the conceptual, the logical and the phisycal. Before drafting of the conceptual database model user's requirements should be established, and afterwards in the conceptual part on the basis of theirs analysis their entities, connections and attributes should be determined as well as developed the E-R model. This leads to a relational phase of formation in which every type of entity from E-R model is presented by one relation whilst its attributes became relation's attributes. In addition business rules that ensure the data base functionality are also defined, and part of the programming logics is solved in the sole base in order to minimize the application burden. Subsequently the ADF architecture is described being in the class of business service, ADF Business Componenets, a developped model in which the business rules are implemented in a declarative way