Database and Web Technology for Church Management

1. Database and Web Technology for Church Management MSCM 8630 IT for Church Management Dr. Wagner October 23, 2008

2. 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

3. Questions about class so far?

4. Check out some of your colleagues’ spreadsheet projects… • Marcie Wilske • Kate Banta • Maria McCarthy • Chris Domyan

5. 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

6. Database Management Systems (DBMS) • Program(s) through which users interact with database • Popular DBMSs include • MS Access • Filemaker Pro • Oracle • DB2 • SQL Server

7. 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

8. 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

9. One-to-Many Relationship

10. 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

11. Premiere Products Data Model

12. 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”

13. Types of Relational Queries • Single or Multiple Tables • must show link • Simple or Compound Conditions • “and” vs. “or”

14. Access Query Operators • = • <, >, <=, >= • <> • like • not • *, or ? (wildcards in Access)

15. Access Query Operators • Built-in operators • Max, min, count, sum, avg, first, last • Computed fields • Joining tables

16. Simple Queries

17. 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

18. Don’t use splash or intro screen Except when there are multiple sites behind it Don’t use all Flash sites don’t use small text and don’t force users to scroll down too much Allow visitors to turn off Flash animations Don’t use frames Don’t use buttons in menus – use text links Don’t use tiled backgrounds Article: 25 Church Website Design Tips

19. 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 Don’t put photo of church on home page - Photos of people show community more 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 (2)

20. 12. Include essential info on home page Make it easy to find. Segment by gender? 13. Add scripture to home page Include key email addresses and form for inquiries - Disguise email addresses to avoid spambots Make website more than just an online brochure 16. Avoid drop-down and slide-out menus Article: 25 Church Website Design Tips (3)

21. 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” Don’t use audio/music backgrounds Include time zone info for live broadcasts Make site disabled friendly Article: 25 Church Website Design Tips (4)

22. Assignment for next week • Work on the Access tutorials on Element K (if necessary) • Work on next database assignment • Not due until Oct 30th • 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

23. Questions?

24. Questions? Go Phillies!!!!!