html,coldfusion,database,sql

THIS IS ONE OF MY FRIEND ASSIGNMENT OUTPUT AND THIS HOW MINE SHOULD QUITE LOOK LIKE.

HE CHOSE TO CREATE A CHURCH DATABASE SYSTEM, ME I CREATED AN AUTO SALE DATABASE SYSTEM, SO MINE WILL BE DIFFERENT. I CAN SEND YOU THE TABLE I CREATED FOR MY AUTOSALE DATABASE SYSTEM USING SQL, YOU WILL HAVE TO USE THAT TO BE ABLE TO DO THIS.

NOTE: WHERE EVER YOU MENSAH YOU HAVE TO SUBTITUTE IT WITH SECK.

SECTION 5: DATABASE APPLICATION AND DEVELOPMENT

5.1 COLD FUSION CODE AS WELL SCREENS AND DISPLAYS

//list_contribution script//

SELECT * FROM mensah05.TBL_PRJ_CONTRIBUTION ORDER BY CONTRIBUTION_TYPE

CHURCH CONTRIBUTION #3



CHURCH CONTRIBUTION



CONTRIBUTION AMOUNT” WIDTH=”19″ TEXT=”#CONTRIBUTION_AMOUNT#”>

SELECT * FROM mensah05.TBL_PRJ_DEPARTMENT

ORDER BY DEPT_NAME


CHURCH DEPARTMENTS #3







CHURCH DEPARTMENTS






DEPARTMENT_NAME” WIDTH=”18″ TEXT=”#DEPT_NAME#”>

DEPARTMENT_HEAD” WIDTH=”18″ TEXT=”#DEPT_HEAD#”>




//list_activities script//

SELECT * FROM mensah05.TBL_PRJ_ACTIVITY ORDER BY ACTIVITY_NAME


CHURCH ACTIVITIES #3







CHURCH ACTIVITIES






ACTIVITY_DESCRIPTION” WIDTH=”32″ TEXT=”#ACTIVITY_DESRCRIPTION#”>

SELECT * FROM mensah05.TBL_PRJ_MEMBER ORDER BY M_LNAME


CHURCH MEMBERS #3







CHURCH MEMBERS






MEM_FNAME” WIDTH=”10″ TEXT=”#M_FNAME#”>

MEM_NUMBER ” WIDTH=”12″ TEXT=”#M_PHONE_NUMBER#”>

STATE” WIDTH=”8″ TEXT=”#M_ADDRESS_STATE#”>

ZIPCODE” WIDTH=”8″ TEXT=”#M_ADDRESS_ZIPCODE#”>

JOB_NAME” WIDTH=”15″ TEXT=”#M_JOB_DESIGNATION#”>

ACTIVITY_ID” WIDTH=”15″ TEXT=”#ACTIVITY_ID#”>




INPUT FORM used to add a DEPARTMENT



DEPARTMENT CODE :

DEPARTMENT NAME :

DEPARTMENT PHONE:

DEPARTMENT HEAD :




//insert_department_b script//


department add confirmation screen

INSERT INTO mensah05.TBL_PRJ_DEPARTMENT

VALUES ( ‘#DEPT_CODE#’,

‘#DEPT_NAME#’,

‘#DEPT_PHONE_NUMBER#’,

‘#DEPT_HEAD#’)






Confirmation that the following department was added:



DEPTARTMENT CODE : #DEPT_CODE#

DEPTARTMENT NAME: #DEPT_NAME#

DEPTARTMENT PHONE: #DEPT_PHONE_NUMBER#

DEPTARTMENT HEAD : #DEPT_HEAD#



//Screen Shots of Input Form Used to Add A Department.//

SCRIPTS USED TO DELETE/REMOVE A DEPARTMENT

//delete_department scripts//


line removal sample screen





INPUT FORM USED TO REMOVE A DEPARTMENT



Enter the department code of the DEPARTMENT that you want to remove

DEPARTMENT CODE:






//delete_department_b scripts//

SELECT * FROM mensah05.TBL_PRJ_DEPARTMENT

WHERE DEPT_CODE = #DEPT_CODE#


DEPARTMENT REMOVAL Y/N screen






DEPARTMENT info for the department code that you specified:



DEPTARTMENT CODE : #DEPT_CODE#
DEPTARTMENT NAME: #DEPT_NAME#
DEPTARTMENT PHONE: #DEPT_PHONE_NUMBER#
DEPTARTMENT HEAD : #DEPT_HEAD#




//delete_department_c//

DELETE FROM mensah05.TBL_PRJ_DEPARTMENT

WHERE DEPT_CODE = #DEPT_CODE#

department removal confirmation screen






department removal confirmation:






DEPTARTMENT CODE : #DEPT_CODE#
DEPTARTMENT NAME: #DEPT_NAME#
DEPTARTMENT PHONE: #DEPT_PHONE_NUMBER#
DEPTARTMENT HEAD : #DEPT_HEAD#






SCRIPTS USED TO UPDATE A DEPARTMENT

//update_department script//


Department update sample screen





INPUT FORM used to update a DEPARTMENT



Enter the department code of the DEPARTMENT that you want to update

Department Code:






//update_department_b_script//

SELECT * FROM mensah05.TBL_PRJ_DEPARTMENT

WHERE DEPT_CODE = ‘#DEPT_CODE#’


Department update screen







DEPARTMENT info for the department code that you specified:




DEPTARTMENT CODE:

DEPTARTMENT NAME:

DEPTARTMENT PHONE:

DEPTARTMENT HEAD:




//update_department_c script//

UPDATE mensah05.TBL_PRJ_DEPARTMENT

SET DEPT_CODE=’#DEPT_CODE#’,

DEPT_NAME=’#DEPT_NAME#’,

DEPT_PHONE_NUMBER=’#DEPT_PHONE_NUMBER#’,

DEPT_HEAD=’#DEPT_HEAD#’

WHERE DEPT_CODE = #DEPT_CODE#

Department update confirmation screen






Department update confirmation:





DEPARTMENT CODE: #DEPT_CODE#

DEPARTMENT NAME: #DEPT_NAME#

DEPARTMENT PHONE: #DEPT_PHONE_NUMBER#

DEPARTMENT HEAD : #DEPT_HEAD#







5.2 TEST PLAN AND RESULTS

5.2 a. Testing The Displays for the Select commands Used in the Cold fusion Scripts

> SELECT * FROM TBL_PRJ_CONTRIBUTION ORDER BY CONTRIBUTION_TYPE

EXPECTED:

CONTRIBUTION_ID CONTRIBUTION_AMOUNT CONTRIBUTION_TYPE

————— ———————- ——————–

17774 200 DONATION

17777 100 DONATION

17779 280 DONATION

17781 200 DUES

17775 50 OFFERTORY

17771 15 OFFERTORY

17772 200 OFFERTORY

17776 500 PLEDGE

17780 170 PLEDGE

17778 300 TITHE

17773 30 TITHE

11 rows selected

EXPECTED RESULTS:

SELECT * FROM TBL_PRJ_DEPARTMENT ORDER BY DEPT_NAME

DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD

——— ————————- —————– ——————–

1555 CHILDRENS GRP 7035895218 ARYTHSON

1552 DISCIPLISHIP 6145895214 SMITHSON P

1557 EPISTLES 6145005219 TARY V

1551 EVNAGELISM 6145895213 AGYENIM S

1554 MENS GRP 6165895215 SMITHSON

1559 MUSIC 6145897713 ERIC O

1558 OUTREACH 9675895214 GORTLE M

1553 WOMENS GRP 6145855218 AYUBA R

1556 YOUTH MINISTRY 6145895214 JOHNSON B

ACTUAL RESULTS:

EXPECTED RESULTS:

> SELECT * FROM TBL_PRJ_ACTIVITY ORDER BY ACTIVITY_NAME

ACTIVITY_ID ACTIVITY_DESRCRIPTION ACTIVITY_NAME

———– ————————- ——————–

1215 CAMPUS CRUSADE CRUSADE

1210 OUTDOOR DISCIPLISHIP DISCIPLISHIP

1211 DOOR-TO-DOOR EVANGELISM EVANGELISM

1214 MUSIC FOR CHRIST MUSIC SHOW

1212 SPREAD THE GOSPEL OUTREACH

1213 PRAYER FOR THE PPL PRAYER

1218 CHOIR REHEASAL REHEARSAL

1217 SAVING THE LOST SOUL WINNING

1216 TINY TILLY YOUTH EXPOSEE

9 rows selected

ACTUAL RESULTS:

SELECT * FROM TBL_PRJ_MEMBER ORDER BY M_LNAME

M_ID M_FNAME M_LNAME M_PHONE_NUMBER M_STREET M_STATE M_CITY M_ZIPCODE M_DOB M_JOB_DESIGNATION CONT_ID ACTIVITY_ID DEPT_CODE

—————————————————————————————————————————————————————————————————————————————————————————————————————————–

0005 PAP BLAIR 6154230000 1065 COVINGTON RD OH COLUMBUS 43229 17-DEC-71 USHER 17773 1212 1552

0003 EBEN DADLEY 6154238130 4317 CHESFORD RD OH COLUMBUS 43224 12-JAN-81 USHER 17774 1212 1555

0007 IRENE DIDLEY 6154238130 531 EASTON OVAL OH COLUMBUS 43224 12-JAN-81 USHER 17774 1213 1555

0001 JOHN DOE 6154238134 54 GRISBY LN OH PIKERNITON 43232 12-MAR-74 PASTOR 17774 1210 1555

0011 OLIVE DUKE 6144238135 15 HARMILL DR OH DUBLIN 43012 10-FEB-78 MENS LEADER 17776 1213 1551

0004 EKLU FINLEY 6764238130 41 CHESFORD RD OH COLUMBUS 43232 12-MAR-41 ORD MEMBER 17774 1210 1557

0002 AMY KAY 6764238130 41 CHESFORD RD OH COLUMBUS 43224 12-MAR-81 DEACON 17772 1211 1556

0006 YERUTY KAIYE 7034238130 66 BELL RD TN ANTIOCH 37076 15-NOV-66 EVANGE SEC 17771 1215 1558

0012 MOGENS KELLY 6464238130 414 LEESBURG PIKE VA FALLS CHURCH 22042 12-OCT-86 ORD 17775 1216 1559

0008 ANDY MOORE 7034238130 291 GALOUS RD VA FALLS CHURCH 22042 12-OCT-86 ORD MMBER 17775 1216 1559

0009 ABENA MOSES 6154230000 1778 WEST POINT OH COLUMBUS 43232 19-DEC-79 YOUTH 17777 1218 1553

0010 KIBE SAMUEL 7034158796 71 WEST BROAD ST OH COLUMBUS 43125 15-NOV-74 CHAIRMAN 17775 1214 1558

.2 b. Testing The INSERT/DELETE/UPDATE using Cold fusion Scripts

A. ORIGINAL STATE OF THE DEPARTMENT TABLE BEFORE ADDING NEW ROWS USING COLDFUSION SCREEN

SELECT * FROM TBL_PRJ_DEPARTMENT ORDER BY DEPT_CODE

DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1551 EVNAGELISM 6145895213 AGYENIM S
1552 DISCIPLISHIP 6145895214 SMITHSON P
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O

9 rows selected

EXPECTED RESULTS AFTER ADDING 2 MORE DEPARTMENTS USING THE ADD DEPARTMENT INPUT SCREEN.

DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1551 EVNAGELISM 6145895213 AGYENIM S
1552 DISCIPLISHIP 6145895214 SMITHSON P
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O

1660 ANAKANZO 6148931258 TAKIYAH J

1661 ALL MISSION 6148953215 ASORI BA

NOTE: HIGHLIGHTED ROWS SHOULD BE ADDED SUCCESSFULLY IF THE ADD INPUT SCREEN WORKED.

ACTUAL RESULTS AFTER ADDING 2 MORE DEPARTMENTS USING THE ADD DEPARTMENT INPUT SCREEN.

SELECT * FROM TBL_PRJ_DEPARTMENT ORDER BY DEPT_CODE
DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1551 EVNAGELISM 6145895213 AGYENIM S
1552 DISCIPLISHIP 6145895214 SMITHSON P
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J

1661 ALL MISSION 6148953215 ASORI BA

11 rows selected

NOTE: THE ADD WAS SUCCESSFUL. SEE HIGHLIGHTED ROWS.

B. ORIGINAL STATE OF THE DEPARTMENT TABLE BEFORE DELETING ROWS USING COLDFUSION SCREEN.

SELECT * FROM TBL_PRJ_DEPARTMENT ORDER BY DEPT_CODE
DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1551 EVNAGELISM 6145895213 AGYENIM S
1552 DISCIPLISHIP 6145895214 SMITHSON P
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J
1661 ALL MISSION 6148953215 ASORI BA
11 rows selected

EXPECTED RESULTS AFTER DELETE 2 DEPARTMENTS USING THE DELETE DEPARTMENT INPUT SCREEN.

DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1551 EVNAGELISM 6145895213 AGYENIM S
1552 DISCIPLISHIP 6145895214 SMITHSON P
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J
1661 ALL MISSION 6148953215 ASORI BA

NOTE: HIGHLIGHTED ROWS SHOULD BE DELETED IF THE DELETE INPUT SCREEN WORKED SUCCESSFULLY.

ACTUAL RESULTS AFTER DELETING 2 DEPARTMENTS USING THE DELETE DEPARTMENT INPUT SCREEN.

SELECT * FROM TBL_PRJ_DEPARTMENT ORDER BY DEPT_CODE
DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J
1661 ALL MISSION 6148953215 ASORI BA

9 rows selected

NOTE: DEPT CODE 1551 AND 1552 HAVE BEEN DELETED.

C. ORIGINAL STATE OF THE DEPARTMENT TABLE BEFORE UPDATING ROWS USING COLDFUSION SCREEN

SELECT * FROM TBL_PRJ_DEPARTMENT ORDER BY DEPT_CODE
DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J
1661 ALL MISSION 6148953215 ASORI BA

9 rows selected

EXPECTED RESULTS AFTER UPDATING 2 DEPARTMENTS USING THE UPDATE DEPARTMENT INPUT SCREEN.

DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON
1555 CHILDRENS GRP 7035895218 ARYTHSON
1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J
1661 ALL MISSION 6148953215 ASORI BA

NOTE: HIGHLIGHTED CELL WILL BE UPDATED. PHONE NUMBER SHOULD BE CHANGED TO 6158942315 AFTER THE UPDATE.

EXPECTED RESULTS AFTER UPDATING 2 DEPARTMENTS USING THE UPDATE DEPARTMENT INPUT SCREEN.

DEPT_CODE DEPT_NAME DEPT_PHONE_NUMBER DEPT_HEAD
——— ————————- —————– ——————–
1553 WOMENS GRP 6145855218 AYUBA R
1554 MENS GRP 6165895215 SMITHSON

1555 CHILDRENS GRP 6158942315 ARYTHSON

1556 YOUTH MINISTRY 6145895214 JOHNSON B
1557 EPISTLES 6145005219 TARY V
1558 OUTREACH 9675895214 GORTLE M
1559 MUSIC 6145897713 ERIC O
1660 ANAKANZO 6148931258 TAKIYAH J
1661 ALL MISSION 6148953215 ASORI BA

NOTE: HIGHLIGHTED CELL WAS UPDATED SUCCESSFULLY. PHONE NUMBER CHANGED FROM 7035895218 TO 6158942315 AFTER THE UPDATE.

Discussion Of Results;

All the cfm scripts tested ok with no issues. One thing to note is: the scripts were run in the following sequence: insert/delete/update.

Still stressed with your coursework?
Get quality coursework help from an expert!