Binary Search

Binary search is one the simplest search algorithms(most are pretty simple) to implement. However, first it assumes an important property of an array that isn't always true; the array is sorted. This search is based on the number of elements(length), and we fold the array in half each time, which makes search time logarithmic.First, you see in the...

Read More

Relational Algebra - An Intro of it's Use and Operators

Consider the following database scenario:You are planning a high school graduation party for the school. You keep data on those who have registered to be present on that day. We have students(S), teachers(T), staff members(SM), parents(P), and siblings(C) of the students, followed by relatives(F), and a list of registered people for the party(R). We...

Read More

MySQL Queries and commands

In this post I hope to go through some MySQL commands that would help users get started and used to using it. Remember that semicolons are default used to show end of command/queries.Creation/Deletion CommandsUSE <database name>:This is used to enter an existing database.CREATE DATABASE <database name>:This is used to create a database.CREATE...

Read More