Exam Review(I)

Exam Review(I) - Exam Review (I) Jinie Pak Department of...

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

View Full Document Right Arrow Icon
Exam Review (I) Jinie Pak Department of Information Systems UMBC
Background image of page 1

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

View Full DocumentRight Arrow Icon
Chapter 1: The Database Environment Understand database definitions Compare pros and cons of conventional file systems and database systems. Describe database development process Explain three-schema database architecture
Background image of page 2
Definitions Database: organized collection of logically related data Data: stored representations of meaningful objects and events Structured: numbers, text, dates Unstructured: images, video, documents Information: data processed to increase knowledge in the person using the data Metadata: data that describes the properties and context of user data 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Disadvantages of File Processing Program-Data Dependence All programs maintain metadata for each file they use Duplication of Data Different systems/programs have separate copies of the same data Limited Data Sharing No centralized control of data Lengthy Development Times Programmers must design their own file formats Excessive Program Maintenance 80% of information systems budget
Background image of page 4
Database Management System 5 DBMS manages data resources like an operating system manages hardware resources n A software system that is used to create, maintain, and provide controlled access to user databases Order Filing System Invoicing System Payroll System DBMS Central database Contains employee, order, inventory, pricing, and customer data
Background image of page 5

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

View Full DocumentRight Arrow Icon
Advantages of the Database Approach Program-data independence Planned data redundancy Improved data consistency Improved data sharing Increased application development productivity Enforcement of standards Improved data quality Improved data accessibility and responsiveness Reduced program maintenance Improved decision support
Background image of page 6
Chapter 2: The Database Development Process Definition of terms Describe system development life cycle Explain prototyping approach Explain three-schema approach Explain three-tiered architectures Explain scope of database design projects
Background image of page 7

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

View Full DocumentRight Arrow Icon
Definitions Information Systems Architecture (ISA):Conceptual blueprint for organization’s desired information systems structure Information Engineering : A data-oriented methodology to create and maintain information systems Enterprise Data Model: Overall picture of organizational data at high level of abstraction
Background image of page 8
Two Approaches to Database and IS Development SDLC System Development Life Cycle Detailed, well-planned development process Time-consuming, but comprehensive Long development cycle Prototyping Rapid application development (RAD) Cursory attempt at conceptual data modeling Define database during development of initial prototype Repeat implementation and maintenance activities with new prototype versions 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
Database Schema External Schema User Views Subsets of Conceptual Schema Can be determined from business-function/data entity
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.

Page1 / 49

Exam Review(I) - Exam Review (I) Jinie Pak Department of...

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