CRUD Table

JOURNAL #FOUR [DAT602]

CRUD Table

Development work has continued on the game design with the creation and refinement of the CRUD table. Version control has been established to ensure changes to the ERD are reflected in the CRUD table, an iterative and incremental approach has been adopted for the game development and consequently changes to the CRUD table are expected as the game build proceeds.

WHAT

Effective development of persistent storage applications requires four functions, these are create, retrieve, update and delete (CRUD).

CREATE - The create function is used to create records in the database using INSERT, this adds a new row to a table and populates the columns within that row.

RETRIEVE - The retrieve function can be viewed as a search function to retrieve specified information from the database, using SELECT, and can follow a set of customised criteria defined by the database user using FROM and WHERE.

UPDATE - The update function is used to modify specified data stored in the database using ALTER, for example, user information can change over time such as addresses or mobile telephone numbers.

DELETE - The delete function removes records from the database using DELETE. The delete function removes records from the database using DELETE. The decision to delete information should not be made lightly and some database administrators perform soft deletes that update the row status instead, depending on the circumstances this may be preferable to a hard delete with removes the record from the database entirely.

WHY

CRUD is used to identify the events inherent to relational databases and the applications that use them, such as MySQL, Microsoft SQL Server, MariaDB and Oracle. The concept of CRUD functions works extremely well with a relational database, operating over attribute rows or fields within the table, or tuple.

HOW

The CRUD table has been developed as a product of the logical ERD, the entities and attributes have been lifted from the current logical diagram version. The business and functional requirement in conjunction with the storyboards have been used to create the events listed on the table.

A detailed analysis is formed for each of the identified events:

• Login Check Credentials
• New User Registration
• Failed Login Account Lock
• Login Successful
• New Game
• Join Game
• Player Moves
• Player Finds Gem
• End Game
• Player Logout
• Enter Admin Screen
• Admin Kill Game
• Admin Add Player
• Admin Update Player
• Admin Remove Player

The CRUD table has been created in a spreadsheet as this makes it easier to update and change then it would otherwise be in a word table for example.

References

What is CRUD? Explaining CRUD Operations. (n.d.). Sumo Logic. Retrieved March 7, 2021, from https://www.sumologic.com/glossary/crud/