Inf 2603 - Chapter 1 Study Guide Graded A+

Historical Roots of databases {Ans: 1. Manual file systems - paper and pencil systems 2. Computerized File Systems}What are the problems with File system data management. {Ans: 1. Lengthy development time 2. Difficult to get quick answers 3. Complex systems administration 4. Lack of security and limited data sharing 5. Extensive programming}Why is database design important? {Ans: A database needs to be well designed to facilitate effective data management and to generates accurate and valuable information.}What does data governance refer to? {Ans: Data governance is the strategy by an organization to safeguard data quality.}Explain what is meant by data dependence {Ans: Access to a file is dependent on its data attributes For example changing integers to floating point (decimal) numbers would require the programmer to reprogram the whole database.}Define a database: {Ans: A database is a shared integrated computer structure that stores an organized collection of end-user data (raw facts) and meta data (Data about data)}Elaborate on computerized file systems of the past {Ans: Older computer file systems were slow and cumbersome. Companies often hired a dp specialist (data processing specialist) later evolved to a dp manager.}What does logical data format refer to?