Database management systems [DBMS] 1 st lecture [2016 feb. 12] Introduction to the course

1. Database management systems [DBMS] 1st lecture [2016 feb. 12] Introduction to the course dr. R. Pranaitis

2. DBMS course link http://web.vu.lt/kf/r.pranaitis/wordpress

3. Aim, Competences, Learning outcomes, Study methods, Assessment, Content of course unit. Syllabus

4. Aim, competences > To obtain DBMS basic knowledge, designing and realization skills at constantly renewing modern ICT (MICT) conditions. > To analyse database (DB) needs,creating a DB conceptual model and 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. “At constantly renewing modern ICT conditions”? What does it mean? It means today's ICT features: > Online DBMS, > Real free Hosting, > Constantly renewing online sources, e.g. www.w3schools.com, > theory <> practice, > etc. Syllabus

5. 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 be able to use them in creating and using databases. > Understanding the database 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. Syllabus

6. Assessment: I colloquium [beg. of march][ test, moodle] II colloquium [beg. of may] [test, moodle] . 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. Syllabus

7. What is database? What is database management system? What database technologies do you know? What databases are most perspective? What is SQL? How PHP technology is connected with databases? Do you have practical experience of working with databases? What? How much? What is content management system? What is MySQL? What is difference between databases and spreadsheets technologies? What is destination of primary key? What is destination of foreign key? What themes of this course are important for you? What is database normalization? What is conceptual modeling? When it is important? Do you feel lack of ICT knowledge? What? Do you like to work independently (by your own)? Have you job experience? Why did you selected this DBMS course? What are your expectations from this course? What are your interests, proposals? Your speciality, course, name, surname? Send, please, answers to lecturer: regimantas.pranaitis@ff.vu.lt DBMS, initial survey

8. 1. CMS (with DBMS) implementation and demo [feb-mar] a. Signup for free hosting; b. Install Wordpress (5 min. installation); c. Analyse WP features and demo; d. Publish workflow description (context). 2. Online DBMS user interface creation and demo [mar-apr] a. Acquaintance with SQL, MySQL, PHP, phpMyAdmin, etc.; b. Create PHP-MySQL junction, demo and publish results; c. Create PHP-MySQL interface, demo and publish results. 3. Online database project [apr-may] a. Actual DB theme selection (what online database you would like to create?); b. Facts finding (establishing database needs); c. Database planning (DB needs analysis, conceptual and relational DB modeling); d. Database realization, demo, publishing of results and workflow description. Problem based learning Savarankiškumas Adaptation, correction of tasks to personal needs Simple, non complex solution DBMS, tasks

9. What additional tools do we need to carry out the tasks? For the 1st task [feb-mar] Free Host? > e.g., http://byet.host/ (+support) Wordpress? > http://wordpress.org (+support) For the 2nd task [mar-apr] SQL queries? > lectures, practice, etc. [e.g., http://www.w3schools.com] PHP min.? > lectures, actualities, practice, etc. [e.g., http://www.w3schools.com] MySQL, phpMyAdmin? > practice, etc. [e.g., http://www.w3schools.com] .. For the 3rd task [apr-may] How to plan DB? > lectures, practice, etc. How to realise DB? > 1st and 2nd tasks results, etc. DBMS [tasks]

10. For the 1st task: Free Host? > e.g., http://byet.host/ (+support) Wordpress? > http://wordpress.org (+support) DBMS [1sttask]

11. One of the most modern technologies> Constantly renewed, > Dynamic webpage, > Based on online working DBMS, i.e. MySQL. We will use Wordpress for > Publishing results of this course, > Monitoring how online DBMS works, > it is a model of modern online DBMS, > etc. Wordpress [CMS]

12. Preparing for practice [2016 feb 12, 11am] 1st task.

13. Questions?