tailieunhanh - Lecture Computing for management - Chapter 7

Lecture 7 - Database systems. After studying this chapter you will be able to understand: Information, how data is converted into information, knowledge, data sources, direct, indirect, data quality matters, GIGO, MS word practical session. | Database Systems Lecture 7 Summary of Lecture 6 In the previous lecture we have discussed Data Data Types, Representation, storage Number Systems, Decimal, Binary Codes to represent data American Standard Code for Information Interchange (ASCII), Extended Binary Coded Decimal Interchange Code (EBCDIC), Unicode Summary of Lecture 6 Information How Data is converted into Information Knowledge Data Sources Direct, Indirect Data Quality Matters GIGO MS Word Practical Session Today’s Topics What is database system? Database Management System. Traditional File Processing Systems Database Systems Types, Examples How to develop a Database System How data is organized and stored in Database Systems Summary of Today Famous DBMS Software. What You Need to do to develop yours own database systems In the Beginning, There Were File-Processing Systems File a collection of records containing logically related data arranged in fields File Based Systems File-based system are the collection of application programs that manage data specific to each program File Processing Systems used to keep separate programs having 0 sharing or no logical relevance's. Files specific to file Base System Program Can be opened here Different Files on a Desktop It is difficult to search for data here! Some Limitation of file based systems Separation and isolation of data Data relevant to some business may store in different files. Which may be difficult to be related or searched. Data is duplicated. As same business data is being stored in different files, so there are lot of chances of duplication. Each application requires entering the same data again so: What is Data Duplication? Removing duplicates Data With Lot of Duplicates Example: A Person Name and address may be stored in several different files. Some Limitations of File Systems Lack of Security. Somebody deletes the entire file/contents of the file. Data will be lost. Multi-User Support A file based systems like MS Excel, Notepad etc. do not . | Database Systems Lecture 7 Summary of Lecture 6 In the previous lecture we have discussed Data Data Types, Representation, storage Number Systems, Decimal, Binary Codes to represent data American Standard Code for Information Interchange (ASCII), Extended Binary Coded Decimal Interchange Code (EBCDIC), Unicode Summary of Lecture 6 Information How Data is converted into Information Knowledge Data Sources Direct, Indirect Data Quality Matters GIGO MS Word Practical Session Today’s Topics What is database system? Database Management System. Traditional File Processing Systems Database Systems Types, Examples How to develop a Database System How data is organized and stored in Database Systems Summary of Today Famous DBMS Software. What You Need to do to develop yours own database systems In the Beginning, There Were File-Processing Systems File a collection of records containing logically related data arranged in fields File Based Systems File-based system are the collection of .