T4L1.doc - T4L1 Databases Introduction This lesson is designed to expose you to the concept of database technology and its use on the Internet today By

T4L1.doc - T4L1 Databases Introduction This lesson is...

This preview shows page 1 - 5 out of 15 pages.

T4L1 Databases Introduction This lesson is designed to expose you to the concept of database technology and it’s use on the Internet today. By the end of this lesson you should be able to: Define what a database is. Define what a database management system is. Recognize the difference between an enterprise database management system and a personal database management system. Define what SQL is. Define benefits of using a database with your web site. Define what a static web site is. Define what a dynamic web site is. The concept of databases has been around for quite some time. With the advent of the web, it is a natural progression for the database to extend itself from the client-server model to a web-enabled model. Web sites have been using databases to produce their content for a number of years. Databases Database Definition Database Management System Definition Personal DBMS Enterprise DBMS Databases and SQL Web Enabled Databases Benefits of Using a Database Static Web Sites Dynamic Web Sites Trends in DBMS for the Web Additional Resources CNET Builder.com [[ link to ]] ahref.com [[ link to ]] 1
Image of page 1
T4L1 Web Developers Virtual Library [[ link to ]] Database Definition A Database Defined A database stores information in a planned format for future retrieval. This section will explain the basic concepts and terminology behind most databases. File [[these graphics were created by Brett Bixler. IST has permission to use them if they want.]] A database file is a collection of related information. Each file stores information about one topic. Record A database consists of one or more records of information. Each record is a collection of information about one person, place, or thing. A record contains all the pieces of information about a particular subject. For example, if you had a database of people you correspond with, each record would contain information on one person. If your database contained 20 records, you would have information on 20 people. 2
Image of page 2
T4L1 The Database Record Record Record Field Each record in a database contains different pieces of information called fields. A field is one item contained in the record. It is one component of the record. The Database Record Record Record Field Field Field In the example of a database of people you correspond with, each record might have a name field, an address field, and a telephone number field. 3
Image of page 3
T4L1 My Friends Database Record Record Record Name: Address: Telephone Number: Field Types Fields can hold different types of information. The most common types are listed below.
Image of page 4
Image of page 5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture