DAT Blog Post 3

Week Three Sessions 3-4

What Have I Learned?

This week I learned about SQL procedures and how to implement them into my database. I learned about the basic procedures which are SELECT, FROM, WHERE, JOINS, FOREIGN KEY, PRIMARYKEY, and some different data types. I also learned about what storyboards and CRUD tables are and how we implement them.

Examples:

INSERT INTO `tbl_asset` (`asset_name`, `asset_type`, `asset_value`) VALUES('Sword', 'Weapon', 999);

DROP TABLE IF EXISTS `tbl_board`;
CREATE TABLE `tbl_board` (
	`boardID` INTEGER NOT NULL AUTO_INCREMENT,
	`gameID` INTEGER NOT NULL,
	PRIMARY KEY (`boardID`),
	FOREIGN KEY (`gameID`) REFERENCES `tbl_game`(`gameID`) ON DELETE CASCADE  
);

UPDATE `tbl_user` SET `user_password`='123', `user_email`='email@email', `user_accountStatus`=false, `user_isAdmin`=true WHERE `userID`='5';

---

Why Have I learned This?

I believe that I have learned this as these procedures are key when create our databases and want to retrieve or manipulate data. These will come in very useful when It comes to coding our game and for our first milestone hand in. I also believe that these will b e very useful in future projects as well.

Storyboards give a good representation of how our system works and what actions happen when we do a certain task such as where a button takes us. These also give other users a walkthrough of the purpose of each of the screens we have designed.

Example:

CRUD tables are visual way of showing what tasks our system performs and how it interacts with our database. I believe that these are useful as it helps plan out what is required when it comes to writing queries to perform a certain task. When it comes to making the game, I can use it as a checklist to see if I have completed all the tasks that my system performs and does the required statements.

Example:

---

How Have I learned This?

I learned this by researching into how each of the procedures work and the purpose of each one. I looked at the default syntax of the procedures and how you would implement them into the system. I then ran through a few tests with some dummy data to see if the procedures work as expected.

I learned about how to create a storyboard by analyzing and exemplar and creating my version based on the idea of how it the exemplar was done. This did not require much learning as I had a reasonable understanding of how I needed to create one. This goes with the CRUD table as well. I’m not sure if I got a full understanding of the CRUD table, but I gave it a good shot and I believe that it gives a good idea of what actions my system will perform.