| |
| |
| |
| Introduction to Information Technology and the World Wide Web | |
| |
| |
| |
| 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? | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Designing and Specifying Information Systems | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Designing and Creating Relational Databases | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Manipulating Relational Information | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Creating Interactive Web Sites | |
| |
| |
| |
| 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 | |