Result: Izrada baze podataka servisa tramvaja ; Creating a Tram Service Database

Tema završnog rada je izrada baze podataka i aplikacije servisa tramvaja. Baza podataka je izrađena u Microsoft SQL Serveru, a aplikacija je izrađena u Visual Studio okruženju za Windows Form App platformu. Najprije je napravljen EV model servisa tramvaja, onda je po pravilima prevođenja EV modela u relacijski, napravljen relacijski model servisa tramvaja. Relacijski model sadrži 22 relacije. Svaka relacija ima svoje atribute. Relacije u relacijskom modelu predstavlju tablice u bazi podataka, a atributi predstavljaju stupce u tim tablicama. Baza podataka je napisana SQL programskim jezikom, a prototip aplikacije je napisan Visual Basic programskim jezikom. Prototip aplikacije ima windows forme za svaku tablicu gdje se prikazuju podatci iz baze podataka. Podatci se mogu mijenjati, brisati i mogu se dodavati novi podatci. ; The topic of the final thesis is the creation of a database and tram service application. The database was created in Microsoft SQL Server, and the application was created in the Visual Studio environment for the Windows Form App platform. First, the EV model of the tram service was created, then, according to the rules of translating the EV model into a relational model, a relational model of the tram service was created. The relational model contains 22 relations. Each relation has its own attributes. Relations in the relational model represent tables in the database, and attributes represent columns in those tables. The database is written in the SQL programming language, and the application prototype is written in the Visual Basic programming language. The application prototype has window forms for each table where the data from the database is displayed. Data can be changed, deleted and new data can be added.