Database and Web Technology for Church Management

observancecookieSecurity

Nov 5, 2013 (3 years and 11 months ago)

81 views

Database and Web Technology
for Church Management

MSCM 8630

IT for Church Management

Dr. Wagner

October 23, 2008

This week in class…


Two on
-
line sessions this week


Thursday night 7:30 p.m. ET


Tuesday morning 9:30
-
10:30 ET (office hour)


Continue reading


Go over article from CC magazine


Chapter 5 of the Welch book for next week


Discuss database technology


Do Access (or other Database package) tutorials in
Element K as needed


Third assignment posted (database)


Start in on next module: IT for Church
Communications


Web site design

Questions about class so far?

Check out some of your colleagues’
spreadsheet projects…


Marcie Wilske


Kate Banta


Maria McCarthy


Chris Domyan

Building a Database


Database design determines the structure of a
database


Design entered into DBMS during construction


Tables


stores data


Forms


screen objects used to maintain, view, and
print from a database


Reports


provides formatted output


queries


Switchboards


a set of special forms used to provide
controlled access to the data, forms, report and
other objects in a database

Database Management Systems
(DBMS)


Program(s) through which users interact with
database


Popular DBMSs include


MS Access


Filemaker Pro


Oracle


DB2


SQL Server

To access your own DBMS…


MS Access 2003


You can also get to a version of this by
going to
https://citrixweb.villanova.edu


Login with VU userID and PW


Navigate to “General Applications” folder


You should see both Office 2003 and Office 2007


You can also access a copy of FrontPage 2003
for your web page projects here


Database Technology Review


“Relational” databases consist of tables
that are linked by shared fields or “keys”


Primary keys


uniquely identifies each record


Foreign keys


links information between
tables

One
-
to
-
Many Relationship

Types of Relationships


One
-
to
-
one (1:1)


1 laptop is assigned to one teacher or student


Foreign key can be stored on either side of relationship


One
-
to
-
many (1:M)


1 rep is assigned to 1 or more customers


Foreign key is stored on the “many” side


Many
-
to
-
many (M:N)


A student can take multiple classes and each class can
have multiple students in it


Create a bridge table with a composite key using both
of the primary keys from the linked table

Premiere Products Data Model

Query Languages


What is a Query?


Questions represented in a way the DBMS can
recognize and process


Query
-
by
-
Example (QBE)



Visual approach to writing queries


Used in MS
-
Access and other personal DBMSs


Structured Query Language (SQL)


Very popular, English
-
like query language


4GL for Relational DBs

“Select CustNum, CustName from Customer
where State=FL”

Types of Relational Queries


Single or Multiple Tables


must show link


Simple or Compound Conditions


“and” vs. “or”


Access Query Operators


=


<, >, <=, >=


<>


like


not


*, or ? (wildcards in Access)

Access Query Operators


Built
-
in operators


Max, min, count, sum, avg, first, last


Computed fields


Joining tables

Simple Queries

Query Practice (Premiere Products)


Open Customer table


Show the custnum, name, balance, credit limit


Show the average balance


Show the amount of credit remaining


Show average balance


Group by sales rep


Show all customers with City


Show those from Crystal, FL


Show those from Crystal and Fillmore


Multi
-
table query


Show the parts and ordernumbers for all the customers

Article: 25 Church Website Design
Tips

1.
Don’t use splash or intro screen

-
Except when there are multiple sites behind it

2.
Don’t use all Flash sites

-
don’t use small text and don’t force users to
scroll down too much

3.
Allow visitors to turn off Flash animations

4.
Don’t use frames

5.
Don’t use buttons in menus


use text links

6.
Don’t use tiled backgrounds


Article: 25 Church Website Design
Tips (2)

7.

Don’t use gifs, counters, or rainbow colors

-
Keep credit line subdued

8.

Don’t use denominational logo in banner

-
Should have a church logo

9.
Don’t put photo of church on home page

-

Photos of people show community more

10.
Don’t advertise on your home page

-
Focus main page on new people

11.

Add a “what to expect” page to website



Article: 25 Church Website Design
Tips (3)

12.

Include essential info on home page

-
Make it easy to find. Segment by gender?

13.

Add scripture to home page

14.
Include key email addresses and form for
inquiries

-

Disguise email addresses to avoid spambots

15.
Make website more than just an online
brochure

16.

Avoid drop
-
down and slide
-
out menus



Article: 25 Church Website Design
Tips (4)

17.

Don’t confuse visitors with interior
navigation links

18.

Use easy to understand labels

19.

Underline links in text

20.

Illustrate ministries with photos

21.

Include captions on photos

22.

Don’t call audio downloads “podcasts”

23.
Don’t use audio/music backgrounds

24.
Include time zone info for live broadcasts

25.
Make site disabled friendly


Assignment for next week


Work on the Access tutorials on Element
K (if necessary)


Work on next database assignment


Not due until Oct 30
th


Create 3 tables; Members, Groups, Priests or
Advisors


Populate with dummy data


Create links between them


Create 1 report, 1 form, and 1 saved query


Read Welch chapter 5

Questions?

Questions?