Database Management Systems
A Database Management System (DBMS), is a software program that enables the creation and management of databases. Generally, these databases will be more complex than the text file/spreadsheet example in the previous lesson. In fact, most of today's database systems are referred to as a Relational Database Management System (RDBMS), because of their ability to store related data across multiple tables.
Some of the more popular relational database management systems include:
Throughout this tutorial, you will become familiar with some of the key concepts of database management systems. These include:
- Database creation
- Adding data to your database
- Querying a database
- Relational database design
What Does a Database Management System Look Like?
Some database management systems include a graphical user interface that allows you to create and maintain databases by "pointing and clicking".
Other database systems use a command line interface that requires that you use certain programming commands to create and maintain your databases.
But most command line database systems also provide the option of installing graphical admin tools that allow you to "point and click" your way through most tasks.
Different systems look different, but generally, there are a number of common features that you'll usually see across most of them.
Here are three popular examples:
Which Database System to Use?
If you are using a database for home or small office use, Microsoft Access or Filemaker should be fine. If you need to create a database driven website, then you're better off using a more robust system such as SQL Server, MySQL, or Oracle.
The examples in this tutorial use Microsoft Access. If you don't have Microsoft Access, you should still be able to follow the examples. The tasks we perform are the same tasks you would need to perform regardless of which database management system you use. The key goal with this tutorial is to provide you with an overview of what is involved in creating and maintaining a database.
- What Is a Database?
- Creating a Database