Class 2

This post is based on the 7/5/19 Dat602 class.

We have learnt about what a CRUD matrix is!

We learnt this because it is important for transitioning from screen designs to a program which properly communicates with a database.

A CRUD table is a table based on the screen designs we create. It stands for Create, Read, Update, Delete.

///// The table/matrix contains the events which we can expect to happen based on a screen design and how the date base will be changed based on this action. ////

We use 127.0.0.1 as the address for running a local database. This is the address that needs to be enter as we create the database. This will be useful in the future , as we will probably use the same loopback address.

“ Back quotes are used to be able to bypass a reserved word and name a column after that word. However this is not recommended, as it could create confusion. I would only use this when I am facing errors and trying to isolate the problem or if I am in a situation where a column needs a specific name.

I found that back quotes do not work when you try and insert information into the table.

I couldn’t keep up with the second part of the work, so the program isn’t functional. I will need to look into this in my own time to try and make it work.