Westwood College Library
Westwood College Online Learning Resource Center
Home | Online Course Resources | Online Books and Articles | General Reference
 

CS224: Database Applications

In this course, students design and build databases using a database application. Topics include database creation/manipulation, normalization, entity relationships, creating keys, table relationships, and reports and forms. Upon completion of this course, students should be able to describe database design concepts and methodologies, develop a database, establish relationships between tables, and design user-friendly views and reports.


 

Database Creation/Manipulation

Database Solutions for Microsoft Access
Design and implementation tutorials, articles, tips, tricks, code samples, and more from Databasedev.co.uk

Microsoft Access 2003 Reference Guide
Created by Ohio University, available at ITtoolbox

Microsoft Access Tutorials
Collection of tutorials from About.com


Entity Relationships

Entity-Relationship Diagram
Guide to databases from About.com

The Entity-Relationship Model
Introduction to data modeling from the University of Texas at Austin

SQL By Design: The Entity Relationship Model
Written by Michelle A. Poolet in SQL Server Magazine


Table Relationships

Database Objects: Table Relationships
Article from SQL Server Reference Guide at Informit.com

Relational Databases: Defining Relationships Between Database Tables
Article written by Susan Harkins at Builder.com

Relational Model: Properties of Relational Tables
Introduction to data modeling from the University of Texas at Austin


Forms

Access Database Tips
Tips for forms

Creating Forms in Microsoft Access
Guide to databases from About.com

Form Design Articles
Articles and tips relating to MS Access Graphical User Interface Form designs from Databasedev.co.uk

Normalization

Database Normalization Basics
Guide to databases from About.com

The Database Normalization Process
Sample chapter from "Sams Teach Yourself SQL in 24 Hours"

SQL by Design: Why You Need Database Normalization
Written by Michelle A. Poolet in SQL Server Magazine


Creating Keys

Database Keys and Indexes
Article from ExtremeTech.com

Introducing Keys
Guide to databases from About.com

Keys and Datatypes
Practical Database Design from DevX.com


Reports

MS Access Reports
Examples of generating HTML reports with MS Access from the University of Virginia

Microsoft Access Report Design Articles and Tips
Articles relating to MS Access database report designs from Databasedev.co.uk

Microsoft Access Reports Tutorial
Resources from About.com


Additional Sites of Interest

ACM Queue
Developer tools, hardware, security, open source, enterprise search, and more

Builder.com
White papers, trialware, and online book library

CERT Coordination Center
Carnegie Mellon Software Engineering Institute

CSI Blog
Blog for the Computer Security Institute

Computer User
Online security network forums

ComputerWorld
Source for information needs of IT management

DesktopLinux.com
Linux on enterprise and end user desktops

Foundstone
Free downloads of security tools

Hotscripts.com
PHP, CGI, Perl, JavaScript, and ASP script collection

IEEE Computer Society
Site includes digital library with magazines, transactions, and proceedings

IT Architect
Technology architecture for the 21st century

Information Week
News, research, and IT trends

INFOSYSSEC
Security portal for information system security professionals

Intelligent Enterprise
Strategic business applications

Journals: @Brint.com
Resources from business technology management and knowledge management

The Linux Documentation Project
Documention for Linux, including guides and FAQs

Linux Journal
Magazine of the Linux community

Linux Online
Open source code, news, Linux 101

MSDN Academic Alliance Development Center
Provides faculty and students with the latest developer tools, servers, and platforms from Microsoft at a low cost

MSDN Magazine
Microsoft journal for developers

Macworld
Resource for Mac professionals and Mac users

McAfee
Antivirus software and intrusion prevention solutions

Microsoft Windows
Windows family home page

NerdWorld
Source for "nerdly" culture, life, and work styles

Network Computing
Evaluating enterprise technology

Novell
Software for the Open Enterprise

Optimize
Business strategy and execution for CIOs

PC Magazine
Computer, software, hardware, and electronics reviews, downloads, news, and opinion

PC Support Advisor
Free computer guides

PCVirus.org
Computer virus/antivirus resources

PGP
Multiple encryption and digital-signature solutions

Programmers' Heaven
Languages, applications, and web development

Publish
Web publishing and print

Red Hat
Open source architecture

SearchNetworking.com
Networking-specific information resource for enterprise IT professionals

SearchSecurity.com
Security-specific information resource for enterprise IT professionals

SecurityFocus
Comprehensive source of security information

Smart Computing
Site for magazine devoted to helping users improve their productivity with personal computers

Software Development
News, articles, and software pipelines

Symantec
Helps companies manage digital assets

TechWeb
Business technology network

Tom's Hardware Guide
Resource for PC hardware reviews and news

Trend Micro
Leader in network antivirus and Internet content security software and services

WhatIs.com
Dictionary for Internet and computer technologies 

WindowsITPro
Leading source of practical, technical information to help IT professionals

Wired
Latest news in technology, culture, business, and politics

ZDNet.com
Business technology blogs

 

LIBRARY HOME | CONTACT | DISCLAIMER