If you know the current interest rate that your bank offers for loans, when you want to have the loan paid off, and how much you can afford each month for the payments, you might then wonder what the maximum amount is that you can borrow under those terms. To figure out this, you need [...]
Continue reading → SQL*Plus has been around as long as the Oracle RDBMS itself. It is the most basic tool available for connecting to the database and executing queries against the tables in a database. On Unix systems, it can be run in character-based mode, even on a dumb terminal connected to the Unix system via a serial [...]
Continue reading → Mail Merge is one of the useful features of MS Word. Mail Merge allows you to create a MS Word document that contains special merge fields and combines this document with a data source. The data source replaces the merge fields with real data. For example, if you want to inform all the customers of [...]
Continue reading → A Web service displays data on the Internet to trusted suppliers, customers or business partners. However, you need to ensure that only appropriate people gain access to a critical data. Therefore, it is important to secure the HTTP endpoint. To secure endpoints, you need to perform the following steps : Create appropriate user within the [...]
Continue reading → Typically, there are four stages of Payroll Processing. These stages are : Employee file maintenance – general processing The Payroll System has a program which allows adding new employee details to the employee master file .These details are changed when an employee gets promoted or transferred. Any changes applicable to the employee can be made [...]
Continue reading → With increasing use of Information Systems, most aspects of the personnel division benefit from automation. Typical Human Resource systems that are automated are the recruitment process, the performance appraisal process, the training process, the employee workflow process and the Payroll process. The need for automation specifically in a Payroll System arise due to the complexity [...]
Continue reading → The many benefits of a knowledge Management System include : Improved decision making Improved customer service Enhanced employee skills Increased profits Orchids Inc, wants to implement a Knowledge Management System. The majority of their time is spent on their employees, processes and procedural issues. These places of information existed in the business but in bits [...]
Continue reading → Interpreting information for strategic business management is the process of converting the information that an organization has collected into knowledge. Knowledge is the psychological result of perception,larning and reasoning. All analysis done using BIS (Business Intelligence Systems) can be placed as part of the Knowledge Management System for easy access and availablity for levels of [...]
Continue reading → In order to convert a table to BCNF, we must : Find and remove the overlapping candidate keys. Place the part of the candidate key and the attribute it is functionally dependent on, in a different table. Group the remaining items into a table. Hence,from the PROJECT table( refer to the Boycee-Codd Normal Form [...]
Continue reading → The original definition of 1NF was inadequate in some situations. It was not satisfactory for the tables: That had multiple candidate keys. Where the multiple candidate keys were composite Where the multiple candidate keys overlapped (had atleast one attribute to common) Therefore, a new normal form, the BCNF was introduced. You must understand that [...]
Continue reading → Inorder to convert a table into 3NF we must : Find and remove non-key attributes that are functionally dependent on attributes that are not the primary key. Place them in a different table. Group the remaining attributes. As for example, to convert the table Employee ( refer to the Third Normal Form (3NF) link : http://churmura.com/third-normal-form-3nf/) into [...]
Continue reading → A table is said to be in 3NF when it is in 2NF and every non-key attributes is functionally dependent only on the primary key. Consider the table EMPLOYEE The problems with dependencies of this kind are: Insertion : The department head of a new department that does not have any employees at present cannot [...]
Continue reading → In the Service Broker Architecture , various services converse with each other by sending and receiving messages.. The following diagram explains the conversation process between two services : The Service Broker Conversation Process The Service Broker applications send and receive messages across services. A message is sent from one service to another for processing. [...]
Continue reading → Service Broker is based on the Service Broker architecture. This architecture consists of the following database objects: Message : Is the data exchanged between the services. Service : Is an addressable endpoint for the conversations. The Service Broker messages are sent from one service to another. The two types of services that take part in [...]
Continue reading → Service Broker is a message-based communication platform that helps in maintaining reliable query processing and asynchronous communication. Consider a scenario of credit card services, when a person makes a purchase through a credit card, the credit card details are validated and a purchase transaction is completed. In addition, an entry is made in the database [...]
Continue reading →