What is Attribute in system analysis?
Knowledge of organisation
Knowledge of computers and software
Good interpersonal relations
Ability to communicate
Analytical mind
Breadth of knowledge
What is the difference between a reporting entity and a taxable entity?
the difference between a reporting entity and a taxable entity is, a reporting entity is the company or organization and the taxable entity is the individual.
What four main types of actions involve databases?
self-describing nature of a database system.
insulation between programs and data, and data abstraction.
support of multiple views of the data.
sharing of data and multiuser transaction processing.
What is transaction processing in dbms?
Transaction processing is information processing that is divided into individual, indivisible operations, called transactions. Each transaction must succeed or fail as a complete unit; it cannot remain in an intermediate state. Transaction mandatorily requires acknowledgment to get received as a necessary feedback for accomplishment.
Transaction processing is designed to maintain a computer system (typically a database or some modern filesystems) in a known, consistent state, by ensuring that any operations carried out on the system that are interdependent are either all completed successfully or all canceled successfully.
For example, consider a typical banking transaction that involves moving $700 from a customer's savings account to a customer's checking account. This transaction is a single operation in the eyes of the bank, but it involves at least two separate operations in computer terms: debiting the savings account by $700, and crediting the checking account by $700. If the debit operation succeeds but the credit does not (or vice versa), the books of the bank will not balance at the end of the day. There must therefore be a way to ensure that either both operations succeed or both fail, so that there is never any inconsistency in the bank's database as a whole. Transaction processing is designed to provide this.
Transaction processing allows multiple individual operations to be linked together automatically as a single, indivisible transaction. The transaction-processing system ensures that either all operations in a transaction are completed without error, or none of them are. If some of the operations are completed but errors occur when the others are attempted, the transaction-processing system "rolls back" all of the operations of the transaction (including the successful ones), thereby erasing all traces of the transaction and restoring the system to the consistent, known state that it was in before processing of the transaction began. If all operations of a transaction are completed successfully, the transaction is committed by the system, and all changes to the database are made permanent; the transaction cannot be rolled back once this is done.
Transaction processing guards against hardware and software errors that might leave a transaction partially completed, with the system left in an unknown, inconsistent state. If the computer system crashes in the middle of a transaction, the transaction processing system guarantees that all operations in any uncommitted (i.e., not completely processed) transactions are cancelled.
Transactions are processed in a strict chronological order. If transaction n+1 intends to touch the same portion of the database as transaction n, transaction n+1 does not begin until transaction n is committed. Before any transaction is committed, all other transactions affecting the same part of the system must also be committed; there can be no "holes" in the sequence of preceding transactions.
What are the Disadvantages of numerical filing system?
A numerical filing system will need a way to look up a patient's name in order to get their chart number. This can take a little longer than simply finding a file by alphabetical order.
Can database be used for calculations?
No, databases can only do a selective amount of calculations, but you can get the exact same responses but many more detailed calculations by using Spreadsheet software, I recommend using Microsoft Excel.
What are the disadvantages of a paper based diary system?
There can be many
disadvantages of a paper diary as they are sometimes illegible-but this differs
from user to user. The legibility of the diary is very important especially
when other colleagues are in touch with the diary for specific information or dates-as
some people do not have legible handwriting, it becomes harder for other
colleagues to access the information properly. The paper diary can be lost
easily and if an opposing business member gets hold of it many vital
information can be lost. Paper diaries can be damaged very easily if substances
such as water spill on it.
It cannot be edited very easily as it is handwritten whereas if it were on the
electronic diary you could just edit your work by deleting the specific
information and retyping the edited information up. It is not as reusable as
the electronic diary as new diaries will have to be brought every year. Paper
diaries can be very large, massive and stout in size
What advantages does a live system have over an installed system?
what is a live system? what advantages does it have over an installed system?
1. Live System- A computer that runs the Wide Area Progressive games and displays the main system window. Advantages- Customization, cost, free market, stability, and community.
What is the meant by anomaly in database?
Data anamaly means same type of data present in database as a duplication.So while updating or modifying the information in the database we gets the problem of data inconsistency to solve this problem we need to remove the duplicated data
What are anomalies in database?
Anomalies is the data within the database; it is the copy of the original data it needs to be updated in order to avoid problems such as viewing the website. There are four types of anomalies which are Insertion anomaly, Deletion anomaly, Duplicate entry and Modify (Update anomaly).
Insert anomaly is the entity that relates to another entity within the table. If the data doesn't relate to another entity then there is no point of entering it, therefore a unique data is needed to identify a particular data to insert the data that relates with it such as employee ID number.
Example of insert anomaly: If any company's manager need to insert their employee salary to the employee's ID, they then need to make sure that the employee id is correct otherwise, if it's wrong then they will give unfair salary to their employee by which they will have bad name onto their company.
What is the role of data manager in dbms?
DBMS stands for DataBase Management System. So it's role is basically to manage the database. More specifically this software controls the storage, organization, retrieval, integrity and security of the data in the database.
What are to advantages of a database?
A database is a collection of interrelated data and the advantages of a database are ensured efficiency, standardized data, maintainable data, integrated data, reduced redundancy of data.
What is the relationship between manual and computerize accounting systems?
With manual accounting you have to create journal entries, invoices, and other documents by hand and with computerized accounting you just have to enter the information on the forms, because the forms have already been created in the software.
What are the structures into which a sporophyte differentiates?
A sporophyte differentiates into various structures, primarily including the root, stem, and leaves. In vascular plants, these structures are often organized into a complex system that supports growth and reproduction. The sporophyte can also develop specialized structures such as flowers, cones, or sporangia, depending on the plant type, which are crucial for the production of spores. Overall, these differentiated structures allow the sporophyte to effectively carry out photosynthesis, nutrient uptake, and reproduction.
What are the objectives of cost management system?
The objectives of a cost management system are to accurately estimate costs, monitor and control expenditures, and enhance overall financial performance. It aims to provide valuable insights for decision-making by tracking variances between planned and actual costs. Additionally, the system seeks to optimize resource allocation and improve cost efficiency, ultimately contributing to the organization’s profitability and competitiveness.
What are the advantages n disadvantages of a hydro pneumatic system?
What is master file in database environment?
The main file in the database which is the only copy of the important data in a database is MASTER FILE
lalkesav@gmail.com
What is closed frequent itemset in datamining?
An itemset is closed if none of its immediate supersets has the same support as the itemset.
So for example, if {Bread, Milk} is an itemset that has support=4, and all of its supersets has support<4, then {Bread, Milk} is a closed itemset.
Counter e.g.: If, let's say, {Bread, Milk, Sugar} has support=4, then {Bread, Milk} is not a closed itemset anymore.
Note: The definition states "the same" and doesn't say "the same or more" because it's impossible for a superset to have a support greater than one of its subsets.