jschap11 - Tutorial 11 Database Connectivity JavaScript...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon
Tutorial 11: Database Connectivity JavaScript - Comprehensive
Background image of page 1

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

View Full DocumentRight Arrow Icon
Previewing the Registration Program In this tutorial, you will use LiveWire and ASP to create an online registration program for WebAdventure’s computer courses This Tutorial builds on the LiveWire and ASP versions of server- side JavaScript covered in Tutorial 10
Background image of page 2
Section A: Overview of Database and Connecting to Databases with LiveWire
Background image of page 3

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

View Full DocumentRight Arrow Icon
Objectives In this section, the students will learn: About basic database structure About database management systems About structured query language About LiveWire’s Database object How to execute SQL commands with LiveWire How to perform transaction processing with LiveWire How to handle database errors with LiveWire
Background image of page 4
Understanding Databases A database is an ordered collection of information from which a computer program can quickly access information The information stored in computer databases is actually stored in tables similar to spreadsheets A record in a database contains a single complete set of related information The individual pieces of information stored in a record are called fields A flat-file database stores information in a single table
Background image of page 5

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

View Full DocumentRight Arrow Icon
Understanding Databases A relational database stores information across multiple related tables A primary table is the main table in a relationship that is referenced by another table A related , or child table references a primary table in a relational database
Background image of page 6
Understanding Databases Tables in a relationship are connected using primary and foreign keys A primary key is a field that contains a unique identifier for each record in a primary table A foreign key is a field in a related table that refers to the primary key in a primary table There are three basic types of relationships within a relational database: one-to-one, one-to- many, and many-to-many A one-to-one relationship exists between two tables when each record in a related table contains exactly one record for each record in a the primary table
Background image of page 7

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

View Full DocumentRight Arrow Icon
One-to-One Relationship
Background image of page 8
Understanding Databases A one-to-many relationship exists in a relational database when one record in a primary table has many related records in a related table Breaking tables into multiple related tables in order to reduce redundant and duplicate information is called normalization A many-to-many relationship exists in a relational database when many records in one table are related to many records in another table
Background image of page 9

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

View Full DocumentRight Arrow Icon
Table with Redundant Information
Background image of page 10
One-to-Many Relationship
Background image of page 11

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

View Full DocumentRight Arrow Icon
Understanding Databases A junction table creates a one-to-many relationship for each of the two tables in a many-to- many relationship
Background image of page 12
Database Management Systems An application or collection of applications used to create, access, and manage a database is called a database management system or DBMS A database management system that stores data in a flat-file format is called a flat-file database
Background image of page 13

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

View Full DocumentRight Arrow Icon
Image of page 14
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/13/2011 for the course MIS 241 taught by Professor Tse during the Spring '11 term at Moraine Valley Community College.

Page1 / 89

jschap11 - Tutorial 11 Database Connectivity JavaScript...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online