Class01_Spring_2010

Class01_Spring_2010 - BCIS 4620 BCIS INTRODUCTION TO...

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

View Full Document Right Arrow Icon
BCIS 4620 BCIS 4620 INTRODUCTION TO INTRODUCTION TO DATABASE PROCESSING DATABASE PROCESSING Spring 2010 Spring 2010 Dr. Jack D. Becker 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
CLASS 1-Overview of File Welcome Class Rolls Review Syllabus Miscellaneous Course Announcements CDIT Student Night (Fall usually) th Edition Class Notes will be distributed as needed (FREE) IBM DB2] MicroFocus NetExpress 5.1 w/.NET Option-Vista 2007 http://microfocus.com/Resources/Communities/Academic/shop/index.asp Course Overview and Objectives
Background image of page 2
MicroFocus Net Express 5.0/5.1 UE Self-Install Instructions in Start file (or Run) x :\setup.exe /r (where x is the CD drive) Must have MS Internet Explorer 6.0 to install software. Must have Adobe Acrobat 5.0 or higher to read documentation MS IE 6.0 Adobe Acrobat 5.0 If necessary paste the following address in IE: File///X:/autorun/html/start.htm (where X is CD drive) Do not install 5.1 .NET option, unless you have Visual Studio installed already and MS Vista/2007 O/S Install all options, especially SQL/DB2 Except UNIX & .NET
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Database Modeling Software TableDesigner™ Free version at the following website: www.pearsonhighered.com/kroenke/ Also, downloadable on course website Go to textbook website for TableDesigner download info. TableDesigner is a Semantic Object database modeling tool alternative to ER Diagrams [ERDs]
Background image of page 5

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

View Full DocumentRight Arrow Icon
Spring 2010 [DRAFT] BCIS 4620 Lab Tutor Note: Tutor in Room 333 or 151 were noted Spring 2010
Background image of page 6
Chapter 1 Kroenke INTRODUCTION TO DATABASE PROCESSING Mainframes to Micros (IMS, TOTAL, ORACLE, SQL/DS, DB2, ACCESS) File Processing, Hierarchical DB, Relational DB SQL (Structured Query Language) Standard Legacy Systems – “YR2K” remembered MICROSOFT ACCESS a NEW “standard”
Background image of page 7

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

View Full DocumentRight Arrow Icon
CHAPTER 1 Introduction to DB Processing Information (reports) vs. Data Hierarchy of Data Elements [next slide] File Processing (COBOL) vs. Database Processing (Access, SQL/DS, etc.)
Background image of page 8
Hierarchy of Data Elements B i t s B y t e s o r C h a r a c t e r s F i e l d s R e c o r d s F i l e s D a t a b a s e ( F i l e s , M e t a d a t a , I n d e x e s , A P M e t a d a t a Relational DBMS Database Tables Rows Columns Characters or bytes Bits Traditional DB
Background image of page 9

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

View Full DocumentRight Arrow Icon
File Processing Systems Better than manual, but have limitations Data is separate and isolated: Programs (COBOL) which must process data in multiple files are complex (JCL) Data redundancy common; Leads to data integrity problems Application programs (APs) are difficult to maintain and data dependent -- See Music Instrumental Rental Co. Example
Background image of page 10
File Processing System
Background image of page 11

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

View Full DocumentRight Arrow Icon
Database Processing System [DBPS] Integrated Data Only the Database Management System (DBMS) needs to know the physical aspects of the data Reduced Data Duplication
Background image of page 12
Image of page 13
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 / 54

Class01_Spring_2010 - BCIS 4620 BCIS INTRODUCTION TO...

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

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