Class07.2_Ch07_Kroenke10_Spring2009 - BCIS 4620...

BCIS 4620
INTRODUCTION TO
DATABASE PROCESSING
Class 7
Spring 2009
Dr. Jack D. Becker

CLASS 7
Relational Database Design
“Pulling It All Together”
•
Announcements
•
Mid-Term POP QUIZ?
•
SQL Applications (Chapter 7 K)
•
SQL Review
–
Addendum A—Relational Terminology--this presentation
•
Database Design Fundamentals
•
Homework #5 Review (TableDesigner & Alameda)

Homework #5 (Alameda
Review)
•
Relation Listings:
–
EMP[ Empno , LastName, FirstName, SSN, …]
–
EMP_SKILLS[ Empno , SkillCode , Date,
TrainingCode, Prim_Sec_Code]
•
Code Tables [Examples]
–
TRAINING[ TCode , TraningType]
–
SKILL[ SkCode , SkillType]
–
PSCODE[PSCode, PS_Definition ]

CLASS07 DOC B1
•
CLASS #8 -- Announcements, misc.., etc.
–
Class Announcements
•
CISO meetings --
–
BUSI 116 5-6:20 p.m
–
ISRC Student Night?
•
Mid-term examination Next Week (120 pts)
–
Some bonus questions (10 points)
–
Chapters 1-7K & Appendix E [SOM]; CN (SQL)
–
NetExpress features
–
TableDesigner features
•
Practice Exam – NOW! On my website!

CLASS #8
MID-TERM EXAM
IN-CLASS, CLOSED BOOK, 120 POINTS
(120 MINUTES)
EXAMINATION SPECIFICATIONS (100 multiple guess questions):
1. MULTIPLE GUESS QUESTIONS: Kroenke chapters 1-7 & Appendix E (80%)
NOTE: Focus on Kroenke textbook and class lecture notes.
1. Additional MULTIPLE GUESS QUESTIONS (20% from assignments) on the following
topics:
a. E-R models; S-O models; TableDesigner
b. NetExpress SQL, SQL/COBOL Statements
1. BONUS points 5 - 10 points (optional, but likely).
•
This is a closed book exam . You will need ONLY a #2 Soft lead pencil and an eraser (Unless
you are really into ERROR-free programming!)
•
The exam will begin approximately 5 minutes after the start of class.
•
NOTE: There will be a short help session on Homework 6 after the examination I expect this
to begin about 10 minutes after the official end of the exam. All are encouraged to attend.

NX SQL & TableDesigner Tips
•
NX SQL
–
An ORDER BY Clause is NOT PERMITTED in a
CREATE VIEW statement ( GROUP BY is OK)
•
TableDesigner –
–
SQL TEXT ONLY (DO not CREATE Database
option)
–
Code is “almost” IBM SQL standard, NOT quite
–
DO NOT put more than one CREATE TABLE
statement in a DBSINPUT file!!!
•
Primary KEYS required in ALL tables!

Homework #5 (Davis Review)
TableDesigner with DAVIS Case
•
SOM
CREATE TABLEs & VIEWs
•
CRUD operations
•
Relation Listings:
–
EMP[ Eno , LastName, FirstName, …]
–
COMM[ Eno , CDate , Commission]

Chapter 7 Kroenke:
Using SQL in Applications &
DB Design Addendum
•
OBJECTIVES:
–
Overview of DB Application Development
( Modified SDLC )
–
Characteristics And Functions Of Database
Application ( CRUD )
–
Materializing Object Views
–
Application Control Mechanism Design
–
Database Design Principles for:
•
Form Design; Report Design and DB Application
Program Design

DB Application Development
Overview – SDLC revisited
•
Requirement Phase
–
Interview Users
–
Build ERDs or SO Models (or DFDs)
•
Design Phase
–
Design Application Controls -- i.e., Menus
–
Design Forms
–
Physical Database Design-- (DSDs) Data Structure Diagrams
–
Design Reports & Program Logic
•
Implementation Phase
–
Build applications with appropriate DBMS tools