7104Lec_wk01 - Introduction to Data and Database Management...

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

View Full Document Right Arrow Icon
Outlines Data and Information Data Processing Methods Data Management Issues Database System Database Management System (DBMS) Structured Query Language (SQL) DML – SELECT query Introduction to Data and Database Management System (DBMS) 04/04/11 1
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 data? Data is a collection of facts, such as values or measurements. It can be numbers, words, measurements, observations or even just descriptions of things. Data can be qualitative or quantitative. What is information? Information is data that are processed to be useful. Thus, knowledge is the application of data and information. 04/04/11 2 Introduction to Data and Database Management System (DBMS) Data and Information
Background image of page 2
Example 1, What do we know about this dog? Qualitative : brown & black colour, long hair Quantitative : 4 legs, weight 25.5Kg Example 2, What can we tell from this MS Excel Worksheet? Warehouse name uses location Name of warehouse managers Warehouse space or area Knowledge will be derived upon the application of data 04/04/11 3 Introduction to Data and Database Management System (DBMS) Data and Information
Background image of page 3

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

View Full DocumentRight Arrow Icon
Manual Data Processing – File System Prior 1930s, data were maintained manually with paper technology, kept related documents in separate files and stored into cabinets and into large storage houses, and used completely human resources to process data. Computerized Data Processing – File System Prior 1970s, data were maintained electronically with flat-file technology, and used proprietary software applications to process data Computerized Data Processing – Database System From 1970 - present, data is maintained electronically with database technology, keep related records in separate tables and store into a single or multi database system and use the DBMS to process data. 04/04/11 4 Introduction to Data and Database Management System (DBMS) Data Processing Methods
Background image of page 4
04/04/11 5 Introduction to Data and Database Management System (DBMS) Data Processing Methods
Background image of page 5

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

View Full DocumentRight Arrow Icon
04/04/11 6 Introduction to Data and Database Management System (DBMS) Data Processing Methods
Background image of page 6
04/04/11 7 Introduction to Data and Database Management System (DBMS) Data Processing Methods
Background image of page 7

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

View Full DocumentRight Arrow Icon
Why data processing methods kept changing? (1930, 1970, present) -
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 26

7104Lec_wk01 - Introduction to Data and Database Management...

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

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