Professional Skills for Information Systems
CIS5100 S1 2017
Submitted
By
Deepak Chander Jaikumar
U1097711
10 May 2017
University of Southern Queensland
The database is a collection of related data that is organized in some way so it can be accessed easily and can be managed & updated. Relational database management system (RDBMS) is DBMS system that is based on relational model. In this model, data is represented in tuples. The query is the type of request for the information from the database. Database report is the formatted result of the query & contains data for decision analysis & making. Decision support system is an information system that supports the decision-making activities of the business or an organization.
…show more content…
The query is the type of request for the information from the database. It refers to action to retrieve the data from the database.
Query of late dispatch order will display the details of the customers who lives in Victoria and has ordered item before 21st Feb 2017 but dispatched later as item is not available for the stock and the customers who live in South Australia has ordered item before 28th Feb 2017 but items dispatched later as item is not available in stock. The query will display the details of customers and items that are ordered and date & quantity of the order.
Query of impacting on the cost price of New Zealand because of enhancement of import duty. This query updates the item that has it raises the cost price of New Zealand for the item that is not available in stock, but they are on order.
Query of invoice query will display the details of customers, items and selling price & order total. It gives two new fields that include total of order and selling price for the customer who does not live in Victoria and New South Wales and order product whose item description contains word Tardis and provided from the specified supplier.
Database report is the formatted result of the query & contains data for decision analysis & making. Invoice report contains results of invoice query that are grouped by the Customer Id of the customer. Invoice of each customer is available on the separate page.
Decision support system is an
First, we conducted risk-based approach with data analysis techniques-unusual invoice and unusual comments, to identify the unusual items that are in the accounts receivable detailed listing, and tested whether there are invoices outside the expected range of invoice number and “special” comments associated with accounts receivable items. As a result, there were no invoice number out of range, and Invoice 1000919, 1000845, 1001097 are “special” comments associated with accounts receivable.
Commands: I did a count command on the Shipping document number column, and the sales invoice number column, and both columns contained 383 records. I also visually skimmed the columns to make sure there were no blank cells. I then performed a duplicates command on both columns to make sure there were no duplicates, and each sales invoice had a unique shipping document number.
The accounting department supervisor compares and reconciles a copy of the daily sales invoice batch report to the daily accounts posting report indicating the individual accounts. The daily account posting report is prepared and sent by the accounts receivable department. Discrepancies are investigated and resolved to help assure that the customer subsidiary accounts are posted for the same total amount posted to the control account. Cash Disbursements
This shows that invoices were made twice for large amounts possibly by fraudsters that have approved the transactions. It’s very clear that the invoices were recorded this way.
Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.
Microsoft Invoicing—With this app you can generate your business estimates and invoices. Get paid fast with online payments, track pending and partial payments, find draft estimates and past invoices, set sales tax and discounts, and quickly transform estimates into invoices—all in a few clicks.
Invoicing is a best way to keep record of different business transactions (outside factory transactions) and sales or purchases for potential uses whereas, an excise invoice is one of the most significant business documents that is used by different organizations, businesses and manufacturing companies to give details and information about goods being issued by the manufacturing department or plant (outside the factory). These goods may be transferred from one plant to another for finishing, packing, any further work or may be issued to vendors and retailers for sale reasons. Excise invoice includes:
Decision support systems (DSSs) help professionals make decisions by determining the most favorable options to a “What if?” question. Using raw data, DSSs can make comparison and generate new information to assist in decision making.
Once an employee begins employment with a company he or she must first go through completion of the internship program. During the program the employee has a very important briefing that he or she completed on time, and then presented to the CEO of the company. The guidelines required to complete the briefing assignment consist of the explaining in detail the selection process, and how it was affected by the goals of the organization and stakeholders. The briefing will explain the process needed for selecting and acquiring an information system and how the goals of an organization can drive the selection of the system. The briefing will identify
Mark off each invoice on the query against the invoices listed on the inventory (I would make a copy that you can mark off on so that you still have a clean copy to turn in).
The non-trade invoices receive from administration department or other branches will be record in the AX system. The invoices must be sign by the admin manager before data entry. The list of chart of accounts has been created in the AX system; therefore I need to identify the invoices based on assets, liability, expenses or revenue. GEODIS has identified the lists of accounts and made available for recording transactions in its general ledger. It is important to have a list of account in the company because it can segregate the expenditures and assets to quickly view the company financial health. (Edmunds, 2016)The non-trade invoices are the expenses such as utilities, rental, stationary, repair and services, I need to identifies the expenses
To be noticed, Woolworths will record the arrival time at the Distribution Centre (DC) gatehouse for all Purchase Orders (POs) presented to make sure they are delivered on time. Woolworths requires the PO to be delivered up to 30 minutes early and up to 30 minutes after the time slot i.e. an one hour window at the discretion of the DC, and with notification deliveries up to one hour early will be considered as on time. Deliveries arriving earlier than one hour before or more than 30 minutes after the scheduled time slot will be considered not on time.
What is database management system? Database Management System is a database program. The DBMS manage incoming data, organize it, and provided ways for the data to be modified or extract by users or other programs. This cause, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand. Some DBMS examples include PostgreSQL, MySQL, SQL Server, Microsoft Access, Oracle, FileMaker, RDBMS, dBASE, Clipper, and FoxPro. It is a software system that uses a standard method of retrieving, and running queries on data.