• how to create a table using SQL and PhpMyAdmin
• explain what an index is and why it is used
• explain what a foreign key is and why it is used
• understand the concepts behind database normalization and 1NF, 2NF and 3NF
• explain relationships in a database
• create and use primary keys and foreign keys

I have to admit I’ve had a hard time dealing with this week’s issues. First of all, I had a domain problem and I had to buy a new domain. I had a problem with the codes while connecting. so instead of learning the subjects easily in 1 week, I’ve been learning for the last 3 days. But when the code link was made, I had the chance to understand many subjects.

This is the minimum requirement for each weekly entry for the first half of class:

• A quick summary of the topics learned for the week.
  • I learnt how to connect webserver and vs code. And to use Sql database and create user, password for every user and their specific info. And how to take information from this table.
• Links to your lab and homework assignments with a reflection on the process.
• This links belongs to my assignment Lab6
  • What was easy?
    • Create Sql data table was easy.
  • What was challenging?
    • List_user.php connection was challenging because I missed some semicolon.
  • Any “A-HA” moments?
    • When I saw my table on internet.
  • Anything that is coming together from other courses or experiences?
    • Yes, if you don’t have at least basic knowledge you can’t understand what is going on. Java class was helpful to formulas. And “Access” “excel”.
  • What did you like best about your work?
    • Not specific but when i saw it work, I like it.
  • What do you think you can improve upon?
    • More Practice for formulas.