Academy of Technical and
Art Applied Studies Belgrade

Programming Database Applications Course code: 317210 | 8 ECTS credits

Basic information
Level of Studies:
Year of Study: 2
Semester: 3
Requirements: Knowing the basic concepts of object programming and SQL language.
Goal: Train students with the basics of programming with a databases. Acquire practical knowledge in programming and designing database applications.
Outcome: Students are taught to project and program basic applications based on relational databases using object and model based on classes and entities.
Contents of the course
Theoretical instruction:
  1. Introductory lecture. Course program, organization and course content. Basic terms.
  2. Application elements. MVC or MVVM architecture.
  3. Basic component design.
  4. Complex applications and connecting components.
  5. Connecting views and data. Property and event properties.
  6. Conditional display techniques.
  7. Osnovne komponentnog načina projektovanja. Složene aplikacije i povezivanje komponenata. Povezivanje prikaza i podataka. Osobine svojstava i događaja. Tehnike uslovnog prikaza. Detalji rada sa komponentama Nove tehnike objektnog pretraživanja podataka. Uvod u objektno mapiranje. Izmena modela entiteta. Transakcije. Primeri modelovanja entiteta u odnosu na tabele u bazi. Izrada Internet aplikacija zasnovanih na MVC arhitekturi i objektnom modelu podataka. Primena tehnike modelovanja najpre iz koda ili iz baze. Prikaži više 507 / 5000 Rezultati prevoda Basic component design. Complex applications and connecting components. Connecting views and data. Property and event properties. Conditional display techniques. Details of working with components
  8. New Object Data Search Techniques.
  9. Introduction to object mapping.
  10. Modifying the entity model. Transactions.
  11. Examples of modeling entities in relation to tables in the database.
  12. Development of Internet applications based on MVC architecture and object data model.
  13. Apply modeling techniques first from code or from a database.
Practical instruction (Problem solving sessions/Lab work/Practical training):
  1. Working in a development environment. Updating the database through forms-based applications.
  2. Queries and data delivery.
  3. Use complex controls to obtain and update data.
  4. Using the DataSet as a data model on the landing page.
  5. Use of relations in the design of the user interface.
  6. Event handling and validation of data.
  7. Use of LINQ.
  8. Creating a report. Link report data.
  9. Creating EF-based applications. Practical application of LINQs to supply data.
  10. Modifying the entity model. Display data in controls.
Textbooks and References
  1. C. Smith, M. Amundsen, Programiranje baza podataka za 21 dan, Mikro knjiga, 2002.
  2. Hassan Djirdeh, Nate Murray, and Ari Lerner, Fullstack Vue The Complete Guide to Vue.js and Friends, Fullstack.io 2018
  3. John Ciliberti, ASP.NET Core Recipes A Problem-Solution Approach, Apress 2017
  4. A. Boehm, G. Mead, Murach's ADO.NET 4 Database Programming with C#, 4th edition, Murach 2010
  5. Z. Ćirović, Programiranje aplikacija baza podataka, ATUSS 2019, Beograd
Number of active classes (weekly)
Lectures: 4
Practical classes: 3
Other types of classes: 0
Grading (maximum number of points: 100)
Pre-exam obligations
Points
activities during lectures
5
activities on practial excersises
5
seminary work
0
colloquium
60
Final exam
Points
Written exam
0
Oral exam
30