We learnt about crud matrix today. We started with Crud first development, which means we took and entities and expanded on, from there Todd created a query to retrieve that piece of information and check if the username is in existence.
He then turned it into a Procedure.
We are learning this is this is a good way to plan out our project as it allows us to workout what funtions we need before we start planning things out
Some important notes from this is procedure have to start and ends with Delimiter which is what I missed about the first day work.
The crud matrix has a representing of what type of query is need to preform a specific action.
(C)reate = insert a record
(R)etrieve = Select
A schema is a way of making sure that we know the names of all of the different variables and there types.
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.
In this class, we have learnt what we need to do to complete the required project.
We have learnt this so we can start working on and planning our project.
We have gained this knowledge by getting into groups and explaining the assessment to the rest of the class.
For this project we will be creating a simplistic project, where multiple players can access a game and interact with each other.
The entire project has to be saved to a database created with mySQL.
We have limited time to complete this project, so we need to build a simple game.
Because we are constantly updating a database, this will slow down the program. We need to think about the latency between different players. I believe it would be a good idea to focus on a board game style project, to be able to work around latency.
Some of my ideas for games include a simplified version of “Pokemon Master Trainer”, a Multiplayer game based on “Nine Men’s Morris, a multi-laned version of “The Royal Game of Ur” or a simplified version of “Stratego”, where players have to protect a flag from other players.
I have chosen to select the multiplayer version of Nine Men’s Morris, as games such as Pokemon Master Trainer are too complex and The Royal Game of Ur is too abstract to adapt to a fun multiplayer game.
Here are the rules for the my game:
Strategic Hot Fairy’s
The goal is to have a score that is a certain amount larger than the other players’ scores. Each player takes turns adding or moving their piece on the board. When a piece is moved, the player gains a point. If a piece can’t move or has a piece on either side, that piece’s player loses half their total points and their piece is removed from the board. If the player’s piece was caught between two pieces, those two pieces’ controllers each gain half the point that the other player lost.
Allan Fry Year 2-3 