WEEK 11 & WEEK 12

WEEK 11

     This week , the lecture continues with select statement. the select statement retrieve information from only one table. the function of using distinct is when you decided to eliminate any unnecessary or duplicate data inside the table. For example : SELECT stuId, sName, lastName; // choose the selected attributes

     FROM STUDENT; // from which table

next, miss Emy decided to do some exercise on normalization part because most of us having problem and difficulties in understanding this topic.

in lab, we continue doing the EXHIBITION database using mySQL and learn to write select statement.

WEEK 12

     

     For this week, Madam Emy managed to finish the final chapter the select statement for multiple table in SQL. it is a bit similar to single table.For lab session, we continue the the last week topic but we need to insert the select statement multiple table inside the coding. Madam Halima really taught us really untill we could do the codings , she even insisted that we could call her and ask whatever we want just to ensure we are clear about whats happening in the lab always.