Relational Database 101{2}

For those students who have no prior experience or knowledge of database design, this is a great read for you. The author of the article explains the introductory terms and information about how data is organized and represented in a Relational Database. The following are the basics one needs to know. In a relational database, data is stored in a two-dimensional matrix (table) and within the table there are multiple columns and rows. Relational Database Management System (RDBMS) software is used to give ability to users to read and manipulate data. The RDBMS relies on SQL (Structured Query Language) constructs and keywords to access the tables and data that is contained within the tables’ columns and rows. It clarifies that each table in a relational database contains information about a single type of data and has a unique name that is distinct from all other tables in that schema (a grouping of objects/tables that serve a similar business function). The author points out the key to good relations. The primary key is very important; it is a column that ensures uniqueness for every row in a table. The author then explains how a relational database connects (relates) tables and organizes information across multiple tables. The foreign key is an important connector that identifies a column or set of columns in one table that refers to a column or set of columns in another table. The author then states that the key to understanding relational databases is knowledge of data normalization and table relationships. The objective of normalization is to eliminate redundancy and thereby avoid future problems with data manipulation. There are 5 most commonly accepted normal forms, but many programmers, analysts, and designers do not normalize beyond the 3rd normal form,  although experienced database designers may. The author goes on to talk about what 1st, 2nd, and 3rd normal forms look like. Lastly, the article mentions how SQL fits in. SQL helps to create new data, delete old data, modify existing data, and retrieve data from a relational database.

Since we are currently learning about the relational data model/relational database in class this past week, I thought this article was very relevant. We have learned pretty much everything that the article talked about; tables, columns, rows, primary keys, foreign keys, normalization, 1st 2nd 3rd normal forms etc. All these terms are very crucial to learn in order to have solid knowledge of  the relational data model.

I really enjoyed reading this article because it was simple and straight to the point. It had practical examples of tables showing what a table looks like when it’s in 1st, 2nd and 3rd normal form as well as other examples of basic terms. It was very helpful to me especially because I have no prior knowledge or experience with database design, so this article really helped me to fully grasp and understand the basic concepts of relational database. This article is a great overview for all database students, especially for those who are new to learning about database design.

Melanie Caffrey. (2011, September/October). Get Your Information in Order. Retrieved October 18, 2012, from