Marketing for Libraries Logo

Database Design

Learning Objectives
• Define database, relational database, and provide examples in a library setting.
• Define MySQL and provide examples of how it is used in a library setting.
• Define PHP and provide examples of how it is used in a library setting.

A database is an organized collection of data.

Database Management Systems (DMS) are applications that help connect a user’s queries with a database.

Databases are used in all aspects of library collections from the online catalog to subscription-databases.

Database

accessIn a relational database, all data are stored and accessed through relations.

A relation is a set of objects that have the same attributes. A relation is expressed as a table with rows and columns. Applications access data through queries.

Microsoft Access is an easy-to-use database management system. It’s available for Windows, but not Mac.

Access allows users to add new data, edit existing data, delete information, organize data, and share data.

Try It!
Go to Lynda.com and locate Microsoft Access in the software list. Complete the Essential Training tutorial.

If you have Windows, download Microsoft Access from IUware.

MySQL and PHP

MySQL is a popular, open-source relational database management system.

It is particularly popular for web applications.

Facebook, LinkedIn, Twitter, and Scholastic are a few examples of companies that use MySQL.

PHP is a free, server-side scripting language designed for web development. It can be used with most operating systems often used in conjunction with MySQL.

Popular applications using MySQL and PHP include WordPress and Drupal.

Open Source Database Applications

LAMP is an open source web application software stack comprised of the following four applications:

lamp

Conclusion

A database is an organized collection of data.

Database Management Systems (DMS) are applications that help connect a user’s queries with a database.

MySQL is a popular, open-source relational database management system. It is particularly popular for web applications. PHP is a free, server-side scripting language designed for web development often used with MySQL.

LAMP is a bundle of open-source applications used for web applications.

 


| eduscapes | IUPUI Online Courses | Contact Us | 2014 Annette Lamb (Adapted from earlier s401 materials)

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.