STORING ORGANIZATIONAL INFORMATION --DATABASE

CHAPTER 7

Database is the organized collection of data. the data is typically organized to model relevant aspects of reality in a way that supports processes requiring this information.the advantages of the relational database are:-

increased flexibility
a good database can handle changes quickly and easily just as any goes business needs to be able to handle changes quickly and easily. the distinction between logical and physical views of information deals with the physical storage of information on a storage device such as a hard disk. the logical view of information focuses on how users logically access information to meet their particular business needs.

increased scalability and performance
only a database can scale to handle the massive volumes of information and the large numbers of users required for the successful launch. scalability refers to how well a system can adapt to increased demands. performance measure how quickly a system performs a certain process or transaction.

reduced information redundacy
redundacy is the duplication of information or storing the same information in multiple places. redundacy information occurs because organizations frequently capture and store the same information in multiple locations.

increased information integrity (quality)
to measure of the quality of information within a database environment, integrity constraints are rules that helps ensure the quality of the information. relational integrity constraints are rules that enforce basic and fundamental information based constraints. business critical integrity enforce business vital to an organization success and often require more insight and knowledge than relational integrity constraints.

increased information security
password provide authentication of the users who is gaining access to the controls.