Corporate Technology Center
Final Report: Database Implementation
Submitted to Dr. Hae Choi
of the
Savannah State University
in Partial Fulfilment
of the Requirement for the Systems Analysis and Design: CISM 3137
in College of Business Administration
Jennifer Mosha
April 19, 2012
CONTENTS
Introduction ........................................................................................................................... 1-3
Project Overview ................................................................................................................... 1
Scope of the Project ............................................................................................................... 2
Document Project Outline...................................................................................................... 3
Project Overview ...................................................................................................................... 4
ERD Diagram & Relational Diagram ................................................................................. 5-6
ERD Diagram………………………………………………………………………………5
Relational Diagram…………………………………………………………………………6
Data Dictionary ..................................................................................................................... 7-8
Prototyping the Database ................................................................................................... 9-20
Tables…………………………………………………………………………………..9-13
Queries………………………………………………………………………………..14-15
Forms…………………………………………………………………………………16-18
Reports………………………………………………………………………………..19-20
Splash Screen.....................................................................................................................21
Switchboard........................................................................................................................21
Conclusion .............................................................................................................................. 22
Appendix ............................................................................................................................ 23-26
ii
INTRODUCTION
Project Overview
When dealing with technology updates, various issues can arise with sometimes no
solution; however, this project offers a new outlook. The real-world problem solved here is
that end users (clients of CTC) will be able to have more input concerning the integration of
technology into their companies and will be able to apply the technical knowledge they will
gain. Technology should be seamless, and though businesses may require IT departments, it
does increase the productivity of a company’s workforce if the majority is able to support
some technological needs.
1
Project Scope
An analysis of the current method for the delivery and availability of seminars has
resulted in the conclusion that it can be improved with an information system. This system
should be able to support scheduling software for seminar dates which will work in
conjunction with virtual classrooms, similar to an e-learning environment, with live
streaming video. In addition, mass email software will be present within this potential system
that will send information to the executives listed in the integrated clientele database, to keep
them abreast of any happenings with Corporate Technology Center (CTC).
Success with this project may be measured from monitoring customer feedback. It can
be ascertained by an increase in CTC’s customer base and customer retention. Also the
preferred method between regular seminars and the newly designed seminar environment can
be exhibited by the difference in client enrolment size. Once implementation and operation
have proved successful and discrepancies with the system area at a minimum, the project is
considered to be approaching closedown.
Another alternative would be to hire more staff so that more seminars could be hosted
during the week. However, hiring more staff, expanding infrastructure and advertising would
prove to be costly in the short run. The chosen solution would be costly in the short run as
well, but over a long term span the benefits will outnumber the costs. Also, communication
between CTC and the customer would improve and provide networking opportunities, and
gives CTC a more competitive edge over other companies such as itself.
Presently, the only constraint noted is the willingness of staff members to accept the
new system and to familiarize themselves with it and to deliver what the system may require
of them.
2
Document Project Outline
This document will serve as the final report for the project undertaken. It will provide
a detailed project overview, conceptual diagram, and relational database diagrams. However
the main focus of this document is to reveal a prototype of the project’s database.
Additionally, accomplishments gained during the execution of this project will be noted and
an appendix will be provided.
3
PROJECT OVERVIEW
The intended users of this system are the local business executives and their
employees who are current and prospective clientele of Corporate Technology Center (CTC).
They will be able to interact with the system for educational purposes and any related
communication. The main functionality of the proposed system is to educate the clientele
(end-users) about new technology, its functions and its viability in order to broaden their
technical expertise and to improve the efficiency of daily business activities.
The end-users will be able to gain from the proposed system by being able to access
the seminars at almost any place, at anytime. They will also be able to correspond with
instructors should the need arise to do so. The system will aid CTC’s instructors to supply
evaluations as per client and keep them abreast of their progress with any seminar.
Essentially CTC’s seminar environment will be improved with the customer’s needs in mind.
4
ERD DIAGRAM & RELATIONAL DIAGRAM
ERD Diagram
5
ERD DIAGRAM & RELATIONAL DIAGRAM
Relational Diagram
6
DATA DICTIONARY
TABLE NAME ATTRIBUTE
NAME
DESCRIPTION DATA TYPE PK or FK
SCHEDULE SEM_NUM Seminar number CHAR (5) PK
CLT_IDNUM Client ID
Number
CHAR (5) PK (FK)
SEM_NAME Seminar name VARCHAR (20)
SEM_TIME Seminar time TIME (hh:mm)
LCTN Location VARCHAR (20)
INSTR Seminar
Instructor
VARCHAR (20)
CLIENT CLT_IDNUM Client ID
number
CHAR (5) PK
CLT_LNAME Client last name VARCHAR (20)
CLT_FNAME Client first name VARCHAR (20)
CMPY_NAME Company name VARCHAR (20)
EVALUATION CLT_IDNUM Client ID
number
CHAR (5) PK (FK)
INSTR Seminar
Instructor
VARCHAR (20)
SEM_NAME Seminar name VARCHAR (20) FK
COMMENT Instructor’s
comments
VARCHAR (500)
PROGRESS
REPORT
CLT_IDNUM Client ID
number
CHAR (5) PK (FK)
SEM_NUM Seminar number CHAR (5) PK (FK)
GRADE Letter Grade VARCHAR (5)
SEMINAR SEM_NUM Seminar number CHAR (5) PK
SEM_NAME Seminar name VARCHAR (20)
7
DATA DICTIONARY
FK Foreign key
PK Primary key
CHAR Fixed character length data
VARCHAR Variable character length data
TIME Numeric data
8
PROTOTYPING THE DATABASE
TABLES
Client Table
Client ID Number Company Name Client Last Name Client First Name
1245 Urban Nights Event Planning Smith Jonathan
1458 Summit Communications Phillips Victor
2233 Celergy Networks Walker Elizabeth
3556 Benson & Associates Law Firm Taylor Anne
4356 Gregg Communications Knight Henry
4786 Thomson Internet Company Miller Gregory
5852 McKinley Consultants Grant Ben
6322 H&D Interior Design Garcia Richard
6463 Walters Chartered Accountants Jensen Dean
6789 The Pegasus Hotel Crawford James
7834 Urban Nights Event Planning Hall Katherine
8576 Urban Nights Event Planning Madison Andrew
8931 Benson & Associates Law Firm Moore Andy
9111 H&D Interior Design Anderson Gabrielle
9731 Walters Chartered Accountants Reynolds Samantha
9
PROTOTYPING THE DATABASE
TABLES
Evaluation Table
Client ID Number
Seminar Name Instructor Comment
1245 Data Manipulation and Formatting (Microsoft Word 2007)
Mrs A. Brown
Exemplary student. Excellent understanding of coursework and application.
1458 Data Communications and VoIP Training
Dr. C Roberts
Good student. More training needed for VoIP.
2233 Network Infrastructure Dr. C Roberts
Good student. Should consider career as network administrator.
3556 Windows Vista: A Company's Best Asset
Mrs. A Mayfield
Exemplary student. Excellent understanding of coursework and application.
4356 Administrative Technical Support Dr. K Lee Exemplary student. Excellent understanding of coursework and application.
4786 Google Chrome: Advanced Features
Dr. G Wade
Exemplary student. Excellent understanding of coursework and application.
5852 Advanced Database Design (Microsoft Access 2007)
Dr. C Smith
Exemplary student. Excellent understanding of coursework and application.
6322 Customer Communications with GMC Software
Dr. L Patterson
Exemplary student. Excellent understanding of coursework and application.
6463 Finance and Formulas (Microsoft Excel 2007)
Dr. F Londry
Exemplary student. Excellent understanding of coursework and application.
6789 Collaboration in the Workplace (Microsoft SharePoint 2007)
Dr. F Londry
Good student. Made great progress from the start.
7834 Adobe Dreamweaver: Intermediate
Dr. L Patterson
Good student. Should take course on Mastering Webpage Design.
8576 Social Media and Your Company Mrs. A Brown
Exemplary student. Excellent understanding of coursework and application.
8931 Microsoft Word 2010 for Beginners
Mrs. A Brown
Exemplary student. Excellent understanding of coursework and application.
9111 Mastering Webpage Design Dr. C Smith
Exemplary student. Excellent understanding of coursework and application.
9731 Graphical Creation and Analysis (Microsoft Excel 2007)
Dr. K Lee Exemplary student. Excellent understanding of coursework and application.
10
PROTOTYPING THE DATABASE
TABLES
Progress Report Table
Client ID Number Seminar Number Grade
1245 2112 A
1458 2114 B
2233 2185 B
3556 2258 A
4356 2356 A
4786 3698 A
5852 3587 A
6322 3471 A
6463 3412 A
6789 5410 B
7834 5200 B
8576 4555 A
8931 5555 A
9111 4444 A
9731 6102 A
Seminar Table
Seminar Number Seminar Name
2112 Data Manipulation and Formatting (Microsoft Word 2007)
2114 Windows Vista: A Company's Best Asset
2185 Graphical Creation and Analysis (Microsoft Excel 2007)
2258 Microsoft Word 2010 for Beginners
2356 Administrative Technical Support
3412 Mastering Webpage Design
3471 Advanced Database Design (Microsoft Access 2007)
3587 Google Chrome: Advanced Features
3698 Finance and Formulas (Microsoft Excel 2007)
4444 Collaboration in the Workplace (Microsoft SharePoint 2007)
4555 Adobe Dreamweaver: Intermediate
5200 Network Infrastructure
5410 Social Media and Your Company
5555 Data Communications and VoIP Training
6102 Customer Communications with GMC Software
11
PROTOTYPING THE DATABASE
TABLES
Schedule Table
Seminar Number Client ID Number Seminar Name Seminar Time Location Instructor
2112 1245 Data Manipulation and Formatting (Microsoft Word 2007)
April 23- July 19 Online Webinar Mrs A. Brown
2114 1458 Data Communications and VoIP Training
April 23- July 19 Online Webinar Dr. C Roberts
2185 2233 Network Infrastructure
April 23- July 19 Online Webinar Dr. C Roberts
2258 3556 Windows Vista: A Company's Best Asset
April 23- July 19 Online Webinar Mrs. A Mayfield
2356 4356 Administrative Technical Support
April 23- July 19 Online Webinar Dr. K Lee
3412 6463 Finance and Formulas (Microsoft Excel 2007)
April 23- July 19 Online Webinar Dr. F Londry
3471 6322 Customer Communications with GMC Software
May 2-August 8 Online Webinar Dr. L Patterson
3587 5852 Advanced Database Design (Microsoft Access 2007)
May 2-August 8 Online Webinar Dr. C Smith
3698 4786 Google Chrome: Advanced Features
May 2-August 8 Online Webinar Dr. G Wade
4444 9111 Mastering Webpage Design
May 2-August 8 Online Webinar Dr. C Smith
4555 8576 Social Media and Your Company
May 2-August 8 Online Webinar Mrs. A Brown
5200 7834 Adobe Dreamweaver: Intermediate
May 2-August 8 Online Webinar Dr. L Patterson
5410 6789 Collaboration in the Workplace (Microsoft SharePoint 2007)
June 6-September 12 Online Webinar Dr. F Londry
12
PROTOTYPING THE DATABASE
TABLES
Schedule Table (continued)
Seminar Number Client ID Number Seminar Name Seminar Time Location Instructor
5555 8931 Microsoft Word 2010 for Beginners
June 6-September 12 Online Webinar Mrs. A Brown
6102 9731 Graphical Creation and Analysis (Microsoft Excel 2007)
June 6-September 12 Online Webinar Dr. K Lee
13
PROTOTYPING THE DATABASE
QUERIES
Clients with Grade B Query
Client ID Number Client First Name Client Last Name Company Name Grade
1458 Victor Phillips Summit Communications B
2233 Elizabeth Walker Celergy Networks B
6789 James Crawford The Pegasus Hotel B
7834 Katherine Hall Urban Nights Event Planning B
Instructor Brown Query
Client ID Number Client First Name Client Last Name Instructor
1245 Jonathan Smith Mrs. A Brown
8931 Andy Moore Mrs. A Brown
8576 Andrew Madison Mrs. A Brown
Clients in April Query
Client ID Number Client First Name Client Last Name Seminar Time
1245 Jonathan Smith April 23- July 19
1458 Victor Phillips April 23- July 19
2233 Elizabeth Walker April 23- July 19
3556 Anne Taylor April 23- July 19
4356 Henry Knight April 23- July 19
6463 Dean Jensen April 23- July 19
14
PROTOTYPING THE DATABASE
QUERIES
Urban Nights Event Planning Query
Client ID Number Client First Name Client Last Name Company Name
1245 Jonathan Smith Urban Nights Event Planning
8576 Andrew Madison Urban Nights Event Planning
7834 Katherine Hall Urban Nights Event Planning
Clients with Last Name M Query
Client ID Number Client Last Name Client First Name
8576 Madison Andrew
8931 Moore Andy
4786 Miller Gregory
15
PROTOTYPING THE DATABASE
FORMS
Mainform/subform
Combo Box Form
16
PROTOTYPING THE DATABASE
FORMS
Master form
Multipage form (page 1)
17
PROTOTYPING THE DATABASE
FORMS
Multipage form (page 2)
18
PROTOTYPING THE DATABASE
REPORTS
Report 1
Report 2
19
PROTOTYPING THE DATABASE
REPORTS
Report 3
20
PROTOTYPING THE DATABASE
Splash Screen
Switchboard
21
CONCLUSION
With this project, I have gained experience in understanding what it means to imagine, to
construct and to develop a system. The systems development life cycle (SDLC) proved to be
a challenging task to execute, especially by myself. Out of all the steps, I found systems
analysis to be the most tedious and detail oriented because of my attempt to tailor the system
to suit the client’s needs. As soon as one area is changed or adjusted, I realized that another
area of the system would require attention in order to match the previous portion. Otherwise,
the system would be considered incomplete. As for accomplishments, this project has proven
to be a feasible solution to the problem listed in the case study and assists the company’s
processes by being more efficient. Also, I have spent more time working with spreadsheet
software as well as database management system software.
In the future, I hope to expand this project by integrating into a network for actual use. At
first it will be for testing purposes only, and eventually it will be used in everyday life. In
terms of development, I would like to integrate the concept of social media with the learning
management system. Just as how social media allows individuals to interact and
communicate with one another, is it not possible to do the same with education? There will
be a social media site associated with the system whereby clients of different companies will
be able to share ideas and opinions about seminars, to offer advice about business ventures
and to build networking opportunities. Clients will be able to create and display their business
profile and chat rooms would be created to connect those who are taking the same seminars.
This could possibly lead to better grades and evaluations of clients and later, excellent
customer retention.
Overall, I can say that this project has benefitted me by indicating what may be expected of
me as a possible systems analyst.
22
APPENDIX
By Jennifer Mosha
Client: Corporate Technology Center
Real world problem solved: Gaining
technical expertise throughout the company
and seamless technology made possible
End-users are business executives and their employees
Interact with the system for educational purposes and communication
Access seminars anywhere, anytime
Correspond with instructors
Progress reports and evaluations can be generated
23
APPENDIX
Assists visualization of data concepts and
structures
Tables, queries, forms and reports
Splash screen and switchboard
Sample of table Client ID Number Company Name Client Last Name Client First Name
1245 Urban Nights Event Planning Smith Jonathan
1458 Summit Communications Phillips Victor
2233 Celergy Networks Walker Elizabeth
3556 Benson & Associates Law Firm Taylor Anne
4356 Gregg Communications Knight Henry
4786 Thomson Internet Company Miller Gregory
5852 McKinley Consultants Grant Ben
6322 H&D Interior Design Garcia Richard
6463 Walters Chartered Accountants Jensen Dean
6789 The Pegasus Hotel Crawford James
7834 Urban Nights Event Planning Hall Katherine
8576 Urban Nights Event Planning Madison Andrew
8931 Benson & Associates Law Firm Moore Andy
9111 H&D Interior Design Anderson Gabrielle
9731 Walters Chartered Accountants Reynolds Samantha
24
APPENDIX
Sample of query
Client ID Number Client First Name Client Last Name Instructor
1245 Jonathan Smith Mrs. A Brown
8931 Andy Moore Mrs. A Brown
8576 Andrew Madison Mrs. A Brown
Sample of combo box form
Sample of report
25
APPENDIX
Splash Screen
Switchboard
Project is a feasible
solution
More hands on with
spreadsheet and
database software
Future: Integrate
social media?
26