information resources
Question and answers
4-1. information resources are categorized into primary literature; an example is journal, secondary literature; books and tertiary literature; example is reference material. Primary literature provides for new research and theories, secondary literature contains a brief overview while tertiary literature contains brief description of information.
4-2. Metadata is that data which gives an information about other data. Structural metadata describes structure of databases such as SQL server. Unstructured metadata the data that lacks mode. An example of structured metadata is file size while an example of unstructured metadata is journal.
4-3 The characteristics of information are accuracy, completeness, consistency, uniqueness and timeline. Database design must be accurate, entering 10 digits in a phone is more consistency than 11, unique company must be competitive and finally, new and most current information is valuable to a firm.
4-4. the traditional database design approaches include agile modelling and extreme programming. Don't use plagiarised sources.Get your custom essay just from $11/page
4-5. the major file system disadvantages are, security problems, integrity problems, data isolation, difficulty in accessing data and data inconsistency. Specific file system problems are; duplication of information, file may be written in several programming languages, difficulties to change code for new program to be accepted and data files may contain different colors hence confusing.
4-6. the three emerging architecture databases are; physical data level, conventional level and external data levels. Physical data level helps to describe the record layout of files and Connectional data level helps to present inform of set of data tables. They main disadvantage is that the application is complex since it must deal with details.
4-7. the steps of data design are; first is to identify the purpose of data design, review the existing databases, make a list of fields, identify the key fields, daft the table relationships, enter sample data and normalize it and finally review and finalize the database. The collection of benefits of steps of relational data design contain a collection of items that are organized as a set of formally described tables. Another advantage is that data can be secured or shared among users.
4-8. a primary key is a set of columns that are used to identify a row in a table in a unique manner while a foreign key is a field in a table whose value should match with a primary key.
4-9. the typical to data is Duwamish 7.0 is the typical data strategy. Access database is located at the point of a stored procedure call scope. Other examples of data access strategies are; facilities for data retrieval, generalized DBMS and loose coupling of the ES.
4-10. a database administrator is used during development of database, also, it is responsible for performance and security of database. The career outlook for database manager is a degree in management information systems and computer science.
4-11. SQL is defined as a standard language for relational database management system. It communicates with database.
4-12. IVR is a technology that enables computers to communicate with humans through voice. It is a routine. It serves as an efficient tool for routine enquiries.
4-13. Shadow windows are groups of spreadsheets created by business groups to gather information. They are used budgeting and forecasting. Shadow windows provide business people with information that results to business success. It is bad because it provides data that is inconsistence with other data.
4-14. MDM is a method that facilitates linking of all critical to one data file. Data Steward is organizing data assets to provide businesses with high reliable and quality data which is easily accessible.
4-15. a data warehouse is federated building from which enterprises collect all data. Steps involved in building a data warehouse are; determining objectives, determining information, identifying core process, constructing a data model, locating data sources, setting tracking duration and plan implementation.
4-16. examples of internal sources of information for a data warehouse are; financial, personnel and business administration. Examples of external sources of data in a data warehouse includes sales and purchases.
4-17. examples of data warehouse architectures are bottom tier, middle tier and top tier. Real time information is designed to make PAYE submissions to HMRC more efficient whenever employees are being paid.
4-18. big data volume of data which is stored in the cloud. The characteristics of big data are volume, variety, velocity and variability. The volume discusses about the size, variety discusses category, velocity discusses speed and variability discusses inconsistences.
4-19. the process of examining large databases for the purpose of generating new information. Data dredging uses data mining to analyze large volume of data while data mining examines large data sets to establish unknown links. The goal of data mining is to extract of large volumes of data.
4-20. examples of databases without boundaries are SQL Microsoft, DBMS and FileMaker Pro.
4-15. data owners have power to control who sees and change the data. Each Information Management stakeholder his own time, resources and expertise and that brings the difference.