T4L1DatabasesIntroductionThis 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.DatabasesDatabase DefinitionDatabase Management System DefinitionPersonal DBMS Enterprise DBMS Databases and SQLWeb Enabled DatabasesBenefits of Using a DatabaseStatic Web SitesDynamic Web SitesTrends in DBMS for the WebAdditional ResourcesCNET Builder.com[[ link to ]]ahref.com[[ link to ]]1
T4L1Web Developers Virtual Library[[ link to ]]Database DefinitionA Database DefinedA 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.RecordA 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
T4L1The DatabaseRecordRecordRecordFieldEach 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 DatabaseRecordRecordRecordFieldFieldFieldIn 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
T4L1My Friends DatabaseRecordRecordRecordName:Address:Telephone Number:Field TypesFields can hold different types of information. The most common types are listed below.