What is a Database - What is a Database A database is a...

Info icon This preview shows pages 1–3. Sign up to view the full content.

What is a Database? A database is a collection of data. That may sound overly simplistic but it pretty much sums up what any database is. A database could be as simple as a text file with a list of names. Or it could be as complex as a large, relational database management system, complete with in-built tools to help you maintain the data. Before we get into dedicated database management systems, let's start with the basics - let's look at a simple text file example. Text File Imagine we have a text file called "Individual.txt", and that the contents look like this: We could use this information to do things such as send an email to everyone on our list. We could do this because, due to the way we designed the list, we know that each row contains a different individual, and the information on that row is related to that individual. Also, the items in each row are separated by commas. Therefore, we know that the email address next to "Homer" is his email address. We could also call each row a record . Therefore, we currently have 4 records in our database. With a small list like this, a text file may serve our purposes perfectly. Spreadsheet Another option would be to store it in a spreadsheet using spreadsheet software (for example, Microsoft Excel). That way, we could do some extra things with our list (such as format it, or sort by first name/surname etc). A spreadsheet program like Excel makes these tasks relatively easy to do. Also, programs like Excel organize the data into rows and columns , making your data easier to comprehend. Something like this:
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Database Software A better option would be to store the data in a database table using specialized database software, such as Microsoft Access. Something like this: So What's the Difference? You may be wondering what the difference is between the last two examples (Excel vs Access). After all, both examples have the data organized into rows and columns. There are many differences between spreadsheet software and database software. The rest of this tutorial will show you why database software is a much better option for creating databases. 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 file. 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: 1. Microsoft Access 2. Filemaker 3. Microsoft SQL Server 4. MySQL 5. Oracle Throughout this tutorial, you will become familiar with some of the key concepts of database management systems. These include: Database creation Tables
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.
  • Summer '16
  • Relational model, Database management system

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern