Database model for computer service : Final paper

Računalni servisi nude široki spektar usluga koje uključuju popravak računala, prodaju gotovih računala ili pak sastavljanje računala od komponenti koje klijent zatraži. U ovakvim procesima često sudjeluje dokumentacija poput radnog naloga, potvrde o zaprimanju opreme, izvještaja o dijagnostici, ponude za popravak, potvrdi o popravku, računa, te potvrde o preuzimanju popravljene robe. Pet računalnih servisa u Osijeku bilo je posjećeno u sklopu primarnog istraživanja, koje je uključivalo prikupljanje radnih naloga iz svakog od servisa, te se nakon obavljenog kratkog intervjua sa svakim od zaposlenika određenog servisa došlo do zaključaka o strukturi procesa koji se odvijaju u računalnim servisima u Republici Hrvatskoj te o obuhvatu podataka koji treba sadržavati optimalna relacijska baza podataka računalnog servisa. U tu svrhu su prikupljeni i analizirani obrasci radnih naloga koji se koriste u računalnim servisima. Temeljem sagledanog podatkovnog obuhvata definirani su entiteti i pripadajući atributi. Relacijska baza podataka modelirana je metodom sinteze, a uočene nekontrolirane redundancije otklonjene su upotrebom vertikalne normalizacije. Optimalan model relacijske baze podataka za računalni servis kreiran je i testiran upotrebom Oracle-ovog relacijsko sustava za upravljanje bazama podataka MySQL Server u trenutnoj verziji 8.0.33. Uz teorijsku vrijednost kreirani model ima i praktičnu vrijednost jer može poslužiti poslovnim subjektima koji se bave razvoje programskih aplikacija kao osnova u razvoju programskih rješenja namijenjenih radu računalnih servisa.Computer services offer a wide range of services that include computer repair, sale of ready-made computers or assembly of computers from components requested by the client. Such processes often involve documentation such as a work order, receipt of equipment, diagnostic report, repair offer, repair certificate, invoice, and receipt of repaired goods. Five computer services in Osijek were visited as part of the primary research, which included the collection of work orders from each of the services, and after a short interview with each of the employees of a particular service, conclusions were reached about the structure of the processes that take place in computer services in the Republic of Croatia and about the scope of data that should be contained in the optimal relational database of the computer service. For this purpose, work order forms used in computer services were collected and analyzed. Entities and associated attributes are defined based on the observed data scope. The relational database was modeled using the synthesis method, and the observed uncontrolled redundancies were removed using vertical normalization. The optimal relational database model for computer service was created and tested using Oracle's relational database management system MySQL Server in the current version 8.0.33. In addition to the theoretical value, the created model also has a practical value because it can be used by business entities involved in the development of software applications as a basis in the development of software solutions intended for the operation of computer services