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 is an information system?
The term information system has the following meanings:
- An information system consists of three components: human, task, application system. In this view information are defined in the three levels of semiotics. Data which can be automatically processed by the application system correspond to the syntax-level. In context with an individual who interprets the data they become information, which correspond to the semantic-level. Information become knowledge, when an individual knows (understand) and evaluates the information (e.g. for a specific task). This corresponds to the pragmatic-level.
- A system, whether automated or manual, that comprises people, machines, and/or methods organized to collect, process, transmit, and disseminate data that represent user information.
- RAW DATA + PROCESS = MEANINGFUL INFORMATION. This concept where Raw Data which has hardly any meaning is Processed and the Outcome which results in Meaningful information is simply understood as the Information System. For example adding of two numbers. The two numbers are just Raw Data that mean nothing for a start but the addition process when applied to the two numbers will result in a meaningful answer. Thus Information systems are born where systems are created and put into place to filter raw data to produce sensible information.
- Any telecommunications and/or computer related equipment or interconnected system or subsystems of equipment that is used in the acquisition, storage, manipulation, management, movement, control, display, switching, interchange, transmission, or reception of voice and/or data, and includes software, firmware, and hardware. Source: from Federal Standard 1037C and from MIL-STD-188 and from the National Information Systems Security Glossary The simplest model that describes the Structure and Behaviour of an Information System takes five objects: For Structure: * Repositories, hold data permanent or temporarily, such as buffers, RAM, hard disks, cache, etc. * Interfaces, exchange information with the non-digital world, such as keyboards, speakers, scanners, printers, etc. * Channels, connect repositories, such as buses, cables, wireless links, etc. A Network is a set of logical or physical channels. For Behaviour: * Services; provide value to users or to other services via messages interchange. * Messages; carries a meaning to users or services. Source: from book "Seguridad de la Informacion", 2004 ISBN 84-933336-7-0
- In the mathematical area of domain theory, a Scott information system (after its inventor Dana Scott) is a mathematical structure that provides an alternative representation of Scott domains and, as a special case, algebraic lattices. An information system is a set of inter-related components for collecting, processing, storing, and distributing information for decision making and support. This question makes me laugh so hard because I just finished taking a course on information systems and this is where that definition comes from! Information systems are used by businesses to help their...er...business run smoother.
Information Systems are either a hardware or a software which enables storage, manipulation and distribution of information.
When you connect audience to the needed print, media, scientific material resource bases, you create an information system.
What's the difference between a field and a record using Microsoft Excel?
Field and Record are database terms.
If you look at it from the top-down, a database consists of records--a collection of data, all of which belongs to one person or account or business or other unique entity; and each record consists of a collection of fields, each of which contains a chunk of data. .
The way simple databases have historically been set up, a row corresponds to a record, and the individual cells within that row correspond to the particular data or expression in the various fields which make up that record. Records are represented by particular rows, and fields identify the type of information in each particular column. Where the rows and columns intersect is a cell, which corresponds to the particular field (type of information) for a particular record.
How is a relational database system different from other databases in tabular form?
To put it simply there are many types of data systems. But we'll just talk about two of the most common here: The first is commonly known as flatfile. The flat file is pretty simple: Each major category of data (e.g. Employees) is contained in a single file. If that employee can have multiple phone numbers, the flat file has to be set up with space for each possible number (home, work, cell, pager, etc). (Unlike what the original answer said) you can set up basic links between flat files (e.g. on an employee id), but flatfile databases are not set up for working with multiple files at once.
How do you print all data in a Binary Search Tree?
By using Depth First Search or Breadth First search Tree traversal algorithm we can print data in Binary search tree.
What is the recovery plan for cheetahs?
The recovery plan for cheetahs is stronger enforcement of anti-poaching laws. In Namibia, there is a farmer education program, to give farmers alternatives to keep their livestock safe.
Data abstraction is the reduction of a body of data to a simplified representation of the whole. Data abstraction is usually the first step in database design in order to create a simplified framework that can be added to in order to complete the database.
It have helped organizations and associations spare time and expense of generation, which has been preference to all business, they deal with these headways to increase upper hand. A decent a sample is the 3G/4G broadband, little organizations have exploited this super quick web to achieve target markets with less expenses of operation.
Difference between traditional and latest DBMS package?
Traditional FPS and DBMS both are different from each other. In DBMS there is security of data as well as integrated data while this is not in FPS.
What is meant by a database row What is a tuple?
In database there are no. of records stored in it. These records are stored in table . Row in this table is known as a tuple. So tuple is basically a row.
Difference between ddl and dml?
DML(data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables. DDL(Data definition language) provides statements for creation and deletion of tables, view, indexes etc.
What are the advantages and disadvantages of the product life cycle theory?
The intended advantage of product life cycle theory is to maximize the profitability of the product. A few disadvantages are that sometimes products can see a revival in sales which the theory does not take into account. In addition, the theory doesn't take into account product redesign potential.
What is another name for bookmark?
There is only 1 other name for the word bookmark. This other name is a bookmarker and you can say that it is the synonym of bookmark.
How can you justify that a DBMS is better to use than Flat-file database?
A DBMS offers quicker access to the data within the database, particularly with larger datasets. It also makes updates to the data easier.
True or false the congress vetoes laws?
False. As according to the Constitution of the United States of America only the chief executive, that is the president, has the power of veto.
Characteristics of an efficient database?
Efficient databases make storing and retrieving of data fast and easy. The characteristics of such databases are, having input constraints, implementing use of unique keys for fields, avoiding data redundancy and maintaining data integrity.
A payroll system is a database that includes the details of employees and their respective wages in a company. This is what is used to generate the pay slip.
In an operating system, burst time refers to the time that it takes to complete execution of a particular task or process. It is used in CPU scheduling.
They are collections of information that is or will be presented electronically. Their sizes can range from small to very large.
In which manner is expense data usually reported?
Expense data is usually reported with expense reporting software. The actual setup depends on the company and the type of expense data being collected.
Name 2 companies that use databases?
Schools use database to keep students information like their phone number and email address and many other things
Banks- they use database because they need to keep customers card details and information
Hope this helped
What duties do database administrators not routinely perform?
what are the responsibilites of a fund administrator
How can referential integrity be enforced in an object-oriented system in uml?
Referential integrity in an object-oriented system can be enforced using UML by defining associations between classes with multiplicity constraints. By specifying these constraints (such as 1 to 1, 1 to many, etc.), you ensure that instances of one class are properly connected to instances of another class. This helps to maintain data consistency and integrity within the system.
