Introductory Database Theory: Systems And Design
(Page 1 of 6 )
Before you can begin to design a database you must understand the underlying concepts and theories of why databases are used and how they are created. In this article, Steve gives us a great explanation of what a database is, the relational database model, metadata and indexes, the database management system and structured query language.Databases are the primary form of storage in both today's online and offline worlds. Databases are used to store millions of different types/combinations of information including product details, employees, personal address books, news, etc. Before you can begin to design a database however, you must understand the underlying concepts and theories of why databases are used and how they are created. In this article, I will explain all of this and more. I will take a look at what a database is, the relational database model, metadata and indexes, the DBMS and SQL.
This article is designed to shed some light on databases for those who are either just beginning programming or those interested in integrating a database into any form of application/web site.
Next: What is a database? >>
More MySQL Articles
More By Steve Adcock