Database (1).pptx - Introduction to Information Technology...

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

View Full Document Right Arrow Icon
Introduction to Information Technology Management Introduction to 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
Goals for today Understand the concept of database and database management systems (DBMS) Understand the concept and structure of a relational database Basics of Structured Query Language (SQL)
Background image of page 2
The Information Economy Information is the most important asset of most modern corporations Companies who can gather, analyze, and act upon information most effectively will sustain competitive advantages Patents, trademarks, and brands are important information assets.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Database What is a database? A single table or a collection of related tables What is database management systems (DBMS)? Software for creating, maintaining, and manipulating data
Background image of page 4
What is the usage of Databases? Databases are used to efficiently store and manage large amounts of 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
Why Use a Database? Tactical Advantages 1. Preserve data integrity - assurance that data is consistent, correct, and accessible 2. Eliminate data redundancy – unnecessary repetition of data that slows data processing 3. Limit data view (query, report) so that users only see what they need to see, as cleanly and clearly as possible
Background image of page 6
Eliminate data redundancy
Background image of page 7

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

View Full DocumentRight Arrow Icon
Eliminate data redundancy Student Table Class_Assignment Table
Background image of page 8
How database fits into an organization—The big picture Data about different functional areas (sales, product returns, inventory, payroll) Informational reports Reports are analyzed, trends are identified, and BUSINESS DECISIONS ARE MADE
Background image of page 9

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

View Full DocumentRight Arrow Icon
Top 5 DBMS products Access – MS personal DBMS SQL Server – MS enterprise DBMS DB2 from IBM Oracle MySQL free, open-source
Background image of page 10
DB Application 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
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 29

Database (1).pptx - Introduction to Information Technology...

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