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 is the advantage of organizing data on a table?

You can retrieve information quickly, unlike a graph. It is also easier to compare, and to find the rate of change.

Write a function to delete a specified node from linked list?

Presumably you have a situation like this:

Each node is an area in memory with (1) the address of the following node, (2) the address of the previous node, and (3) some more data.

Say the nodes are linked in alphabetical order and part of the list goes like this:

PrevNode

-> Data = "Cincinnati"

-> FrontPtr = address of "Cleveland"

-> BackPtr = address of "Amelia"

CurrNode

-> Data = "Cleveland"

-> FrontPtr = address of "Columbus"

-> BackPtr = address of "Cincinnati"

NextNode

-> Data = "Columbus"

-> FrontPtr = address of "Dayton"

-> BackPtr = address of "Cleveland"

...and you want to delete the middle one. Steps could be:

1. save the address of CurrNode as KillNode

2. copy CurrNode->FrontPtr (address of "Columbus") into

PrevNode->FrontPtr

3. copy CurrNode->BackPtr (address of "Cincinanti") into

NextNode->BackPtr

4. free up the space at the location named in KillNode

What is databse integrity control?

Integrity control means keeping the data consistent and correct by means of controls that a database administrator puts on the database. Only persons with privileged accounts can load data into the database. Even with that, there are rules on the table fields that allow only a certain type of data to be inserted.

How do you draw ERD and DFD for employee attendance system?

It is not possible to draw ERD for attandence because employee attandence is basically a primary key and drawing ERD would violate its referential integrity

What is contiguous allocation?

Paging is a memory management scheme that permits the physical- address space of process to be noncontiguous.

How do you use software for inventory?

Inventory management is a very simple concept - don't have too much stock and don't have too little. Since there can be substantial costs involved in straying above and below the optimal range, careful inventory management can make a huge difference in the profitability of a business. Although the concept is simple, the process of getting the right balance can be quite a complex and time consuming task without the right software technology.

There are two fundamental questions that must be answered, in order to manage the inventory of any physical item - when to order and how much to order.

Inventory Management can be easy. The first step is defining what you need tracked or inventoried. Learn more by reading the quick "Guide to Buying Inventory Software That Fits"

Example of automated system?

a automated system is any object which makes decision by its self without any humans interfering.

Differences between XA and Non XA Data sources?

An XA transaction, in the most general terms, is a "global transaction" that may span multiple resources. A non-XA transaction always involves just one resource.

An XA transaction involves a coordinating transaction manager, with one or more databases (or other resources, like JMS) all involved in a single global transaction. Non-XA transactions have no transaction coordinator, and a single resource is doing all its transaction work itself (this is sometimes called local transactions).

XA transactions come from the X/Open group specification on distributed, global transactions. JTA includes the X/Open XA spec, in modified form.

Most stuff in the world is non-XA - a Servlet or EJB or plain old JDBC in a Java application talking to a single database. XA gets involved when you want to work with multiple resources - 2 or more databases, a database and a JMS connection, all of those plus maybe a JCA resource - all in a single transaction. In this scenario, you'll have an app server like Websphere or Weblogic or JBoss acting as the Transaction Manager, and your various resources (Oracle, Sybase, IBM MQ JMS, SAP, whatever) acting as transaction resources. Your code can then update/delete/publish/whatever across the many resources. When you say "commit", the results are commited across all of the resources. When you say "rollback", _everything_ is rolled back across all resources.

The Transaction Manager coordinates all of this through a protocol called Two Phase Commit (2PC). This protocol also has to be supported by the individual resources.

In terms of datasources, an XA datasource is a data source that can participate in an XA global transaction. A non-XA datasource generally can't participate in a global transaction (sort of - some people implement what's called a "last participant" optimization that can let you do this for exactly one non-XA item).

How do you delete a node with two children in binary tree using c?

Use a recursive function.

void delete_node (node* n) {

/* ensure the given pointer is valid */

if (n==NULL) return;

/* recursively delete the left child */

delete_node (n->left);

n->left = NULL;

/* recursively delete the right child */

delete_node (n->right);

n->right = NULL;

/* delete the data (assuming the data is a pointer)*/

free (n->data);

n->data = NULL;

/* finally, delete the node itself */

free (n);

n=NULL;

}

What was the early computer that handled business data?

  • The british food company Lyons made a business computer called LEO.
  • Remington Rand made a business computer called UNIVAC.
  • IBM made their first business computer called the 702.

All of these happen within a few years of each other, do some research on your own now.

What is the best method of data input for a printed questionnaire?

A Keyboard; aside from avoiding uncertainty from unclear handwriting or other methods, and because "...most input data consists of letters and numbers. In addition, people are usually familiar with how to use keyboards and with the layout of the keys. Thus, little training is required for users to become familiar with keyboards" (Nickerson, pg. 75 of view-text)

What is journaling in file system?

"Journaling" is the process of recording every process that happens on the file system. In the event of a crash, the file system will not become corrupted, since any uncommitted changes not written to the journal can be rolled back.

How do you repair keyless entry circuit board for 99 Chrysler Sebring Convertible?

take it to your near autozone,they started making some aftermarket products,if they don't have one for your vehicle take it to a Chrysler dealership and they will match one up but if they have to reprogram it, it will cost extra along with the keyless entry,sometimes they don't have to reprogram them.