Web Programming and Data ManagementLaajuus (15 ECTS)

Objective

Having passed the unit the student understands the use of databases as parts of information systems. The student is able to design and implement a relational database. The student is able to use and administer the database with a manipulation language. The student is able to create applications that store and retrieve persistent data in a database using different techniques including standard ORM solutions.

The student is able to implement a web-application using MVC-pattern. The student is able to implement the client side and the server side, and understands secure communication between them.
Having passed the unit the student has the command of most important concepts and methods of discrete mathematics as well as skills to use them in the context of software engineering

Content

Client-side programming:
•HTML5, CSS, and JavaScript.

Server-side technologies and communication:
•Java or PHP, HTTP
• REST, JSON and XML
•Web programming frameworks


Data management:
•Data models and information systems
•Conceptual modelling.
•Relational algebra and relational model, Normalization.
•Principles of relational databases.
•Implementation of a relational database, Data definition language, Data manipulation language, SQL.
•Query processing
•Indexes and integrity
•Transactions and management of concurrency

Discrete mathematics:
•Sets and relations
•Algebraic structures
•Boolean functions
•Logical calculus
•Combinatorics
•Basic probability theory
•Graphs and trees

Assessment criteria, satisfactory (1)

The student is able to implement a web-application using MVC-pattern.

The student has a basic command of relational databases. The student understands principles of discrete mathematics.

Assessment criteria, good (3)

Student is able to implement a MVC-pattern based web-application in which secure aspects are considered. The student is an active and collaborative team member and achieves the goals of the project.

The student can manipulate and design relational databases for web applications.

The student is able to apply discrete mathematics in software engineering.

Assessment criteria, excellent (5)

Student is able to implement an advanced web-application using MVC-pattern. Student is able to implement the client side, the server side and communication between them in a secure way.

The student is an innovative member of the project team and his/her contribution to the project is essential. The student masters discrete mathematics for engineering and has a deep understanding of data base management systems.

Assessment criteria, approved/failed

The student is able to implement a web-application using MVC-pattern.

The student has a basic command of relational databases. The student understands principles of discrete mathematics.