Showing posts with the label RDBMS

Relational Databases

By McDonald, T.   |  Date 5th of November 2020 Why use a database? Databases are a great way to store and retrieve data.   Since they are so widely used in computing, knowing how to use them is a must have skill in this industry.   For instance, many websites use databases to store product details.   One of the main benefits to databases is allows data to be organised, manipulated and retrieved rather than just storing it making it a very powerful tool.      Tables and keys First let’s look at the parts of the table  Customer_Table customer_id name address phone 1 Tony McDonald Some place 0788454567 2 A man 17 somewhere else 0793453459 3 A woman 45 who knows 0712311180   All relational databases have columns and rows.   Columns are vertical, so phone is the label of a column containing phone numb

Databases: SQL and NoSQL

  By   McDonald, T.    | Date 20th of November 2020 What is a database? A database can be anything that stores collection of information and is often abbreviated to DB. A relational database stores information that is related in some way. For example, a shopping list is a relational database since it is a list of related information. Other examples include: Phone book. List of twitter users. Your families favourite foods. Now you have an idea of what a database is we can talk about where to store it. In the examples above, the phone book is a list of numbers and related information that can be stored in a book. The shopping list is stored on paper. We can also store these databases on a computer. Notably, the computer can be in your office or be a dedicated computer in a server room or even stored in a virtual machine in the cloud, which uses dedicated computers. Keeping it simple for now we can just think of a computer hosting the database. Now we have a place to store the d