DBMS

3.25 > 1st colloquium test /WP+SQL+DBMS.intro/
About preparation for the test > here

module: DBMS
Syllabus > Initial survey > Tasks > Lectures&practices > Results

 

Aim, competences
The aim of the course is to provide relational database management systems (DBMS) basic knowledge and relational database (RDB) designing and realization skills at constantly renewing modern ICT (MICT) conditions. To develop the capacities to carry out analysis of database (DB) needs, capabilities to create a DB conceptual modeland it’s realization with relational DBMS (eg. MS Access or PHP-MySQL) and skills of working with SQL queries. Various studying techniques are combined – lectures, seminars, consultations and individual work. In all stages of the study – both during the selection and formulation of tasks, as well as presenting results for the audience and publishing them in a personal website – student problematic attitude, teamwork, independence is promoting.

Learning outcomes
Understanding the peculiarities of the development of databases and the ability to assess their perspective. Understanding the relational database theory and principles and beable to use them in creating and using databases. Understanding the data-base needs finding and analysis peculiarities and ability to create database conceptual model and turn it into relational. Ability to form and demonstrate various SQL queries. Ability to create, improve and publish a personal website on the base of modern ICT. The ability to analyze modern ICT, to evaluate their relevance and perspectivity under extremely rapid renewal of modern technologies. Understanding the peculiarities of database management systems and be able to solve problems, connected with modelling and realization of relational database. Understanding PHP and MySQL destination and application possibilities and be able to demonstrate it by creating a dynamic website.

Study methods
Involving lectures, problem based teaching, examples analysis, independent work. Evaluation methods Colloquium, exam tests (closed-ended questions). Tasks results (published online).

Assessment:
I colloquium [beg. of march][test, moodle]
II colloquium [beg. of may][test, moodle]
Cummulative score [end of may]

The assessment takes into account the ability to give meaning, optimize and convincingly defend the tasks results and ability to use them for professional purposes. The cumulative score principle is used.

Accumulative score formula:
the cummulative score = 0.5*knowledge + 0.5* skills
(knowledge – colloquiums results mean; skills – mean of published online and defended results)

Exam: Examination could be carried out only after initial quiz and colloquiums are passed and all tasks results are presented, published and evaluated positively.
End-point formula: final score = 0.6*cumulative score + 0.4*exam score.

lectures

1. Introduction to the course. [2+1 acad. hours]
   Aims, tasks and dead lines. Studying process and evaluation system. Recomended literature and online sources, etc. FIrst task – settling on the web. Content management system with database. WordPress.
   • Individual tasks.
     Course initial survey. Acquaintance with the course unit description, proparing for discussion. Learning sources finding. Settling on the web (first task).
2. DBMS technology. [2+1 acad. hours]
   Relational database management systems (DBMS) problematics. DBMS main features, evolution and perspectives.
   • Individual tasks.
     Settling on the web. WordPress installation and usage.
3. DBMS technology. [4+2 acad. hours]
   Relational database model features. Kodd’s rules. Relational DBMS architexture. Object database manifesto. Database life cycle.
   • Individual tasks.
     Wordpress usage and possibilities demo. WordPress actuality (theme selection, needs finding).
4. SQL, PHP, MySQL technologies. [8+4 acad. hours]
   Structured query language (SQL). SQL commands, syntax. Different queries axamples analysis. Relational algebra and relational calculations – SQL basis. PHP-MySQL connection and interface analysis.
   • Individual tasks.
     Wordpress actuality (presenting, publishing). Different SQL queries formation and demo. PHP-MySQL connection and interface creation, demo. Preparing for the first colloquium.
5. Database planning. [4+2 acad. hours]
   Logical database design. Database needs identification and analysis, conceptual modelling principles and examples.
   • Individual tasks.
     PHP-MySQL actuality (theme selection, needs finding and analysis). Database project (theme selection, needs identification and analysis).
6. Database planning. [6+3 acad. hours]
   Conceptual model conversion into relational. Database normalization.
   • Individual tasks.
     PHP-MySQL actuality presenting and publishing.
     Database project. (needs analysis, conceptual model, relational model, realization).
     Preparing for second colloquium.
7. Database realization. [4+2 acad. hours]
   Database physical design. Online DBMS specifics (MySQL, phpmyadmin, etc.).
   • Individual tasks.
     Database project realization, publishing online, demonstration.