Database Week 4
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