Week5-Database - ISM3630 Dr.DaveHuff 1 Whatisadatabase...

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

View Full Document Right Arrow Icon
1 ISM 3630  Business Information Systems Dr. Dave Huff
Background image of page 1

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

View Full DocumentRight Arrow Icon
What is a database? Way to store and retrieve information Human Resources Sales Operational Scheduling Production Inventory Course/Enrollment
Background image of page 2
Database components Files This is where the data lives Management System Manages the storage and Retrieval of data Administrative Capabilities Manages Access Physical and Logical Security
Background image of page 3

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

View Full DocumentRight Arrow Icon
Distributed Data Bases Client PC Distributed Databases on Intranets and Other Networks End User Databases Data Warehouse Data Marts Operational Databases of the Organization Network Server External Databases on the Internet and Online Services
Background image of page 4
Data Warehouses Applications Data Marts Finance Marketing Sales Accounting Management Reporting ERP Purchasing CRM Inventory Control Shipping Logistics
Background image of page 5

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

View Full DocumentRight Arrow Icon
Database Mgmt. System Inquiry Customer Transaction Processing Checking Account Program Savings Account Program Installment Loan Program Database Management System Customer Database Checking Account Data Savings Account Data Installment Loan Data Other Customer Data
Background image of page 6
Relational Flexible Adaptable Not Application-based Requires abstract modeling Employee Wages Job Schedule 401K Insurance Benefits
Background image of page 7

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

View Full DocumentRight Arrow Icon
Relational What you spend in development, you  gain in flexibility and maintenance RDBMS is a group of tables with data  that is managed by a DBMS Vast majority of DB’s are relational There are Other Types of DB’s Legacy Paradigms Specialized
Background image of page 8
Data Organization Structure Employee Record 1 Employee Record 2 Employee Record 3 Employee Record 4 Name Field SS No. Field Salary Field Name Field SS No. Field Salary Field Name Field SS No. Field Salary Field Name Field SS No. Field Salary Field Jones T.A. 275-32-3874 20,000 Klugman J.L. 349-88-7913 28,000 Alverez, J.S. 542-40-3718 100,000 Porter, M.L. 617-87-7915 50,000 Human Resource Database Payroll File Benefit File
Background image of page 9

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

View Full DocumentRight Arrow Icon
RDBMS Tables represent “Entities” Student Class Professor Tables consist of Rows and Columns Rows are “Relations” Columns are “Fields”
Background image of page 10
Columns Column Titles are called Fields They define the “Attributes” that are being  stored in the Database Attributes are things that we want to store Last Name First Name SSN Phone Number
Background image of page 11

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

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

This note was uploaded on 04/09/2010 for the course ISM 3600 taught by Professor Huff during the Winter '10 term at Wayne State University.

Page1 / 36

Week5-Database - ISM3630 Dr.DaveHuff 1 Whatisadatabase...

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

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