0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
data scrubbing
What is the effect of inaccurate data input in your system?
The effect will be a negative one since only accurate data will give the desired effects.
With a neat diagram explain the data warehouse delivery process carried out in a data warehouse?
Data Warehouse delivery process
IT strategyEducationTechnical blue printBuilding the visionHistory LoadAd-hoc queryAutomationBusiness case analysisBusiness requirements
R EQ EI vR lE uM tE i N oT n
Extending scope
Delivery Process
The process that delivers a data warehouse has to be fundamentally different from traditional waterfall method Issue with the DW projects is that difficult to complete the tasks and deliverables in the strict, ordered fashion demanded by a waterfall method because requirements are rarely understood and are expected to change over time
Knock-on effect
What balances the importance of traffic and its characteristics in order to manage data?
QoS strategy
What is the difference between data restore and recovery?
Though it may seem to be the same, data restore is not equal in meaning with data recovery.
Restoring is a much bigger process because it involves copying every file using a backup program and transferring it as precisely as it is into a secondary storage. This is for the purpose of replacing any damaged files and copy/move into a new database. Meanwhile, if we do a hard drive recovery, we'll be doing a process of updating database files that are restored from backup. This typically applies a redo logs to the database.
What symbol is used at the start or end of a flowchart?
The result of the last option you chose. Usually a box.
Traditional file environment is not well suited to save data in them. They make it difficult to read the data as they are more unstructed.
What is a record-based data model?
-> A record based data model is used to specify the overall logical structure of the database.
-> In this model the database consists of a no. of fixed formats of different types.
-> Each record type defines a fixed no. of fields having a fixed length.
-> There are 3 principle types of record based data model. They are :
1. Hierarchical data model.
2. Network data model.
3. Relational data model.
What is meant by lossless join in database management system?
We know that normallisation decomposites the large no of tables in to small no of tables,after the decomposite if we want to join that table and getting the original table.then that join is known as lossless join,otherwise it is known as lossy join.
R
X Y L M
X1 Y1 L1 M1
X2 Y2 L2 M2
R1 a table ,Which consists of attributes such as x,y,l,m.If we want to decomposite it in to small no of tables then wer will get
r1 r2
X Y L M
X1 Y1 L1 M1
X2 Y2 L2 M2
After we decomposite the large table we get two small table,If we want to join that two table for getting the original table then
R
X Y L M
X1 Y1 L1 M1
X2 Y2 L2 M2
We got the original table wiyhout any lossing attribute so this join is called as losslessjoin or lossy join.
List the different types of super scalar processor?
Superscalar processors have a main processor that can take only one command at a time. It has direct connections to the secondary systems of the processor that feeds information right into subsystems to execute specific commands and output information separate. There is only one type of superscalar processor but there are scalar processors and vector processors.
Data Series
What is difference between transaction process system between decision support system?
Information systems differ in their business needs. Also depending upon different levels in organization information systems differ. Three major information systems are
Figure 1.2 shows relation of information system to the levels of organization. The information needs are different at different organizational levels. Accordingly the information can be categorized as: strategic information, managerial information and operational information.
Strategic information is the information needed by top most management for decision making. For example the trends in revenues earned by the organization are required by the top management for setting the policies of the organization. This information is not required by the lower levels in the organization. The information systems that provide these kinds of information are known as Decision Support Systems.
Figure 1.2 - Relation of information systems to levels of organization
The second category of information required by the middle management is known as managerial information. The information required at this level is used for making short term decisions and plans for the organization. Information like sales analysis for the past quarter or yearly production details etc. fall under this category. Management information system (MIS) caters to such information needs of the organization. Due to its capabilities to fulfill the managerial information needs of the organization, Management Information Systems have become a necessity for all big organizations. And due to its vastness, most of the big organizations have separate MIS departments to look into the related issues and proper functioning of the system.
The third category of information is relating to the daily or short term information needs of the organization such as attendance records of the employees. This kind of information is required at the operational level for carrying out the day-to-day operational activities. Due to its capabilities to provide information for processing transaction of the organization, the information system is known as Transaction Processing System or Data Processing System. Some examples of information provided by such systems areprocessing of orders, posting of entries in bank, evaluating overdue purchaser orders etc.
Transaction Processing SystemsTPS processes business transaction of the organization. Transaction can be any activity of the organization. Transactions differ from organization to organization. For example, take a railway reservation system. Booking, canceling, etc are all transactions. Any query made to it is a transaction. However, there are some transactions, which are common to almost all organizations. Like employee new employee, maintaining their leave status, maintaining employees accounts, etc.
This provides high speed and accurate processing of record keeping of basic operational processes. These include calculation, storage and retrieval.
Transaction processing systems provide speed and accuracy, and can be programmed to follow routines functions of the organization.
Management Information SystemsThese systems assist lower management in problem solving and making decisions. They use the results of transaction processing and some other information also. It is a set of information processing functions. It should handle queries as quickly as they arrive. An important element of MIS is database.
A database is a non-redundant collection of interrelated data items that can be processed through application programs and available to many users.
Decision Support SystemsThese systems assist higher management to make long term decisions. These type of systems handle unstructured or semi structured decisions. A decision is considered unstructured if there are no clear procedures for making the decision and if not all the factors to be considered in the decision can be readily identified in advance.
These are not of recurring nature. Some recur infrequently or occur only once. A decision support system must very flexible. The user should be able to produce customized reports by giving particular data and format specific to particular situations.
Summary of Information SystemsCatagories of Information SystemCharacteristicesTransaction Processing System
Substitutes computer-based processing for manual procedures.Deals with well-structured processes. Includes record keeping applications.
Management information system
Provides input to be used in the managerial decision process. Deals with supporting well structured decision situations. Typical information requirements can be anticipated.Decision support system
Provides information to managers who must make judgements about particular situations. Supports decision-makers in situations that are not well structured.Related Topics
Multimedia education is any form of education technique that uses multiple forms of media. For example, they might use a PowerPoint presentation.
What are the non functional requirement of a hotel management system?
A hotel management system is a set of computer network applications for hotels and hospitality businesses. This can include tracking guest data, managing financial records, processing room reservations and issuing keys.Hotel management software is a database-driven system that helps businesses in running their day to day operation smoothly.
What is Difference between document and data?
A document is the result of a process in a flowchart. Data can be used as an input and output in a flowchart. Also data is more specific(e.g. ordernumber) and a document is more an overview of data.
Queries of a database can be fast or slow. Depends on a lot of things. The size of the table, the amount of data you are requesting from the query, etc. One of the ways a dba can help query optimization, is by "updating statistics" on a table. Statistics of a table allows the query to find the most efficient way to gather the data from the table.
Should you use SQL or Microsoft Access to run enterprise databases?
Hi, This depends on the number of users who are going to use the database simulteneously. If the total number of users lest 25 and from only one location MS Access should be enough. If there are going to more than 25 user & accross different location, You require MS SQL . Hope this helps
What is the difference between sap and oracle?
Oracle is focused on helping computers do their jobs better, while SAP is focused on helping people do their jobs better
Servers do many important tasks, a high quality server like Microsoft Project Server is capable of handling following tasks:
1. Work Management
2. Demand Management
3. Portfolio Analytics & Selection
4. Resource Management
5. Schedule Management
6. Financial Management
7. Time & Taks Management
8. Collaboration
9. Issues & Risk Management
10. Reporting and Business Intelligence
11. Program Management
Source: epmainc.com/microsoft-project-server.html
What programming languages may be used to write applications for an Access Database?
The default language for Access applications is VBA (Visual Basic for Applications). With most of the languages C, C Sharp, and the proper references attached one can create application that talk to the Access engine. Proud to be of service HoloGuides.com
How To close a Table in Microsoft Access?
Well, the big X in the top right of the screen could be helpful. If you want to close the table and STAY in the program you need to ask someone else who has heard of the program.
What are the scope of computerized payroll system?
1.1 IMPROVED SERVICES
An objective of the proposed system is to improve the existing system's services, in order to:
Increase employer and employee satisfaction
Provide the quality
Create a controlled information management environment
1.2 BETTER PERFORMANCE
It is an objective of our proposed system to provide better performance which is managed by providing
Desired flexibility
Fast response
Ability to support changes.
Ability to maintain the quality of services.
1.3 EFFICIENT GUI
One of the objectives of the proposed system is to provide a user friendly GUI, that will enable the user to work on clicks and make the information transfer possible with the most common I/O devices.
1.4 MORE INFORMATION
An objective of our proposed system is to develop a system that will eliminate the problem of insufficient and incomplete information.
1.5 DECISION SUPPORT
By providing the facility of what-if analysis, we will make a decision support system.
1.6 STRONGER CONTROLS
The proposed system will have stronger controls. Controls like passwords, various levels of user access and option will be added.
1.7 ELIMINATION OF RUNNING COST
We are going to develop the proposed system with an objective to eliminate the running cost by overcoming the continuous stationery expenses, manual storage need, and extra staff in the information resource department of the Organization .
