Course INFO 212 · Year II · Summer 2020-2021

DATABASE MANAGEMENT SYSTEMS

Compulsory course in Computer Science, taught by Maria Viorela Muntean.

This course page is from 2020-2021 and is archived.
See this course for the current academic year

Overview

Lecturer
Maria Viorela Muntean
Seminar tutor
Maria Viorela Muntean
Type of course
Compulsory
Language of instruction
English
Erasmus language
English
Domain
Computer Science
Field of study
Computer Science
Form of education
Full-time
Form of instruction
Class
Credit awarded by
Grade
Teaching methods
Lecture, Power Point presentations, conversation, exemplification.
Entry requirements
Databases 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 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

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.

Assessment

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

Recommended reading

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.
W. Jason Gilmore
-, -, - · -
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition), 2011, ISBN-10: 0321784073, ISBN-13: 978-0321784070.
Larry Ullman
-, -, - · -
Web Databases. Applications with PHP and MySQL, O'Reilly and Associates, 2002.
Williams E. Hugh; Lane, David
-, -, - · -
PHP and MySQL For Dummies, 4th Edition, 2009, ISBN: 978-0-470-52758-0.
Janet Valade
-, -, - · -
Database Processing: Fundamentals, Design & Implementation, New Jersey: Prentice Hall, 2000.
Kroenke, David M
-, -, - · -