DB+Intro-1+NK - DatabaseProcessing LearningObjectives

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

View Full Document Right Arrow Icon
MIS 235 DB Intro  CH5  Chen Zhao 1 Database Processing Learning Objectives What are relational databases?  Database terminology SQL basics DBMS Excel Spreadsheet vs. database
Background image of page 1

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

View Full DocumentRight Arrow Icon
MIS 235 DB Intro  CH5  Chen Zhao 2 Database Fundamentals Information  is vital to an organization.  Information is derived  from data stored in databases The ability to understand, digest, analyze, and filter information is a key  to success for any professional in any industry.  Database  – A database is  a self-describing collection of  integrated records.  Database maintains information about various types of objects  (inventory), events (transactions), people (employees), and places  (warehouses)
Background image of page 2
MIS 235 DB Intro  CH5  Chen Zhao Database   Advantages Database advantages from a business  perspective Increased flexibility Increased scalability and performance Reduced information redundancy Increased information integrity (quality) Increased information security 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
MIS 235 DB Intro  CH5  Chen Zhao 4 Relational Database Stores information in the form of logically related two-dimensional  tables Supports one to one, one to many, and many to many  relationships Easier for end users to understand and become self sufficient for  their information needs Structured Query Language  (SQL)   the universal interface to  relational databases  Older Database Models : Hierarchical -  Models entities in a parent-child relationship (like a tree structure).  One-to-many relationships Network -  More flexible than the hierarchical model.  Supports  Many-to-many relationships  Both require deep technical knowledge to get information out of the database
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/15/2011 for the course MIS 235 taught by Professor Sunrro during the Fall '08 term at Miami University.

Page1 / 17

DB+Intro-1+NK - DatabaseProcessing LearningObjectives

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

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