Προβολή πηγαίου κώδικα για τη σελίδα Database Systems and Web Applications Development (MAE741)

[[Undergraduate Courses Outlines]] - [https://math.uoi.gr  Department of Mathematics]

=== General ===
{| class="wikitable"
|-
! School
|
School of Science
|-
! Academic Unit
|
Department of Mathematics
|-
! Level of Studies
|
Undergraduate
|-
! Course Code
|
MAE741
|-
! Semester
|
7
|-
! Course Title
|
Database Systems and Web applications development
|-
! Independent Teaching Activities
|
Lectures-Laboratory (Weekly Teaching Hours: 3, Credits: 6)
|-
! Course Type
|
Special Background
|-
! Prerequisite Courses
| -
|-
! Language of Instruction and Examinations
|
Greek
|-
! Is the Course Offered to Erasmus Students
|
Yes
|-
! Course Website (URL)
| https://spooky.math.uoi.gr/eclass
|}

=== Learning Outcomes ===
{| class="wikitable"
|-
! Learning outcomes
|
Students knowledge acquisition of design, implementation procedures and methodologies using Relational DataBase Management Systems (RDBMS), as well as familiarity with the development of Internet programming applications using PHP, JavaScript, jQuery and AngularJS.
<br/>
Basic Internet programming concepts HTML, CSS, Database relationships, tables and structure. Concepts and architecture of Database Systems, Relational model, Internet programming languages and Tier System architecture. Data Modelling using the relational SQL Database Language MariaDB, SQL Queries, Normalization, Normal forms, Non relational Databases - MongoDB. Databases on the Internet using programming languages, PHP programming language, using PHP for mathematical problems, using MySQLi Api, Bootstrap, Introduction to JavaScript, AJAX, JSON and jQuery.
|-
! General Competences
|
* Data search, analysis and synthesis using Information Technologies
* Decision making
* Project design and implementation 
* Working independently
|}
=== Syllabus ===
# Data models with emphasis on relational model. Introduction to relational algebra and relational calculus. Conceptual Models: Entity-Associations Model. Theory of dependencies. Form normalization (1NF, 2NF, 3NF, BCNF). Database design. Introduction to Database Management Systems.
# SQL language with practical application using MariaDB. Create tables, modify fields, add records to a table, Database tables management.
# Create basic SQL queries in MariaDB tables.
# SQL joins, SQL table associations-relations, foreign keys, stored procedures, triggers.
# Introduction to the web and its capabilities. Web page development. Basic HTML content formatting commands, Add images, create tables, lists and frames, HTML layers, divs HTML 5 additional commands.
# HTML and content formatting using Cascading Style Sheets (CSS). Advanced ways of responsive formatting using the Bootstrap library.
# Introduction to JavaScript, ways to import JavaScript into HTML, JavaScript DOM, functions and classes.
# Introduction to PHP, basic language capabilities, input output, data types, conditions, repetitive loops.
# Create forms in HTML and retrieve form information using PHP and JavaScript (AJAX), using GET, POST methods.
# Use of PHP and MySQL, presentation of PHP input functions and retrieval of information from DB tables. (mysqli-PDO api). Creating dynamic web pages.
# Mathematical extensions of PHP, PHP and data processing from DB to solve linear equation problems, presentation of the PHP-LAPACK class.
# Mathematical extensions of PHP, PHP and statistical data processing from DB, presentation of PHP statistical functions.
# Asynchronous communication with DB, PHP and AJAX, using the jQuery library and JSON configuration. Presentation and use of AngularJS and NodeJS frameworks.

=== Teaching and Learning Methods - Evaluation ===
{| class="wikitable"
|-
! Delivery
|
Classroom
|-
! Use of Information and Communications Technology
| Use of Micro-computers Laboratory
|-
! Teaching Methods
|
{| class="wikitable"
! Activity
! Semester Workload
|-
| Lectures
| 39
|-
| Working Independently
| 78
|-
| Exercises-Homework
| 33
|-
| Course total 
| 150
|}
|-
! Student Performance Evaluation
|
* Using new ICT and metrics of the asynchronous e-learning platform (5%)
* Examination of laboratory exercises (10%)
* Semester work and written examination
|}
=== Attached Bibliography ===

See the official [https://service.eudoxus.gr/public/departments#20 Eudoxus site] or the [https://cloud.math.uoi.gr/index.php/s/62t8WPCwEXJK7oL local repository] of Eudoxus lists per academic year, which is maintained by the Department of Mathematics. Additionally:
* PHP 6 AND MYSQL 5 FOR DYNAMIC WEB SITES, 5 Edition, LARRY ULLMAN, ISBN-13: 978-0134301846, 2018.
* JAVASCRIPT & JQUERY interactive front-end web development, Jon Duckett, ISBN-13: 978-1118531648, 2017.