Course aims:

Acquiring knowledge of design and web database management;
Acquiring knowledge of data organization according to the requirements of web communication, specific query;
Developing skills for dialogue between web technologies and databases;
Developing skills in validation databases using specific Web technologies..

Course Entry Requirements:

Databases course.

Course contents:

1. INTRODUCTION TO DATABASES 2. CLIENT-SERVER DATABASE STRUCTURES 2.1 Bi-dimensional databases 2.2. Redundant data in client-server applications 2.3. A comparison of client-server databases architectures 3. MODERN APPROACHES IN COLLECTING AND STRUCTURING DATA 3.1. Introduction to PHP object-oriented programming 3.2. Introduction to MySQL 3.3. PHP-MySQL database application development 3.4. The main MySQL commands 3.5. High level of application development and administration in DBMS 4. STANDARD TRANSACTIONS IN DBMS APPLICATIONS 5. SERVICE-ORIENTED ARCHITECTURE DESIGN 6. CLASSES AND COMPATIBILITES IN DESIGNING CLIENT-SERVER APPLICATIONS 7. CONFIGURATION OF CLIENT-SERVER APPLICATIONS WITH DBMS SUPPORT 7.1. Configuration of service-oriented client-server applications 7.2. Configuration of data mining oriented client-server applications 8. INFORMATION SCALABILITY 8.1 Information retrieval techniques in client-server applications 8.2 Information retrieval techniques by using JOIN method 8.3 Types of JOINS used in knowledge discovery in databases

Teaching methods:

Lecture, Power Point presentations, conversation, exemplification.

Learning outcomes:

The identification of base concept for organizing data in databases. The identification and explanation of base models for the organizing and management of data in databases. The development of various database related projects.

Learning outcomes verification and assessment criteria:

Written paper – final evaluation – 50%; continuous assessment Laboratory activities portfolio – 50%.

Recommended reading:

W. Jason Gilmore, Beginning PHP and MySQL From Novice to Professional, Fourth Edition, Apress, 2010, ISBN-13 (pbk): 978-1-4302-3114-1, ISBN-13 (electronic): 978-1-4302-3115-8., -, -, -, -.
Larry Ullman, PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition), 2011, ISBN-10: 0321784073, ISBN-13: 978-0321784070., -, -, -, -.
Williams E. Hugh; Lane, David, Web Databases. Applications with PHP and MySQL, O'Reilly and Associates, 2002., -, -, -, -.
Janet Valade, PHP and MySQL For Dummies, 4th Edition, 2009, ISBN: 978-0-470-52758-0., -, -, -, -.
Kroenke, David M, Database Processing: Fundamentals, Design & Implementation, New Jersey: Prentice Hall, 2000., -, -, -, -.