Database Programming

a set of principles concerned with determining which states are valid for a database.

Data Integrity within a relational database is that property of a database which ensures that it is and remains an accurate reflection the universe of discourse that it is attempting to model. This includes rules and restrictions to ensure the recording of correct data. It also involves the protection of data within the database. These rules are called integrity constrains.

These restrictions are used in almost every field of input to the database.

Examples of this is where you are given a drop box on a form to select from a list. This eliminates the chance of multiple spelling of a word. eg. colour color

Data integrity is preserved by encapsulating unit-of-work actions, such as a transfer from one account to another, in a transaction.

The database implementation ensures that either all of the transaction commits, or none of it commits. In the event of a failure and restart of the database, all incomplete transactions are uncommitted, i.e. rolled back.

While the transaction is in-flight, any query to data elements used by the transaction reliably retrieve the value they allhad prior to transaction start. Also, any transaction attempting to lock any of those elements for other unit-of-work actions are forced to wait until the first transaction is complete.

Older systems take up a lot of space, though still much less than a library of books.

Searching for information can be difficult if you don't know how to use search terms effectively or if you have to contend with search spam.

Modern computers in the forms of tablets and palmtops are often too small to use effectively.

Computers can malfunction or fail altogether.

Computers cannot be used without electricity, though they are becoming more portable and more able to use with batteries.

Computers need maintenance, and are prone to malware such as spyware and viruses.
Security & fear

Modern businesses have been leveraging management information systems (MIS) to manage, order, organize and manipulate the gigabytes and masses of information generated for various purposes. MIS helps businesses optimize business processes, address information needs of employees and various stakeholders and take informed strategic decisions. However, budget allocation and monitoring issues can affect the efficacy of MIS. It has its advantages and disadvantages depending on organizational deployment and usage.

1. AdvantagesBetter Planning and Control
2. Management information systems have changed the dynamics of running businesses efficiently. Decentralization is one of the biggest advantages; it allows monitoring of operations at low levels and frees up resources for departmental managers to devote time to strategic activities. Coordination of specialized projects and activities is much better and decision makers in the organization are aware of issues and problems in all departments. Another advantage of MIS is that it minimizes information overload, which can be quite common with conventional businesses in the modern era. Aid Decision Making
3. MIS has to be designed and managed in such way that it aggregates information, monitors the company's activities and operations and enhances communication and collaboration among employees. This ensures better planning for all activities and better ways to measure performance, manage resources and facilitate compliance with industry and government regulations. Control helps in forecasting, preparing accurate budgets and providing the tools and vital information to employees, top management and business partners. Disadvantages
4. The purpose of MIS is to generate synthesized and processed information from computerized/automated and certain manual systems. Information distribution to all levels of corporate managers, professionals and key executives becomes quite seamless with streamlined MIS. Managers are able to make quick, timely and informed decisions. Top management and board members can take strategic decisions, plan future growth and business expansion activities based on the data and information generated by MIS. Constant Monitoring Issues
5. Depending on organization deployment, usage and extraneous factors, some disadvantages related to Management Information Systems can come to the fore. Allocation of budgets for MIS upgrades, modifications and other revisions can be quite tricky at times. If budgets are not allocated uniformly or as per immediate requirements, key functionalities might get effected and benefits might not be realized consistently. Integration issues with legacy systems can affect the quality of output and vital business intelligence reports.
6. Change in management, exits or departures of department managers and other senior executives has a broad effect on the working and monitoring of certain organization practices including MIS systems. Since MIS is a critical component of an organization's risk management strategy and allied systems, constant monitoring is necessary to ensure its effectiveness. Quality of inputs into MIS needs to be monitored; otherwise consistency in the quality of data and information generated gets effected. Managers are not able to direct business, operational and decision-making activities with the requisite flexibility.