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 workplaces keep databases?
Various workplaces maintain databases, including businesses, educational institutions, healthcare organizations, and government agencies. Corporations often use databases for customer relationship management, inventory tracking, and financial records. Educational institutions store student information and academic records, while healthcare organizations maintain patient records and treatment histories. Government agencies use databases for managing public records, statistics, and services.
Why should a number be stored as text data type?
because if u do it as number then the 0 at the start would automatically be removed so u write in text otherwise the data would be wrong
How do you create dbms using c?
Creating a Database Management System (DBMS) using C involves designing a structure to store and manage data, typically in files. You would start by defining a data model and implementing functions for operations such as creating, reading, updating, and deleting records (CRUD). Use file I/O operations to persist data, and consider implementing indexing for efficient data retrieval. Additionally, you might include features like transaction management and user authentication for a more robust system.
What kind of motivations is required for data mining?
The Street lawyers or governments were given the chance to appreciate them
Why it is important to have a well structured filing system?
A well-structured filing system is crucial for efficient information management, enabling quick access to documents and data when needed. It reduces the risk of losing important files and minimizes the time spent searching for information, enhancing productivity. Additionally, a systematic approach helps maintain organization and clarity, making it easier to comply with legal and regulatory requirements. Overall, it promotes better decision-making and communication within an organization.
How do you contact meenan security systems management?
We have Meenan Security for a private residence. I would like to contact
upper mangement with my concerns regarding Meenan Security supporting
the Dutchess County area. Please help!
What are the characteristics of financial management information system?
A financial information management system is accurate, integrated with other systems and analytical. A good system will help management avoid problems by generating reports.
What are disadvantages of recreational database?
It's slacking off all the time rather than being an actual database.
Ans2:You sure you don't mean "Relational database"?Why relational database approach is better than earlier method?
Relational model helps in logical relation between two dimensional tables . It maintains data integrity and eliminates data redundancy. Earlier methods involved redundant set of data for maintaining relations between set of data.
What SQL keyword must be used to remove duplicate rows from the result?
The DISTINCT keyword can be used to return only distinct (different) values.
SQL SELECT DISTINCT SyntaxSELECT DISTINCT column_name(s)FROM table_name
Which role monitors incoming invoice data from external systems such as Wide Area Work Flow WAWF?
Invoice Interface Processing Monitor
What is database management sysstem?
A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. Adatabase is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model orobject model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
Why DBMS is preferred rather than file processing system?
er diagram for hospital management
eitity set are
doctor
department
pesent
nurse
test
When does a DBA use backwards recovery?
-Undo problem transactions
-Apply before images from log to undo their updates
A Document Type Definition (DTD) is a set of markup declarations that define a document type for an SGML-family markup language (SGML, XML, HTML).
A DTD uses a terse formal syntax that declares precisely which elements and references may appear where in the document of the particular type, and what the elements' contents and attributes are. A DTD can also declare entities which may be used in the instance document.
What kind of problems are associated with redundancy in databases?
problems associated with redundancy in data base,
Redundancy occurs in same data multiple time tends to several problems some times redundancy controlling is necessary to improve the performance of the query.
What is the maximum number of characters a text field can store in Microsoft access?
32,767 characters in a standard text field.
What is database Give example?
A navigational database is a type of database in which records or objects are found primarily by following references from other objects. Navigational interfaces are usually procedural, though some modern systems like XPath can be considered to be simultaneously navigational and declarative.
Navigational access is traditionally associated with the network model and hierarchical model of database interfaces, and some have even acquired set-oriented features.[1]Navigational techniques use "pointers" and "paths" to navigate among data records (also known as "nodes"). This is in contrast to the relational model (implemented in relational databases), which strives to use "declarative" or logic programming techniques in which you ask the system for what you want instead of how to navigate to it.
For example, to give directions to a house, the navigational approach would resemble something like, "Get on highway 25 for 8 miles, turn onto Horse Road, left at the red barn, then stop at the 3rd house down the road"; whereas, the declarative approach would resemble, "Visit the green house(s) within the following coordinates...."
Hierarchical models are also considered navigational because one "goes" up (to parent), down (to leaves), and there are "paths", such as the familiar file/folder paths in hierarchical file systems. In general, navigational systems will use combinations of paths and prepositions such as "next", "previous", "first", "last", "up", "down", "owner", etc.
"Paths" are often formed by concatenation of node names or node addresses. Example:
Sample database nodes: A labeled graph on 6 vertices and 7 edges. (Numbers are used for illustration purposes only. In practice more meaningful names are often used. Other potential attributes are not shown.)
Node6.Node4.Node5.Node1
Or
Node6/Node4/Node5/Node1If there is no link between given nodes, then an error condition is usually triggered with a message such as "Invalid Path". The path "Node6.Node2.Node1" would be invalid in most systems because there is no direct link between Node 6 and Node 2.
The usage of the term "navigational" allegedly is derived from a statement by Charles Bachman in which he describes the "programmer as navigator" while accessing his favored type of database. [1]
Except for hierarchical file systems (which some consider a form of database), navigational techniques fell out of favor by the 1980s. However, object oriented programming and XML have kindled a renewed, but controversial interest in navigational techniques.
Critics of navigational techniques view them as "unstructured spaghetti messes", and liken them to the "goto" of pre-structured programming. In other words, they are allegedly to data organization what goto's were to behavior flow. In this view, relational techniques provide improved discipline and consistency to data organization and usage because of its roots in set theory and predicate calculus.
Some also suggest that navigational database engines are easier to build and take up less memory (RAM) than relational equivalents. However, the existence of relational or relational-based products of the late 1980s that possessed small engines (by today's standards) because they didn't use SQL suggest this is not necessarily the case. Whatever the reason, navigational techniques are still the preferred way to handle smaller-scale structures.
A current example of navigational structuring can be found in the Document Object Model (DOM) often used in web browsers and closely associated with JavaScript. The DOM "engine" is essentially a light-weight navigational database. The World Wide Web itself and Wikipedia could potentially be considered forms of navigational databases, though they focus on human-readable text rather than data (on a large scale, the Web is a network model and on smaller or local scales, such as domain and URL partitioning, it uses hierarchies). In contrast, the Linked Data facet of the Semantic Web is specifically concerned with network-scale machine-readable data, and follows precisely the 'follow your nose' paradigm implied by the navigational idea.
[edit]See also[edit]References- ^ Błażewicz, Jacek; Królikowski, Zbyszko; Morzy, Tadeusz (2003). Handbook on Data Management in Information Systems. Springer. pp. 18. ISBN 3-540-43893-9.
View page ratings
Rate this page
Trustworthy
Objective
Complete
Well-written
I am highly knowledgeable about this topic (optional)
Submit ratings
- This page was last modified on 14 June 2012
