Web-aplikacija za usporedbu novih automobila temeljem omjera cijene i vrijednosti

undergraduate thesis

• Title (english): A web-application to compare new cars based on price to value ratio
• Author: Ivan Cottiero
• Mentor: Boris Milašinović (mentor)
• Committee member: Boris Milašinović (predsjednik povjerenstva)
• Committee member: Ivan Budišćak (član povjerenstva)
• Committee member: Petar Djerasimović (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2016-09-21, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Cilj ovog rada je izrada aplikacije sa bazom podataka koja sadrži informacije o
dostupnim automobilima u prodaji i izvedba napredne pretrage tih podataka. Baza
je realizirana tako da omogućava funkcionalnosti koje pojednostavljuju upis podataka
o dostupnim automobilima: nasljeđivanje paketa, više opreme na paketu, nekompatibilna
oprema i više motora u paketu koji odred¯uju konacˇnu cijenu. Web-aplikacija
ostvarena je u ASP.NET MVC tehnologiji, a za spajanje na bazu korišten je Entity
Framework.
Tražilica nudi više opcija pretrage. Korisnik određuje koje elemente opreme automobil
mora obavezno imati, a koji elementi su mu opcionalni. Ukoliko je potrebno,
korisnik može definirati i dodatne filtere: minimalnu i maksimalnu cijenu, vrstu automobila,
vrstu motora i broj vrata. Sustav obaveznu opremu i dodatne filtere opremu
koristi za filtriranje kroz pakete u bazi podataka, a izbornu opremu i konačnu cijenu
koristi za računanje težinske vrijednosti.
Ovim projektom realizirana je jezgra aplikacije, no ukoliko bi se trebalo aplikaciju
objaviti bilo bi potrebno dodati još bitnih funkcija. Samo neke od njih su: korisnički
računi, ograničen pristup bazi, automatizacija popunjavanja baze novim podacima.

Abstract (english)

This Bachelor thesis analyzes the procedure of creation of a web-application with a
database that contains information about new cars avalible on the market that features
an advanced search method. Database is built with some key functionalities that allow
easy and straight-forward data input: package inheritance, incompatible car features,
avalibility of multiple car engines per package, car price based on engine and feature
package. Web-application is built using ASP.NET MVC. For database connection purposes
it uses Entity Framework.
Search engine features multiple search options. User defines obligatory features
alongside with optional features. If needed, user can define additional filters: minimum
and maximum price, car type, engine type and door number. Search engine uses user defined obligatory features and additional features to filter through packages in the
database. Optional features and total price is used for calculating weight value of the
package, which is then used to rank filtered car packages based on their optimal feature
to price ratio.
This project created the core of the application. But, before this application could
be published, some crucial features like user accounts and restricted database access
must be implemented for it to function correctly and succsessfully.

• Keywords: automobili; pretraga; SQL; baza podataka; MVC; ASP.NET; Entity Framework
• Keywords (english): cars; search; SQL; database; MVC; ASP.NET; EntityFramework
• Language: croatian
• URN:NBN: urn:nbn:hr:168:408689
• Study programme: Title: Computing; Study programme type: university; Study level: undergraduate; Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2018-02-06 08:12:14