Week nine in the lecture

Week nine in the lecture.... In the account created on 000webhost... Create a ‘new person’ via the MySQL Database form

Alistairs lecture: the video lecture was most helpful and during the class lecture week nine I had the video open so I could scroll to the section in the video to refresh my memory as I cannot remember everything and I feel like I am an annoyance when I ask a question. All went well in the lecture and I was successful in setting up the database and making changes. Additionally the other students in the lecture seem to have much greater knowledge than I have and are most obliging and understanding by offering their assistance. Received feedback in class during week five being told I was doing was doing just fine and to continue same... I am quite perplexed by this subject and the way the feedback and marks are obtainable. Next week is week ten and I have no idea of what the benchmark is for this subject, the subject outline I have discovered is just a guide and has been changed at various times this is confusing matters even more.

Now let me do some reflecting on the lecture....

Reflecting of the databases they have useful properties, if I want to get stuff from my database to my user I need some sort of server side scripting language, php is an example of a language, via html or xhtml. Databases are absolutely everywhere...everything I log into I am dealing with a database. When I was working in the APO I was working on the uts CASS database, creating new subjects, courses ect... that were linked to the students through the course they were in rolled into. It was easy to have a table just dealing with the subject and the courses with another table dealing with the students information of ‘enrolment’ and ‘contact info’ using a foreign key to reference to the other table. Similarly a spreadsheet is very similar to a database it is used to create a table of data which creates an understanding of relationships of information and data. A row contains all the information of one person, a column these can also be called a field contain the information dealing with a section or topic.

Reflecting on the data types for example, work out latitude and longitude of different areas and using a specialised embed function

Reflecting on the relational databases, database showing relationships between different people and or things using methodical rows and columns

Reflecting on data Modelling a must read 1, 11, 111, the ‘databases from scratch’ on UTS online there No video lecture for next week 10

SQL (structured query language) lots of programming languages know about it example, php

CRUD: create read update delete... the acronym to remember what a SQL language can do.

Reflecting when I create a database I want to make sure I name the columns and rows memorable names so they are easy to find and remember, this is a way to make sure the database is organised and can be read easily. In the lecture slides there is examples of SQL data manipulation

Things to remember that if I go on the front end of my SQL database saying I can import a SQL text file which is made in text editor, I am using notepad ++ this is a shortcut, by making the file it has a list of command operations this will be very useful when I have a lot of things in your database. I will be able to export the database file in this format and then import it into another database if I ever decide to change webhost, great news... although I am not having too many problems with the 000webhost. It is taking me so long to cover the information, but I have gained so much knowledge.