Database Management: With Website Development Applications

Summary

*JX094-4, 0-201-74387-6, Riccardi, Greg; Database Management with Website Development Applications Covers the basic background needed to understand databases, but applies the material to a real-world context--a business going online--to make the material relevant to readers. KEY TOPICS: The case studies about a business moving to the web helps readers learn about SQL, database design, the Entity-Relationship model. The book uses Access and Oracle to give readers experience with the most popular SQL tools today. The second-half of the book teaches readers how to design a website to interact with users; how to construct web pages with HTML and XML; organize information and applications for use in e-commerce sites; and develop software to support user interactions. MARKET IS/IT database managers who want to learn about using the web with their databases

Table of Contents

I. INTRODUCTION TO INFORMATION TECHNOLOGY AND THE WORLD WIDE WEB.

1. Introduction to Information Systems.

What Are Information Systems and Databases?
Why Are Databases Important?
How Do Databases Represent Information?
Who Works with Database Systems?
How Do Databases Support the World Wide Web?
What Database Concepts and Terms Do You Need to Know?

2. An overview of Internet Architecture and Tools.

The Web: What Does It Consist Of?
Web Pages and HTML.
Web and Information Servers.
A Close Look at a Sample Web Site.

II. DESIGNING AND SPECIFYING INFORMATION SYSTEMS.

3. Representing Information with Data Models.

Data Models.
Discovering and Specifying Information Requirements and Terminology.
Organizing Information.
Relationships and Relationship Types.
Case in Point: Determining entity classes, attributes and relationship types for video sales.

4. Designing Entity-Relationship Models.

Entity-Relationship Modeling.
Entity-Relationship Diagrams.
Modeling Video Rentals.
Roles in Relationship Types.
An E-R Model for BigHit Video.
Object-Oriented Data Models.
Case in Point: E-R model for video sales for BigHit Video.

III. DESIGNING AND CREATING RELATIONAL DATABASES.

5. Developing Relational Data Models.

Introduction to the Relational Model.
A Closer Look at Relation Schemas and Keys.
Translating E-R Diagrams to Relation Schemas.
Representing Entity Classes as Relation Schemas.
Representing composite, multi-valued, and derived attributes.

Composite Attributes.
Multi-valued Attributes.
Derived Attributes.

Representing Relationship Types as Attributes.

One-to-many Relationship types.
One-to-one Relationship types.
Representing One-to-One Relationships by Merging Entities.

Representing Many-to-Many Relationships as Tables.
Representing Weak Entity Classes.
Representing Inheritance as Tables.
Case in Point: Relational model for video sales for BigHit Video.

6. Defining Relational Databases with Microsoft Access.

Creating an Access Database.
Creating Tables in Access.
Creating Forms from Tables.
Configuring Access for Multiple Users.
Specifying Relationship Types in Access.
Case in Point: Creating an Access database for Bighit Online Video Sales.

7. Improving Relational Schemas and Normalization.

Redundancy and Anomalies in Relation Schemas.
Functional Dependencies Between Attributes.
Superkeys and Keys.
Inferring Additional Functional Dependencies.
Determining Keys from Functional Dependencies.
Normalization.
Third Normal Form (3NF).
Boyce-Codd Normal Form (BCNF).
Case in Point: Normalization of a Car Registration.

IV. MANIPULATING RELATIONAL INFORMATION.

8. Manipulating Database Content with Relational Algebra and Microsoft Access.

Manipulating Information in Relational Databases.
Projection Queries.
Selection Queries.
Product Queries.
Queries with multiple join.
Combining Relational Operations.
Defining Complex Queries with Microsoft Access.
Applying Set Operators to Tables.
Creating User Interfaces in Access.
Case in Point: A Video Rental Checkout Form.

9. Using SQL to Manipulate Database Content and Structure.

Using SQL Select Statements for Queries.
Modifying Database Content with SQL.
Creating and Manipulating Schemas with SQL.
Case in Point: Manipulating BigHit Online Information with SQL.

V. CREATING INTERACTIVE WEB SITES.

10. Presenting Information on the Web with HTML.

Introduction to HTML.
Example of an HTML Document.
Anchor tags, URLs, and references to other documents.
Presenting information in tables.
Controlling format with style sheets.
Using external style sheets and style classes.
Case in Point: Design of the BigHit Online Web Site.

11. Creating Interaction between Users and Servers with ASP and JavaScript.

Active URLs and Forms in HTML.
Server-side scripting with ASP.
Processing forms with ASP and JavaScript.
Using objects and functions to improve code.
Case in Point: Forms and Interaction for BigHit Online.

12. Developing Database Applications for the Web.

Connecting to databases with ASP.
Executing select queries with ASP.
Creating objects from queries.
A general purpose query execution script.
Inserting new customer information.
Handling quote marks in SQL statements.
Case in Point: BigHit Online Web-Database Application.

VI. DEVELOPING AND MANAGING WEB-DATABASE INTERACTION.

13. Designing an Interactive Web Site.

Components of the BigHit Online Web site.
Data modeling for BigHit Online.
Relational Model for BigHit Online.
Creating a SQL Server Database.
Web Site Design, Pages, and Flow.

14. Implementing BigHit Online in ASP and JavaScript.

Viewing Source Code and SQL Statements.
Login and Customer Information.
Searching and Adding Items to a Shopping Cart.
Checkout Processing.

15. Advanced Issues in Website Design and Implementation.

Forms checking with client-side JavaScript.
Error handling in server-side JavaScript.
Transactions and transaction management.
Backup and Recovery from Failures.
Security in Information Systems.
Stored Procedures and Functions.
Case in Point: Transactions and Security in BigHit Online.