Class12-15_Kroenke15_Spring2009

Class12-15_Kroenke15_Spring2009 - BCIS 4620 Database...

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

View Full Document Right Arrow Icon
BCIS 4620 Database Processing Classes 12 - 15 Spring 2009 Dr. Jack D. Becker
Background image of page 1

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

View Full DocumentRight Arrow Icon
Classes 12 to 16 [Spring] Classes 12 – 14: Chapter 15 Chapter 15 – Shared Enterprise Data --Distributed Databases Final Project Requirements Review Class Evaluations & Sample Exam Questions Class 13 and/or: Guest Lecturer(s) Remaining lecture materials Class 14: Finish any outstanding materials; Guest speakers: [BONUS: 5 points attendance; plus 5 pts. For second speakers] UNT CITC Business Intelligence Department; Tony Keller, Director, Data Warehousing, TX Health Resources Final Projects Due: 5 pm; Friday, April 30 th Class 15 May 7 Final Exam Review; Finish Class Notes ( Slide 60-90 ). Class Evaluations & Sample Exam Questions Bonus Survey (5 pts) Project RETURN (Prior to class time) Class 16 May 14 ( EXAM ) FINAL EXAM (1:30 pm – 3:30 pm)
Background image of page 2
Homework #7 (Alameda) Alameda Case -- DB Design Dataloads: Employee, Next_Of_Kin, Skill_Info, Project, Salary, etc. Code Tables, Intersection Tables Report Requirements: Menu Central Cities Health Club Case Reports as specified
Background image of page 3

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

View Full DocumentRight Arrow Icon
Homework #8 ALAMEDA Alameda – Add/Update Programs Employee, Skills_Training, Project, Salary, Kin, Race, Citizenship, etc. . Report Requirements: 1. State Government Report by Education Level of Worker 2. Federal Government Report(s) which provides information on the percentage of each by: a. minority worker category; b. gender; c. age; and d. citizenship status. NOTE: This may be 4 separate reports. 3. Insurance Company reports with required Next-of-kin data. 4. Employee Skill/Training Status report--Must include both skills and training 5. Employee Salary/History Report--Must include at their current title and salary at least. 6. Employee Roster with key data for each employee (name, address, phone, SSN, etc.). Indicate type of sorting in HEADING. 7. Employee Project Report (sort by Project, and Name, show skills)
Background image of page 4
Final Project Due Date FINAL PROJECT DUE -- 5 pm Thur Apr 30 Deadline for Penalty-free final project! 10% Penalty , if turned in by 5pm on Fri. 30% Penalty , if turned in by 5pm on Mon. 50% Penalty , if turned in by 5pm on Tue. etc…
Background image of page 5

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

View Full DocumentRight Arrow Icon
Homework #9-Final Project Alameda – Add/Update Programs Add/Updates: Employee, Next_of_Kin, Skills_Info, Work_History, Project, Race, Citizenship, Education, Skills_Titles, etc. Intersection Table(s) Report Requirements: Employee, Insurance, Government Reports, etc. Hierarchical Menu Design
Background image of page 6
Sample Project Main Menu Main Menu Membership Menu Billing Menu, etc. Add New Member Update/Delete Member/Family Member List; Mail Labels Query Database
Background image of page 7

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

View Full DocumentRight Arrow Icon
Classes 14 [Speaker] Class 13 - 15: Guest Lecturer [BONUS: 5 points attendance] TBA
Background image of page 8
Final Exam Preview 120 Points; 100 Multiple Guess questions 65% -- Last Chapters: 8, 9 & 15 35% -- Miscellaneous: NetExpress with DB2 Option questions about software Database Design Concepts from throughout the semester TableDesigner Software SQL programming questions from throughout the semester ( BACK )
Background image of page 9

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

View Full DocumentRight Arrow Icon
General System Menu LOGME Utility Menu Exit Main Menu E-Mail Change Password Exit Optional System Level Menu Items
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the 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 / 109

Class12-15_Kroenke15_Spring2009 - BCIS 4620 Database...

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

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