answersLogoWhite

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

What are the differences between database systems and information retrieval systems?

database systems work with relational databases(well structured data) while information retrieval system works on unstructured data (raw text files/documents).

in database systems main datastructure used is relational tables with well define values for each row and column ont the other hand IR system uses Inverted index which is the index of {term,docIDs} entries. for each term there is a corresponding postings list(the list of documents in which the term is present)/

database sytems work on data that are related to each other and have a well defined domain while IR systems may or may not have such a luxury.

Why study accounting information system?

There are a number of reasons why your need to study accounting information system. This will help you move with technology and be able to apply your accounting skills in a digital world.

How can you fix a spreadsheet if the user has forgotten to enter some important data?

It depends on what is missing. It might be a case of inserting a few blank rows or columns to enter the data in. You can do that by putting the cursor where you want the extra rows or columns to be and go to the Insert menu and pick Rows or pick Columns. You can then enter the data that is missing and redo the formulas. Whatever is missing, all you can do is enter it and fix up the spreadsheet. If you know what is missing and where you want to put it, then it is not a major problem. Before doing it, save a copy of the file as it is, with a different name, in case you need to go back to it and start again.

What are the external sources of information for the top management to support their decision making justifying its position in an MIS?

Mangers in organization need information on what is happening within the organization as well as about the external environment within which the organization operates. People at lower level of organization need more of the internal information an less of external information. But with increasing level level of management hierarchy the proportion of external information increases and the quantity of internal information decreases. The managers at the top management level thus need a large amount of external information on the environment within which they operate.

The external information needed by the top management is often divided in two broad types - information on immediate environment of the company, and that on the wider environment. The immediate environment of the company include its customers, suppliers, competitors and the industry within which the organization operates.

The wider environment includes the everything else outside the company. The information in the wider environment is often classified according to PESTEL framework, which divides the total external environmental factore in following six groups.

  • Political
  • Economical
  • Social
  • Technological
  • Environmental (Physical)
  • Legal

The various sources of information through which top level managers collect external information include.

  • Their own observation and personal study of what is happening in the environment.
  • Information collected and fed to them by their subordinates and colleagues in the organization.
  • Information collected from customers, suppliers and other persons such as bankers - with whom the company deals.This information may be obtained by top managers directly or through their subordinates and colleagues.
  • Information collected as a part of normal business activities. For example, when a company sell its products through the process of open tendering, it is able to get valuable information about competitors.
  • Through publications. These include statistical data, articles, and advertisements.
  • From organizations that collect, compile and analyse and sell business information.
  • Through market research,and other similar field surveys.
  • Through experts such as layers and economists.

About bubble sort?

bubblesort(int[] unsortedList){ 1)for(int i=1; iunsortedList[j]){ 4) int temp = unsortedList[i]; 5) unsortedList[i] = unsortedList[j]; 6) unsortedList[j] = temp; } } } return unsortedList } Explanation: 1: take each element in unsortedList, one at a time, and call the variable in it i 2:for each i, take each element further down the list one at a time and call this j 3:compare i to j, if i is grater than j, then j should go before anything i should go before so swap them. j will then be the new i, but is still in the correct place in the list because i was up until it saw j. i will be put back where it shopuld go next time round. Example: 1 4 3 7 5 6 I=14 3 7 5 6 I=4>j=3 1 3 4 7 5 6 I=34 7 5 6 I=47 5 6 I=7>j=5 1 3 4 5 7 6 I= 5>j=6 1 3 4 5 7 6 I=7>j=6 1 3 4 5 6 7 return 1 3 4 5 6 7 bubblesort(int[] unsortedList){ 1)for(int i=1; iunsortedList[j]){ 4) int temp = unsortedList[i]; 5) unsortedList[i] = unsortedList[j]; 6) unsortedList[j] = temp; } } } return unsortedList } Explanation: 1: take each element in unsortedList, one at a time, and call the variable in it i 2:for each i, take each element further down the list one at a time and call this j 3:compare i to j, if i is grater than j, then j should go before anything i should go before so swap them. j will then be the new i, but is still in the correct place in the list because i was up until it saw j. i will be put back where it shopuld go next time round. Example: 1 4 3 7 5 6 I=14 3 7 5 6 I=4>j=3 1 3 4 7 5 6 I=34 7 5 6 I=47 5 6 I=7>j=5 1 3 4 5 7 6 I= 5>j=6 1 3 4 5 7 6 I=7>j=6 1 3 4 5 6 7 return 1 3 4 5 6 7

What is the difference between Cisco networking and Oracle database administration?

Night and day. Apples and oranges.

The skills aren't equivalent, transferable or related.

What are the function and importance of the system catalog?

The data dictionary of a DBMS. The system catalogue stores meta-data including the schemas of the databases. It is a mini-database, and is usually stored using the DBMS itself in special tables called system tables. It maybe referred to as being "on line", as it is active, and can be queried by users like any other table.

What might cause a computer to not save pictures?

It depends on what you are trying to do. If you right click on an image and it errors saying the image is protected--that has nothing to do with your computer--the owner of the image is protecting it from being copied. If you can right click on an image and you get the "save as" option, you can usually choose the format (jpg or bmp are the most common). Pay attention to what folder the image is being saved in. It may be as simple as you not being able to find the saved image.

Definition of hospital management system?

A hospital management system is an information system that manages the aspects of a hospital. This may include the administrative, financial, and medical processing.

What is oracle software structures?

when we install d oracle software, on oracle directory structure is created to store the executables , shared libraries , configuration files , trace files , and so on both server and client software is stored in the same directory. Oracle is installed on the server using on operating system account created specially for the task oracle has a directory structure.

What are the basic concepts of DBMS?

DBMS stands for DataBase Management System. The main concepts are the structure, the manipulation, and a set of integrity rules.

What are the benefits of a laptop computer?

A laptop is a portable personal computer that first became feasible in 1971. The benefits of laptops are their portability, energy savings, storage and capability.

What is a entity?

Entity can be an account, activity, or contact about which data can be stored.

What is a File definition table?

You might be thinking why would someone write a file when we have all the other databases available in which we can store our data. There are many applications in which we need to backup the database or to send the data to another user through email. In all those applications you can use any database but the same operations can also be performed using a file system. Another good reason could be some companies cannot afford to buy expensive databases and their only choice to collect data is in the form of files. Also there could be some operations for which files will be the best option.

What is a select new technology models for business?

A select new technology used in business are things like touch-screen registers. This helps business to check-people out more efficiently.

What is logical file?

Logical file is a type of file that provides a view of the data stored into the Physical file. It does not contain data. A logical file contains only an index to the data stored into the physical file.

How may management information systems personnel be said to be integral to the operations of business?

MIS personnel are more visible than they were in the 1960s and 1970s, when they were hidden away from the rest of the company and performed tasks behind closed doors.

A query language is an example of?

Any thing that has to do with database is a query lanquage. As in query the data to retrieve whatever you are looking for.

How can you transfer data from Oracle to Microsoft Word?

I just looked at Word--I did not see an import comma delimited feature. So, I don't think you could do a direct transfer from Oracle to Word. Now, if you wanted data from a select statement into a text file, try this:

1. right click

2. log incoming to file

3. name file

4. select data and everthing that goes to the screen will be captured into the log file.

5. right click, turn log file off.

6. Find file via windows explorer.