Class07.2_Ch07_Kroenke10_Spring2009

Class07.2_Ch07_Kroenke10_Spring2009 - BCIS 4620...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 ARelational 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)...
View Full Document

This note was uploaded on 03/09/2011 for the course BCIS 4620 taught by Professor Staff during the Spring '08 term at North Texas.

Page1 / 105

Class07.2_Ch07_Kroenke10_Spring2009 - BCIS 4620...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online