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
A database is a list of records, each record contains the same information in the same format as every other record. Using a database enables the user to find one or more records quickly and efficently, and to perform some calculations on the information stored.
Whichever UTECH person this is, Stop Being lazy and go research the questions.
General tree to binary tree conversion?
The process of converting the general tree to a binary tree is as follows:
* use the root of the general tree as the root of the binary tree
* determine the first child of the root. This is the leftmost node in the
general tree at the next level
* insert this node. The child reference of the parent node refers to this
node
* continue finding the first child of each parent node and insert it below
the parent node with the child reference of the parent to this node.
* when no more first children exist in the path just used, move back to the
parent of the last node entered and repeat the above process. In other
words, determine the first sibling of the last node entered.
* complete the tree for all nodes. In order to locate where the node fits
you must search for the first child at that level and then follow the
sibling references to a nil where the next sibling can be inserted. The
children of any sibling node can be inserted by locating the parent and then
inserting the first child. Then the above process is repeated.
Unary relationship in database?
A fixed length record is a data structure that contains a standard amount fields, within the actual record.
- Minimal Data Redundancy
- Consistency of Data
- Integration of Data
- Sharing of Data
- Data independence
- Ease of Application Development
Log shipping is one of the failover solutions offered by SQL Server 2000. In this context, failovermeans substituting primary server with a backup (sometimes also referred to as standby) server if the primary hardware becomes unusable. Failover solutions can also be used to provide close to 100% uptime-during primary database or server maintenance and during software upgrades you could use the standby server to continue serving your customers. Failover solutions can be automatic or manual. With automatic failover, the backup server detects when the primary server is not available and takes over without any intervention from the database administrator. An example of an automatic failover solution is clustering. With manual failover, the database administrator (DBA) has to perform some steps to bring the standby server online. In SQL Server 2000, log shipping is a form of manual failover.
Manual vs computerized systems?
Salient Features of Computerized accounting
2.1. Fast, Powerful, Simple and Integrated
Computerized accounting is designed to automate and integrate all the business operations, such as sales, finance, purchase, inventory and manufacturing. With Computerized accounting, accurate, up-to-date business information is literally at the fingertips. The Computerized accounting combine with enhanced MIS, Multi-lingual and Data organization capabilities to help the company simplify all the business processes easily and cost-effectively.
2.2. Complete Visibility
Computerized accountings giving the company sufficient time to plan, increase the customer base, and enhance customer satisfaction. With Computerized accounting the company will have greater visibility into the day-to-day business operations and access to vital information.
2.3. Enhanced User Experience
Computerized accounting allows the company to enter data in a variety of ways which makes work a pleasure. Adapting to the specific business needs is possible.
2.4. Accuracy, Speed
Computerized accounting has User-definable templates which provides fast, accurate data entry of the transactions; thereafter all documents and reports can be generated automatically, at the press of a button.
2.5. Scalability
Computerized accounting adapts to the current and future needs of the business, irrespective of its size or style.
2.6. Power
Computerized accounting has the ability to handle huge volumes of transactions without compromising on speed or efficiency.
2.7. For Improved Business Performance
Computerized accounting is a highly integrated application that transforms the business processes with its performance enhancing features which encompass accounting, inventory, reporting and statutory processes. This helps the company access information faster, and takes quicker decisions. Computerized accounting also guarantees real-time optimization of operations and enhanced communication.
2.7. Quick Decision Making
Generates real-time, comprehensive MIS reports and ensures access to complete and critical information, instantly.
2.8. Complete Reliability
Computerized accounting makes sure
the opposit of the above will do for the manual system
to save place in the memory
What is the difference between Database and databank?
Databank (usually a device) containing several databases.
What advantages of QBE compared to SQL?
QBE is an advantage over SQL as it is a visual technique allowing non-experts to do searches, as it is simple to understand.
What is another name for a file allocation unit?
another name for a file allocation unit is a cluster.
What is the ATM Block diagram?
in ATM Block diagram there is user who can insert his card then enter pin no. request goes to bank get approval then insert amount then get result
attributes for entity ATM
1.user ID
2. password(pin no.)
3. amount
What might a bank use a database for?
To store detail of customers,
how much they have in the bank,
what their billing address is,
the account name,
account type,
sort code,
account number,
and more like them above.
Disadvantages of computerized payroll system?
The primary disadvantage of a computerized payroll system is human error. A computer is only as good as the person inputting the information.
What is the purpose of the payroll system?
The payroll program is run at a specific point in time, not only to calculate an employee's basic remuneration but also any special payments, overtime payments or bonuses that must be effected for the period in question
