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