BCIS 4620--Introduction to Database ApplicationsSpring 2011

wheatauditorSoftware and s/w Development

Oct 30, 2013 (3 years and 5 months ago)

104 views

BCIS 4620
Spring

2011

Dr.

Becker

1

BCIS 4620
--
Introduction to Database Applications

Spring

2011


INSTRUCTOR:

Dr. Jack Becker

OFFICE:

338
D

Business Building


PHONE:

565
-
3113 or 565
-
3110 (ITDS Office)

OFFICE HOURS:

By Appointment and
Tues/
Thur:
1
1
:
3
0
-
1
2
:
3
0 p.m. & 5:00
-
6:00 pm

E
-
MAIL:

becker@unt.edu


URL:

http://www.coba.unt.edu/ITDS/faculty/becker/bcis4620/


Ad
ditional course materials will be distributed in class or
electronically.


COURSE OBJECTIVES


WELCOME! BCIS 4620 is an introduction to database and database management technology
within the framework of a business environment. It includes the study of the
analysis, design,
development, and implementation of database
-
oriented business applications. Upon
completion of the course the student will be able to define, load, and navigate a database
system [IBMS’s DB2 as provided on the MicroFocus Net Express 4.0 w
ith SQL for DB2 CD]
using both COBOL with embedded SQL and SQL query language applications. Students will
also learn to use Entity
-
Relationship and Semantic Object data modeling tools.


COURSE FORMAT

BCIS 4620 will be an intensive programming language lear
ning experience. The amount of
knowledge gained is limited only by each individual's motivation and interest. Students will
study all required readings, complete several individual programming assignments, and
participate in class discussions. There will b
e required midterm and final examinations.


COURSE PREREQUISITES

A grade of "C" or better in each previously taken ITDS course or consent of the Department.
UNT ITDS GPA of 2.70. BCIS 3610 and BCIS 3690 and all pre
-
business required courses.


TEXTBOOKS &
SOFTWARE REQUIRED

(K) Kroenke, David M.,
Database

Processing
:
Fundamentals
,
Design
,
and

Implementation
,
1
1
th Edition, Prentice Hall, 20
10
.



(CD)
MicroFocus Net Express Version
5
.0
/5.1

UE with SQL for DB2.

This CD was
purchased in
your BCIS 3620 class. Yo
u may get a “free” copy of Version 5.0 or 5.1
(for MS
2007/
Vista OS). Copies of this software may be downloaded:

http://microfocus.com/Resources/Communities/Academic/shop/index.asp

(Software)
Below is the information to use IBM 3270 emulator
(IBM System z/
DB2)


https://www.ibm.com/developerworks/uni versity/software/get_software.html

Find by search text:
PCOMM

1)
IBM 3270 emulator
-

download:

IBM Personal Communications

(PCOMM) V6.0.1 for Windows, Multilingual (CZGK8ML)

2)
If you want IBM DB2 Connect enabling connection to DB2 for z/OS
-

download:

DB2 CONN PERSONAL EDITION v8.1 for PComm V5.8

BCIS 4620
Spring

2011

Dr.

Becker

2


OTHER REFERENCES

IBM Manuals & Reference Guides

(
UNT CD ROM Library on the CO
BA network
).

ASSIGNMENTS and OTHER COMPUTING AIDS
.


COURSE WEBSITE


WEBCT will be the primary sources for communication and distribution of materials.
Additional materials for this class may also be found at my course home page on the ITDS
Department we
bsite:

http://www.coba.unt.edu/ITDS/faculty/becker/bcis4620


You have authorization to use COBA microcomputer and term
inal labs to do your class
assignments.

A number of course
-
related datasets will be made available through the course
website.

You will also receive a FREE IBM Account ID and Password at our first class
session.


Specialized tutorial assistance will be p
rovided for students registered in this class. The
location, dates, and times for this service will be announced in class and also on the
Class
website.
The tutor’s primary responsibility is debugging assistance. Each student is
responsible f
o
r the success
ful completion of all assignments. The tutor is NOT responsible for
incorrect interpretations of assignment instructions.



Schedule of Assignments

ASSIGNMENTS/EXAMS

POINTS

BONUS

Comments

H1: SQL Examples

10





H2: SQL Case

10



H3:

SQL/COBOL Examples

10

10



BONUS5: (FILE OUTFILE1 or 2?)



5 (opt)


H4:

SQL and TableDesigner


30



H5:
BONUS; Data Mining Project



10



H6: Database Design/Table Creation

40





H7: SQL Table loads/queries

40





H8: SQL Updates

20





FP: Final
Case Project Folder

100


25

Extra requirements

Early presentation Bonus (optional)



10 (opt)

First 25 volunteers basis

Midterm Exam

120


10

Bonus questions

Final Exam

120


10 (opt)

Bonus questions

Special Course Innovation Awards;

For special help to

other students or faculty



20 cumula
-
tive maximum

Points based on overall
contribution to course

Total/ Bonus:


500

80

Bonus points at
instructor

s discretion


BCIS 4620
Spring

2011

Dr.

Becker

3

BONUS Assignments (
at
instructor’s

option
).
Bonus assignments will always be authorized
at the complete discretion of the instructor. When offered they will always be made available
to every student in the class. While most bonuses will be first offered during class, please,
check you course email for these offers, also.



Assignment Delivery

Instructions:


All assignments are to be placed in the Instructor’s Project Cabinet in the ITDS Suite on the 3
rd

floor.
Projects must be in the cabinet 5 minutes prior to your class meeting time on the date the
assignment is due
. The cabinet will be loc
ked at that time. Any projects turned in after that time will
be graded as late. See late project penalties in Course Polices below. Projects will be returned and
placed back in the cabinet when they are graded. You will be notified by email when they may
be
picked up. Please be careful to not remove or disturb other students’ project folders.


COURSE POLICIES



1.

You should complete all reading assignments prior to class. Written assignments are due, and
will be turned into the instructor, BEFORE

the beginning of class (IN THE STORAGE
CABINENT OUTSIDE 338E IN THE ITDS FACULTY SUITE AREA; THIS CABINENT
WILL BE LOCKED AT 2:00 pm) on the due date.

Late assignments will be penalized
(10% for first day; 20% each additional day late), even if only a few

minutes late.
Repeated late assignments will NOT be accepted. Incomplete work will receive partial
credit. Missing work will receive a grade of zero.



2.

The grade of "I" (Incomplete) is not given except for rare and very unusual emergencies, as
per the General Catalog.



3.

Class roll will be taken at the beginning of the first two classes. Class attendance is your
responsibility. Students should be in their seats before class is scheduled to begin. Do not
come into the classroom after cl
ass has started. If you know you must leave a class session
early, please alert the instructor and sit near an exit.



4.

Missed exams for validated reasons of illness or death will be made up with a comprehensive
exam at the end of the semester. T
his exam, if needed, will be scheduled at the instructor's
convenience during final exam week. These rescheduled exams do not participate in any
curve that may have been applied to the regularly scheduled exam.



5.

Students will adhere to the high
est professional and ethical standards. Plagiarism of any form

will not be tolerated
. Software plagiarism, piracy and theft should be understand by senior
level ITDS majors. All submitted assignments and exams will consist of only the student's
own work. O
btaining the assistance of or copying the work of others is expressly prohibited.
Violators of this policy will be prosecuted to the maximum extent allowed by University
policy. An assignment of a final course grade of "F" and referral to the Dean of Stude
nts for
disciplinary action can be expected.
See Ethics Statement Attached.



6.

Students will use structured programming procedures. Students may use the report writer
feature for all COBOL programs. Students will use MF COBOL. All supporting
docu
mentation will be typed.

BCIS 4620
Spring

2011

Dr.

Becker

4



7.

All submitted work will meet or exceed the standards expected of highly prepared and
motivated information systems professionals. Students will be graded on programming style,
format, and program accuracy. Students wil
l first be given assignment and field specification,
they will use their own test data to do unit and system testing. Production data will be made
available near the time the assignment is due. In some cases, the instructor may not make
production data ava
ilable but will execute the student's programs against the production data.



8.

It is the student's responsibility to satisfy all the requirements of this course as specified by
this course outline, the instructor, the academic calendar, and Unive
rsity regulations. Hence,
ignorance of class or University requirements will not be accepted as an excuse.



9.

The instructor, tutors and teaching assistants will not debug student programming errors. We
will, however, answer specific questions ab
out course topics.



10.

In class presentations will be evaluated for quality of communication skills as well as
technical quality. When making a presentation, assume that you are "selling" your system to
the customer. See PRESENT.DOC on website.







AMERICANS WITH DISABILITIES ACT INFORMATION



The College of Business Administration complies with the Americans with Disabilities Act in
making reasonable accommodation for qualified students with disability.



If you have an established disability as
defined in the Americans with Disabilities Act and
would like to request accommodation please see me as soon as possible.



BCIS 4620
Spring

2011

Dr.

Becker

5

BCIS 4620
--

Spring

2011

SEMESTER SCHEDULE
[Rev:
1
/
2
0
/
2011
]

WEEK

DATE

TOPIC/ ASSIGNMENT/ PROJECT DUE
/
K:Kroenke;CD:NX/
z
DB2; CN:Notes

1

Jan

2
0

Introduction to Course, SQL, Data Structures:
K:

Chapter 1 & App C;
C
D
: NX
/zDB2

Tour

2

Jan 27

Introduction to NX with SQL, and SQL Language.
K:

Ch 2 & 7 (SQL)
; C
N
: (NX) IDE
; zDB2


3

Feb 3

Data Modeling: Relational Models & Normalization; (NX)
IDE;
K:Ch 3 & 4; CD: Ch2




Due: H1


SQL Tutorial Examples

4

Feb 10

Data Modeling: ERDs; Normalization;

Embedded SQL/COBOL programs;

K: Chapter 5




Due: H2

SQL Examples

5

Feb 17

Semantic Object Model & Normalization.
K: App
endi
x. E; CD: & CN: TBA




Due: H3

SQL Case


6

Feb 24

Database Design, ERDs & SOMs, SQL Applications.
K: Chapter 6; CD& CN: TBA




Due: H4

H
4
: SQL Applications & SOM

7

Mar 3

DBP for Data Warehouses. SPECIAL GUEST SPEAKER (
MicroSoft
SQL Server)

SQL Foundations
K: Chap
s.

7; Exam Previ ew
.




Due: H5

H5:
Speci al Probl em; BONUS

8

Mar 10

MID
-
TERM EXAM (K: Chaps. 1
-
7; CD: TBA; CN: TableDesigner )


Mar 13
-
19

SPRING BREAK!!

9

Mar
24

Review Exam; Menu Systems; and Discuss CASE project; CD

& CN: TBA




Due: H6

H6: Database Design; ERD & SOM; Table Creates

10

Mar
31

& DB Application Redesign.
Relational

Implementation
; Menu Management Systems;

CD & CN:
MX; TBA; K: Chap. 8

11

Apr 7

Multi
-
user DB; Relational Implementation: K: Ch. 9; CD &
CN: TBA




Due: H7

Table Loads, SQL Queries

12

Apr
14

DBP for Business Intelligence; Data Warehouses. K: 15




Due: H8

SQL Updates; Menus

13

Apr
21

Client
-
Server Database Systems, Sharing Enterprise Data, DA vs. DBA. K: Chs 9 & 15
(continued); SPECIAL
GUEST SPEAKER (TBA)

14

Apr

2
8

Client
-
Server Database Systems, Sharing Enterprise Data, DA vs. DBA. K: Chs 9 & 15
(continued); SPECIAL GUEST SPEAKER (TBA)


Apr 29

Due: FP

FP: Final Case Project (
5

p.m.,
Apr 29
,
FRI
)

15

May
5

Exam Review; Class Evaluati on
s; Project Presentations (TBA)

16

May 1
0
(Tues)

DAY

--
Final Exam
1
:30
-
3:30

pm


SEMI
-

COMPREHENSIVE

BCIS 4620
Spring

2011

Dr.

Becker

6


Schedule of Assignments


ASSIGNMENTS/EXAMS

POINTS

BONUS

Comments

H1: SQL Examples

10





H2: SQL Case

10



H3: SQL/COBOL Examples

10

10



BONUS5: (FI
LE OUTFILE1 or 2?)



5 (opt)

Cancelled

H4: SQL/COBOL Queries



10

Cancelled

H5: SQL and TableDesigner

30





H6: Database Design/Table Creation

40





H7: SQL Table loads/queries

40





H8: SQL Updates

20





FP: Final Case Project Folder

100


25

Ex
tra requirements

Early presentation Bonus (optional)



10 (opt)

First 25 volunteers basis

Midterm Exam

120


10

Bonus questions

Final Exam

120


10 (opt)

Bonus questions

Special Course Innovation Awards;

For special help to other students or faculty



2
0
cumulative
maximum

Points based on overall
contribution to course

Total/ Bonus:


500

80

Bonus points at
instructors discretion


BCIS 4620
Spring

2011

Dr.

Becker

7

ASSIGNMENT REQUIREMENTS



1.

Assignments will be neatly prepared. Place all materials in a secure protec
tive cover (for example, a
soft cover 3
-
hole binder) of appropriate size. Clearly label all assignments. Include an itemized Table
of Contents (with tab references). Use dividers and labeled tabs. Clearly type on the front of each
computer listing its name

and purpose.



2.

Generate summary details in your transaction processing and error reports. Give detailed record count
(selected, not
-
selected, total, etc.) subtotal and grand total information. Document your programs in
COBOL and all pro
gramming languages used in the course. Use MIXED upper and lower case in
your reports and screens. Verify and validate your input data.



3.

COBOL programs should use 88s with VALID VALUES ARE; LABEL RECORDS ARE
STANDARD; one READ at the be
ginning of the process section; Report Writer multiple detail lines
and declaratives, if appropriate; Avoid nested IF clauses. Avoid having too many 1 or 2 sentence
SECTIONS.



4.

Update transaction processing reports will list what was cha
nged or deleted (print both the old and
new information). HIGHLIGHTING changed or updated information is strongly recommended. Do
not simply list the transaction information. Desk

check your reports.

Reports
MUST

be accurate.



DATABASE FINAL PROJECT REQU
IREMENTS



The purpose of the Database final project is to give you experience in analyzing a problem, designing an
appropriate database solution, and implementing your solution. You will turn in a complete and formal application
project system document at

the end of the semester. The project will follow all of the normal assignment course
requirements.



The reading assignments, lectures and assignments all combine to give you the necessary tools to be able to
complete the application project successfully.

The course modules and assignments are cumulative.



You will turn in, at milestone points in the semester, designated components of your DB2 application project.
These will be reviewed and returned.



You will correct any noted deficiencies in the miles
tones before including that material in the final project system
document.




BCIS 4620
Spring

2011

Dr.

Becker

8

FINAL DATABASE PROJECT
--

SAMPLE OUTLINE*



The project system document will contain all of the following*:



Title Page



Detailed Table of Contents



Executive Summary

(1
-

2
pages; Recommendations included); See EXECSUM.DOC.



Project Specifics

(narrative form; approximately 1 page for each section below):




A.

Overview of the business environment; discussion of the business, its organization structure and

the environment (competition, etc.) in which it operates. This section may take several pages.


B.

Description of the system design:

1. Technical specifications (what hardware, system software, etc?)

2. Operational functionality (major

systems functions)

3. Operational procedures ("manual" start
-
up, run, etc. instructions; similar to the READ.ME files
in software packages)

4. Description of database design

5. Assumptions made and system limitations

6. Recommended future enhancements

7.
Description of end of quarter and year close out procedure (by file). What was implemented and
what will/should be implemented?

8. Test procedures followed; how did you test the system to "prove" it works accurately.

9. Anomaly prevention features & data i
ntegrity controls

10. Systems security and control features


C.

Conclusions



Appendices


A.

Diagrams:

1. Relation Listing

2. Semantic Object Diagrams (TableDesigner or equivalent)

3. E/R diagram showing keys, foreig
n keys, binary and mandatory/optional relationships (Oracle
Designer; ACCESS, or equivalent)

4. Hierarchy Chart for Menu System


B.

Relation and Data Definitions (Reports from TableDesigner and ACCESS):

1. Relation and Key Definitions (
SOMs from TableDesigner or equivalent)

2. Domain Definitions in alphabetical order (ERDs from ACCESS or equivalent)


C.

All Table CREATEs and DATA LOADs: SQL files, and listing of ALL tables showing their data
contents


D.


Menu System programs and screen prints


E.

Example output of the execution of each of the programs, procedures, and screen prints as needed.


F.

Proof of System Operation (Add, Updates, Deletes)



*Additional
requirements will be added as the student becomes more familiar with DB2/SQL




BCIS 4620
Spring

2011

Dr.

Becker

9

ETHICAL BEHAVIOR IN ITDS CLASSES

The UNT policy can be found at
http://vpaa.unt.edu/academic
-
integrity.htm

(Student
Copy)



The ITDS Department expects its students to behave at all times in an ethical and legal manner. There are at least
two reasons for this. First, ethical behavior affirms the personal value and worth of the individual. Second, both IT
and Decision Sc
ience professionals frequently handle confidential information on behalf of their employers and
clients. Thus employers of BCIS and DSCI graduates expect ethical conduct from their employees because that
behavior is crucial to the success of the organizati
on.



Academic dishonesty is a major violation of ethical and legal behavior. The ITDS Department defines academic
dishonesty as claiming the work of others as your own, or using illegal or unapproved means to raise your grade in
a class. Examples include:

copying answers from another person’s paper; using unapproved notes during an exam;
copying computer code from another person’s work; having someone else complete your assignments or take tests
on your behalf; stealing code printouts, software, or exams;
recycling assignments submitted by others in prior or
current semesters as your own; and copying the words or ideas of others from books, articles, reports,
presentations, etc. for use as your own thoughts without proper attribution (i.e., plagiarism). It
does not matter
whether you received permission from the owner of the copied work; claiming the material as your own is still
academic dishonesty.



The ITDS Department believes it is very important to protect honest students from unfair competition with
anyone
trying to gain an advantage through academic dishonesty. Consequently, there will be in
-
class testing to validate
all major assignments you complete out of class. This may be accomplished by examination, oral reports,
individual

interviews or any ot
her means your professor may deem appropriate. You must pass these validation
tests with a grade of “C” or better to have your out
-
of
-
class work count in your term grade. Further, the student
grade for academic dishonesty in BCIS classes is an immediate “F
” for the course involved and referral of the case
to the COBA Academic Advising Office.



By my signature below, I attest that I understand the above policy. I will behave ethically in this class, and will
encourage my classmates to behave ethically. I al
so understand that I have a moral responsibility to report to my
instructor any suspected case of academic dishonesty in this class.





__________________________________________________________________________

Print your name and give your signature.





___________________________

_______/______/
2011

Student ID number

Today’s date





My course scores my be published using the last 5 digits of my student number



(SSN) __ __ __ __ __ ; or the following 5
-
chara
cter code: __ __ __ __ __.



If both number were left blank, your scores will NOT be published.



This is YOUR COPY. Turn in the copy below.

BCIS 4620
Spring

2011

Dr.

Becker

10

Leave Blank
BCIS 4620
Spring

2011

Dr.

Becker

11

ETHICAL BEHAVIOR IN ITDS CLASSES

(Instructor’s Copy)



The ITDS Department expects its students to b
ehave at all times in an ethical and legal manner. There are at least
two reasons for this. First, ethical behavior affirms the personal value and worth of the individual. Second, both IT
and Decision Science professionals frequently handle confidential in
formation on behalf of their employers and
clients. Thus employers of BCIS and DSCI graduates expect ethical conduct from their employees because that
behavior is crucial to the success of the organization.



Academic dishonesty is a major violation of eth
ical and legal behavior. The ITDS Department defines academic
dishonesty as claiming the work of others as your own, or using illegal or unapproved means to raise your grade in
a class. Examples include: copying answers from another person’s paper; using u
napproved notes during an exam;
copying computer code from another person’s work; having someone else complete your assignments or take tests
on your behalf; stealing code printouts, software, or exams; recycling assignments submitted by others in prior or

current semesters as your own; and copying the words or ideas of others from books, articles, reports,
presentations, etc. for use as your own thoughts without proper attribution (i.e., plagiarism). It does not matter
whether you received permission from
the owner of the copied work; claiming the material as your own is still
academic dishonesty.



The ITDS Department believes it is very important to protect honest students from unfair competition with anyone
trying to gain an advantage through academic d
ishonesty. Consequently, there will be in
-
class testing to validate
all major assignments you complete out of class. This may be accomplished by examination, oral reports,
individual

interviews or any other means your professor may deem appropriate. You mu
st pass these validation
tests with a grade of “C” or better to have your out
-
of
-
class work count in your term grade. Further, the student
grade for academic dishonesty in BCIS classes is an immediate “F” for the course involved and referral of the case
to

the COBA Academic Advising Office.



By my signature below, I attest that I understand the above policy. I will behave ethically in this class, and will
encourage my classmates to behave ethically. I also understand that I have a moral responsibility to r
eport to my
instructor any suspected case of academic dishonesty in this class.



__________________________________________________________________________

Print your name and give your signature.



___________________________

_______/______/
201
1

Student ID number

Today’s date


My course scores my be published using the last 5 digits of my student number



(SSN) _
_
_ _
_
_ _
_
_ _
_
_ _
_
_ ; or the following 5
-
character

(NUMERIC)

code: _
_
_ _
_
_ _
_
_ _
_
_ _
_
_.


If both
num
bers

were left blank, your scores will NOT be published.

BCIS 4620
Spring

2011

Dr.

Becker

12

GENERAL STATEMENT OF UNDERSTANING IN ITDS CLASSES

I have read the COURSE SYLLABUS and BCIS 4620 Policies and Procedures and the
Ethical Behavior in ITDS Classes statement of understanding.




I agr
ee to abide by the COURSE SYLLABUS, all of its Policies and Procedures, and the
Ethical Behavior in ITDS Classes statement:


_
_
_______



(Initial
s
)

I am going to drop this course immediately.

_________



(Initial
s
)



_________________________



_______
_____________________




_____ / ____ /
2011

Signature



Print your name



Date: month/day/year