Community Business Website Project
Part 1 - Template (200 points)

Informational Website

Ongoing Partner Project

Create a one page design for an approved local business.

Read:

Forbes: How To Build A Killer Small Business Web Site
eHow: How to Build a Business Website
About.com: How to Create a Small Business Website That Works

Also check out competitor Websites.

It is your responsibility to solicit a business from Coalinga or Huron. You must obtain general information to start such as:

Domain Name (availability only)
Logos
Official Colors
Slogans
Business Cards
Contact Information
Services Provided
Products Sold
Flyers
Pamphlets
Photographs

Use all the skills you have learned thus far. Assignment requirements for this assignment are:

1. One column, two column, or three column layout
2. Body background image
3. Container background image
4. Header background image
5. Wrapper background image
6. Content background image
7. Footer background image
8. Include a favicon
   

Create your template (index.php).

Example: http://www.elmarcianopromotions.com/

* This project is for educational purposes only. The site will be hosted temporarily on our Web server for testing purposes.

Databases Overview

Creating Tables
Fields and Datatypes

Using Microsoft Access

Activity 1 - Access It!

Celebrity Addresses

Acitivity 6 Access It!

NASCAR

MDB | HTML

Activity 8 Access It!

Jobs

MDB | HTML

Acitivity 6 Access It!

Database Overview

Creating Queries
Select Queries using NASCAR

Query 1 - TOP 10 WINNINGS

Query 2 - ROOKIE DRIVERS

Activity 17 Access It!

PGA Tour

MDB | HTML

Connecting to MySQL

MySQL - Tutorial

MySQL - Tutorial 2

Connection Settings -

You will need a username, password, and your own database!

Creating Tables - MySQL

MySQL - Create Table

Using your own username and password, connect to MySQL, select the database, and create the Celebrity Address table.

- Use the create table command in php.

- Use the insert command in php

Hint: You can create a form to input the data!

Celebrity Addresses

Creating Queries - Access

Using CHSAlumniDB

Demo - Creating Queries

Create/Export the following queries:

Query 1: How many gifted children have criminal parents?

Query 2: Provide a list of alumni who earn more than $30,000 in descending order by earnings.

Query 3: How many children are suffering because their parents didn't go to college and, as a result, make less than $20,000.

Query 4: Who makes the most money and what is their career?

Query 5: What do non high school graduates drive?

Include all the fields that make the query meaningful! Remember, export as HTML and link to the query results and your .MDB file..

Selecting Data - MySQL

Celebrity Addresses

Creating Queries - MySQL

Query1 | Query2 | Query3