Review of Information Systems Introduction - PowerPoint PPT Presentation

Review of information systems introduction
Download
1 / 15

  • 270 Views
  • Updated On :
  • Presentation posted in: Pets / Animals

Review of Information Systems Introduction. “Information systems” describe processes that transform data into information, using digital technology, to enable organizations to make better decisions requires inputs, outputs, processes, feedback

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

Download Presentationdownload

Review of Information Systems Introduction

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Review of information systems introduction l.jpg

Review of Information Systems Introduction

  • “Information systems” describe processes that transform data into information, using digital technology, to enable organizations to make better decisions

    • requires inputs, outputs, processes, feedback

    • composed of hardware, software, databases, infrastructure, people and procedures

    • classified into transaction processing systems, e-commerce, management information systems and decision support systems

  • Computer hardware encompasses all digital machinery used to input, store, process and output data

    • CPU + memory is computer’s “heart”, linked to input devices, output devices, communications devices, secondary storage

    • Computer systems include: network computers, PCs, workstations, midrange computers, mainframes and supercomputers

MIS 90-728 Lecture Notes


Information systems introduction cont d l.jpg

Information Systems Introduction (cont’d)

  • Computer software encompasses all programs that direct hardware to perform specific tasks

    • types include: operating system, utility, application software

    • application software purchase options include: proprietary, off-the-shelf and customized

    • application software scope includes: personal, workgroup and enterprise

    • applications are developed using languages

    • software cost dominates organization IS total costs

  • The Internet is a worldwide linkage of computers that communicate

    • Every host sends, receives and transfers messages and has a unique URL

    • Internet services include e-mail, FTP/telnet, Usenet and telephony

    • The World Wide Web allows organized access to documents anywhere on the Internet

MIS 90-728 Lecture Notes


Why do we focus on relational databases l.jpg

Why Do We Focus on Relational Databases?

Databases are the lifeblood of any organization and answer the “who/what/when/where/why” of operations.

Relational databases store large volumes of data with a minimum of data duplication, inconsistency, or anomalies, and encode key business practices

Relational database management systems address the collection, storage and management of data in a relational databases, using:

  • Tables

  • Queries

  • User interfaces

  • Reports

  • Application programs

Growth in Internet communications has increased the importance of relational database design and applications

MIS 90-728 Lecture Notes


Heinz school network information l.jpg

Heinz School Network Information

  • Computer information:

    • Nearly 100 computers in the clusters, nearly all running Windows NT; one Mac.

    • Nearly 100 more computers given to staff, faculty, Ph.D students, etc. Staff and faculty machines generally run Windows 95; Ph.D student machines run Windows NT

  • Server information:

    • Five servers: Sparc and NT servers for websites, three-server setup for our Heinz domain controllers (one primary, two backups). A few stand-alone servers as well.

    • All servers will eventually run on Windows NT Server.

  • Novell vs. NT:

    • Novell considered more robust, more stable and less able to be hacked than Windows NT

    • Corporate purchasing decisions are dominating technical considerations

MIS 90-728 Lecture Notes


The wide world of heinz l.jpg

The Wide World of Heinz

  • The computing world at Heinz is divided into two:

    • The web server (domain www.heinz.cmu.edu) called Howland: a Sun Solaris machine running Unix

    • Howland is connected to the Andrew file system

    • the PC world (domain HEINZ), in which three NT servers connect all faculty, staff and student computers, web/database/Exchange servers

    • HEINZ domain is part of the CMU “meta-domain”

CMU “meta-domain”

“Unix”

“NT”

http://www.andrew.cmu.edu

NT

Server 1

http://www.heinz.cmu.edu

AFS

NT

Server 2

NT

Server 3

Communicate via FTP

Howland

(Heinz School

webserver)

Faculty, student, staff, servers

MIS 90-728 Lecture Notes


Overview of the relational database model l.jpg

Overview of the Relational Database Model

Relational databases can store any type of data:

  • IDs

  • Codes

  • Memos

  • Numerical Values

  • Hypertext Links

  • Images/Sounds

  • Date/Time

  • Spatial attributes

  • OLE

All organizations use these types of data in their operations, but fewer use databases to define relationships between data

MIS 90-728 Lecture Notes


Relational database example service delivery l.jpg

What data does Aardvark need?

Relational Database Example: Service Delivery

  • Aardvark Towing , Inc.

    • Mission: Tow vehicles from pick up sites to destinations, charging by the mile towed.

    • Resources: 5 trucks, 20 drivers, radio dispatch, police scanners

    • Problems: Need to automate records, beat out the competition

    • Solution: Database, change from random to targeted truck locations

MIS 90-728 Lecture Notes


First step in relational database design identify entity sets l.jpg

First Step in Relational Database Design: Identify Entity Sets

Entity Set: Collection of similar persons, things, places, events, concepts, or linkages

Potential Entity Sets:

  • TRUCK

  • DRIVER

  • VEHICLE

  • TOW

  • VEHICLE DRIVER

MIS 90-728 Lecture Notes


Second step identify primary keys for entity sets l.jpg

Second Step: Identify Primary Keys for Entity Sets

Primary Key: Has a unique value for every entity

Candidate Key: Alternate primary key

MIS 90-728 Lecture Notes


Third step identify attributes of entity sets l.jpg

Third Step: Identify Attributes of Entity Sets

Attribute: Characteristic or property of entities

MIS 90-728 Lecture Notes


Data example tbltruck l.jpg

Data Example: tblTruck

MIS 90-728 Lecture Notes


Next step design entity relationship diagram l.jpg

(performs a)

(is used in a)

VEHICLE

EMPLOYEE

TOW

1

M

1

M

M

M

(drives a)

1

(is used for a)

1

TRUCK

VEHICLE

DRIVER

Next Step: Design Entity-Relationship Diagram

An entity-relationship (E-R) diagram is a blueprint of the relational database. It defines associations between and within entities that capture: connectivity, cardinality, functional relationship and others.

MIS 90-728 Lecture Notes


Relationships between tables example l.jpg

One truck can participate in many tows;

Truck is a primary key for tblTruck and a foreign key for tblTow

Relationships Between Tables - Example

tblTruck

tblTow

MIS 90-728 Lecture Notes


Last step full relational database model l.jpg

Last Step: Full Relational Database Model

tblTruck(Truck#, Truck VIN, Truck Plate#,

Truck Make And Model Code, Truck Year)

tblEmployee (Employee#, Social Security Number, First Name,

Last Name, Address, Phone, DOB)

tblVehicle (Vehicle VIN, Driver#@, Vehicle Plate#,

Vehicle State, Vehicle Make and Model Code,

Vehicle Type, Vehicle Year, Insurance Co.)

tblTow (Tow#, Truck#@, Employee#@, Vehicle VIN@, Date Towed,

Time Towed, Pick Up Address, Pick Up Zone,

Destination Address, Distance Towed (Miles), Comment)

tblVehicleDriver (Driver#, First Name, Last Name, Operator#,

Street Address, City, Zip Code, State,

Phone, Owner? )

MIS 90-728 Lecture Notes


What else is needed to create a rdbms for aardvark towing inc l.jpg

What Else Is Needed to Create a RDBMS for Aardvark Towing, Inc.?

  • Build case for relational database management system

  • Learn business rules, data sources

  • Define and populate tables using a relational database software

  • Implement E-R diagram relationships

  • Build forms for data entry

  • Display spatial data in GIS

  • Implement spatial and aspatial queries

  • Design summary reports

  • Implementation and testing

MIS 90-728 Lecture Notes


ad
  • Login