Information Management

 *********************************************************************************                                                              Proper Installation of Operating Systems           This Hierarchical Model used  Proper installation of Operating System data where in the model in the lower levels are sorted under a hierarchy of successively higher-level units. The  Proper installation of Operating System data are grouped into clusters at one or more levels, and the influence of the clusters on the data points contained in the datas from the installation of OS into a computer is taken account for the other statistical analysis. In this example, the top-most of the heirarchy table is the  Proper installation of Operating System, therefore it is where the other topics branch out from to extend to other topics that are still covered by similar entities.                This Relational Model (RM) represents the database of  Proper installation of Operating System, this relation is

 *********************************************************************************                                                                                                                        Proper Hardware Maintenance                This Hierarchical Model used Proper Hardware Maintenance data where in the model in the lower levels are sorted under a hierarchy of successively higher-level units. The Proper Hardware Maintenance data are grouped into clusters at one or more levels, and the influence of the clusters on the data points contained in the datas from the hardware maintenance is taken account for the other statistical analysis. In this example, the top-most of the heirarchy table is the Computer Hardware Maintenance, therefore it is where the other topics branch out from to extend to other topics that are still covered by hardware maintenance.                This Relational Model (RM) represents the database of Proper Hardware Maintenance,this relation is a table of

 **********************************************************************************                                                  PROPER SOFTWARE MAINTENANCE                This Relational Model (RM) represents the database of Proper Software Maintenance,this relation is a table of values about proper maintenance of a software. Every row in the table represents a collection of related data values. These rows in diagram denote a real-world entity or relationship of factors that affect the proper maintenance of a computer. The elements are helpful to interpret the meaning of values in the diagram, giving sense as to why a certain entity influence another. The data are represented as a set of relations. In this relational model, the Proper Software Maintenance diagram units are stored in a diagram. However, the physical storage of these data are independent of the way the data are logically organized as it is a relational model.                This Network Model is a database model tha

 ********************************************************************************** Think of at least two differences between access and excel. Microsoft Excel is an application that uses spreadsheets to create charts, graphs, tabular models while Microsoft Access is also an application that acts as a database program. It helps in collecting and sorting the data. Microsoft excel is used for spreadsheets and financial calculations and Microsoft Access is used for storing and manipulating large amounts of information.

 ********************************************************************************* What type of software is Microsoft office Access? MS Access is a database software application that is present in MS Office Package bundle. It is like MySQL, MongoDB, NoSQL used for storage of records in databases. It is simple and easy to use and maintain. Also allows both graphical interface for queries and the coding view for queries. It is commonly used to keep the databases that a program uses separate from the program so that each can be upgraded individually. Also, so that multiple apps on different platforms can access the data.

 ********************************************************************************* What type of software is Microsoft office Excel? Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. In addition to its standard spreadsheet features, Excel also offers programming support via Microsoft’s Visual Basics for Applications(VBA), the ability to access data from external sources via Microsoft s Dynamic Data Exchange(DDE), and extensive graphing and charting capabilities.

************************************************************************************* What is a Database? A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records. Each of these tables would have different fields that are relevant to the information stored in the table. Nearly all e-commerce sites uses databases to store product inventory and customer information. These sites use a database management system (or DBMS), such as Microsoft Access, FileMaker Pro, or MySQL as the "back end" to the website. By storing website data in a database, the data can be easily searched, sorted, and updated. This flexibility is important for e-commerce sites and other types of d ynamic websites Early databases were relativ ely "flat," which means they were limited to simple rows and

 ********************************************************************************** A.     Disadvantages of DBMS ·          Increased costs: -           Database systems require sophisticated hardware and software and highly skilled personnel. -           The cost of maintaining the hardware, software, and personnel required to operate and manage a database system can be substantial. Training, licensing, and regulation compliance costs are often overlooked when database systems are implemented. ·          Management complexity: -           Database systems interface with many different technologies and have a significant impact on a company’s resources and culture. -             The changes introduced by the adoption of a database system must be properly managed to ensure that they help advance the company’s objectives. Given the fact that database systems hold crucial company data that are accessed from multiple sources, security issues must be assessed constantly. ·    

 ********************************************************************************* A.     Advantages of DBMS   ·                    ·               Improved Data Sharing: -           The DBMS helps create an environment in which end users have better access to more and better-managed data. -           Such access makes it possible for end users to respond quickly to changes in their environment.   ·          Improved data security: -           The more users access the data, the greater the risks of data security breaches. Corporations invest considerable amounts of time, effort, and money to ensure that corporate data are used properly. -           A DBMS provides a framework for better enforcement of data privacy and security policies. -           Better data integration: -           Wider access to well-managed data promotes an integrated view of the organization’s operations and a clearer view of the big picture. -           It becomes much easier to see how a

 ********************************************************************************** A     Functions of DBMS ·          Data Dictionary Management -   Data Dictionary is where the DBMS stores definitions of the data elements and their relationships (metadata).    The DBMS uses this function to look up the required data component structures and relationships. When programs access data in a database they are basically going through the DBMS. This function removes structural and data dependency and provides the user with data abstraction. In turn, this makes things a lot easier on the end user. The Data Dictionary is often hidden from the user and is used by Database Administrators and Programmers.   ·          Data Storage Management - This particular function is used for the storage of data and any related data entry forms or screen definitions, report definitions, data validation rules, procedural code, and structures that can handle video and picture formats. Users do not need