Database 2559

Database Side http://db5720128.blogspot.com/2017/05/project.html Web Application http://db5720128.blogspot.com/2017/05/project-main-features.html

https://youtu.be/Rtbj65NbYHg  Link for Youtube Presentation Other Week  http://b2-5720128.blogspot.com/

What have you done? Create a web app to query your data (CRUD?) work in group of 3 choose a language ( Java, Python, PHP, C#, ...) Any problem / solution ? No problem Decision ? No Decision Making Related info/Link/Reference ? Question :  http://db2559.blogspot.com/ DBMS : MySQL , MariaDB Server :  https://www.apachefriends.org/index.html Fundamentals of Database Systems, 6th Edtion  by Ramez Elmasri, Shamkant B. Navathe

What have you done? Add Data to another DBMS Any problem / solution ? take to long to import lots of data in to DBMS So import Only 10000 data Decision ? No Decision Making Related info/Link/Reference ? Question :  http://db2559.blogspot.com/ DBMS : MySQL , MariaDB Fundamentals of Database Systems, 6th Edtion  by Ramez Elmasri, Shamkant B. Navathe

What have you done? Insert Data to DBMS Meaningful Query Any problem / solution ? No problem this week Decision ? Add My Own Attribute Related info/Link/Reference ? Question :  http://db2559.blogspot.com/ DBMS : MySQL Fundamentals of Database Systems, 6th Edtion  by Ramez Elmasri, Shamkant B. Navathe

What have you done? Use 7 Step convert ER Diagram Any problem / solution ? No problem this week Decision ? No Dicision Making Related info/Link/Reference ? Question :  http://db2559.blogspot.com/ Fundamentals of Database Systems, 6th Edtion  by Ramez Elmasri, Shamkant B. Navathe

What have you done? Draw ER Diagram Any problem / solution ? No problem this week Decision ? Add My Own Attribute Related info/Link/Reference ? Question :  http://db2559.blogspot.com/ Fundamentals of Database Systems, 6th Edtion  by Ramez Elmasri, Shamkant B. Navathe

What have you done? Import grade.csv in to DBMS !! Answer Some Question in MY DBMS Import grade.csv in to DBMS (MySQL)  Imported Grade Table Any problem / solution ? No problem this week Decision ? not using command line Related info/Link/Reference ? Question :  http://db2559.blogspot.com/ Learninng Website :  http://www.w3schools.com/sql/default.asp Question that my table can answer What Subject Did u get a B Grade? ( Any grade ) What Subject is in First Semester ? ( Any Semester ) What Subject is in First Semester and get A Grade ? Post '-' is not accept as the same word in column name Ex. Year-Semester can not use in MySQL        Use 'Year-Semster' instade

What have you done? Learn some SQL syntax from w3school website Query Result Any problem / solution ? Problem : New to MySQL workbench Solution : Search on internet Decision ? Use example database for Query Related info/Link/Reference ? Question : http://db2559.blogspot.com/ Learninng Website :  http://www.w3schools.com/sql/default.asp Post SQL : Structed Query Language is use to communicate with database

Week 2-2 - download DBMS MySQL Download Link Install Step 1 Step 2 Step 3 Step 4 Step 5 Step 6

Week 2 - export your grades/data from spreadsheet  to .csv format - write a program to read the . csv file  and calculate your GPA What have you done? Program for Calculate GPA CLICK HERE !! Any problem / solution ? Problem :  First spread sheet format not suit with python Solution : Create a new format Problem : Thai Language not support with python Solution : Change to English Word Decision ? Make new Column which tell year that register this subject Related info/Link/Reference ? Question http://db2559.blogspot.com/ Information http://klogic2.kmutnb.ac.th:8080/kris/index.jsp Web to run code https://c9.io/