The Report Showing the Functionality and Working of DBMS

Question: Discuss about The report showing the functionality and working of DBMS ? Answer: The report is showing the functionality and working of DBMS (Database Management System) and DSS (Decision Support System). The Database Management System used in the assignment is MS Access while the Decision Support System used is MS Excel. In Database Management System, queries and reports are created. The Database Management System gives facility to get the requested data very quickly. The user can see the data reports and can see the summarized data at any time without time delay. Similarly, the Decision Support System gives so many features and facilities. It provides lots of built in functions, macros etc. to solve complex queries very easily and in less time. Database Management System The Database Management System is the most powerful tool which works to make the functional and working software to get the expected database results. The complex data can be easily extracted with the Database Management System. The complex data cannot be maintained by other file system tools to achieve a better performance. The Database Management System is the best choice. Relational Database The Relational database Management System works on the entities which get related with each other for better performance. The Relational database provides the query tools which can be used to make queries and helps in fetching the results very easily. The database integrity and simplicity can be maintained in the RDBMS very easily with the help of database relations. Exactness of Database Management System (DBMS) The database of Dr. John Smiths business is very large. The Database Management System is the most suitable option as it keeps the records separately in the database. The large data is very difficult to extract exact results on the users requirement, but the Database Management System helps in extracting the required results very easily. The past records can be easily maintained with the help of Database Management System. Exactness of Relational Database The requirements of the Dr. John Smiths business are very high like integrity, data reports, data retrieval etc. All can be fulfilled by the relational database management system. Different types of queries can be used in the relational database management system like select query, join query etc. The normalization is the most powerful feature of the relational database management system which helps to make a better database system. Database Query Database queries are the best way to get data as per users demand. There are three queries implemented in Dr. John Smiths businesss database. First query is demonstrating the customers late dispatch orders that live in South Australia or Victoria. Second query is increasing the cost prize NZ by 9.95 % of the items that are not in stock but are regimented by customers. Third query is demonstrating the customers invoices who ordered the TARDIS items and who do not live in New South Wales and Victoria. Database Report The report that implemented in the database management system is customer invoice report. It is demonstrating the customers invoices who ordered the TARDIS items and who do not live in New South Wales and Victoria. (teach-ict.com n.d.) (Paul Litwin n.d.) Decision Support System The Decision Support System is the system that maintains the large data and gives lots of features and functions to access that data with very efficiently. It gives the opportunity to compare the data from different sheets and can merge the data on specific conditions. It is very robust and powerful tool that gives the opportunity of programming also. There are two types of Decision Support Systems available- Programming and Non-programming. MS Excel, the Decision Support Systems is used in Dr. John Smiths business. It gives options to work programmatically and non- programmatically both. In macros, the user can make programs to do specific work while simple work can be done with the help of built in or user defined functions. Exactness of Decision Support System (DSS) The Decision Support System is the right tool to work on large data. The data is very large and cannot be accessed without proper storage and facilities. The Decision Support System provides lots of features and functions like sum, average, IF, LOOKUP etc. to solve complex queries. The data is stored in row, column format and calculations can be performed on it. As per the price, the cost of the Decision Support System is very reasonable. All organizations can purchase it very easily. Complex calculations can be easily done with the help of built in functions. The Decision Support System is very good and appropriate as it lessen the man power in organizations. It replaces the man power by its power and provides facility to work accurately and quickly. The Decision Support System is very good and appropriate as it is highly secured. The administrator can use credentials on Decision Support System and can allow to only selecting members to use the Decision Support System by giving proper user id and password. The Decision Support System is very supportive also. It supports most of the operating systems e.g. it supports all versions of Windows like 98, 2010 etc. Mark-up Type The mark-up is very important as it affects the selling price. The mark-up type should be selected very carefully as it affects the customers choice and business growth as well. There are 2 types of mark-ups- Supplier and Store. The store mark-up is selected in Dr. John Smiths business as it is good for its business. The mark-up directly influence the customers. The price of products depends upon the mark-up percent and therefore customers decision always matters upon the mark up. It should be chosen correctly by the owner to attract the customers by lowering the selling price. Impact of Discount The discount is the good way to attract the customers but it should be given carefully as there may be big loss if the discount is given on more things that are latest. It should be given wisely that the customers get attracted towards the products and the business will increase definitely. It is the good practise to increase the business growth. Organizations should give discount on specific occasions to sell the old products and to increase the business growth. Suggested Freight The Freight is also important factor in every business. The Lethbridge-Stewart Transport Freight is good for the business of Dr. John Smith. The Lethbridge-Stewart Transport Freight is growing day by day and most of the countries are using this freight because of its low budget and good response. The low cost of fright automatically decrease the selling price and indirectly attract the customers towards the business. The freight cost increases the cost price of items and directly affects the business profit. If the selling price cannot be increased, in that case the complete freight cost affects the business profit. Therefore, the freight type should be chosen very carefully. Suggested Country The import country should be chosen very carefully as the import export duty reflects the selling price. If the import export duty is less, the selling price will be automatically less and it will be good for the business growth. Ireland is the good choice for the business of Dr. John Smith as the Ireland has less import export duty and has good communication and terms with other neighbour countries. Important Factors Considered in Import The factors that should be considered while import is following- Shipping charges, freight charges, cost of products etc. The sale of business depends upon these factors and if all the above mentioned charges are less, the selling price will be less automatically and it will definitely increase the sale of business. Conclusion The DBMS (Database Management System) and DSS (Decision Support System) are discussed in the report. The DBMS is implemented in part A and the DSS is implemented in part B. There are lots of factors and features provided by DBMS like queries, reports etc. All are mentioned in the report. The DBMS provides good way to access the large data and to show the exact results as per the users demand. In the same way, there are lots of factors and features provided by DSS like functions, macros etc. All are mentioned in the report. The DSS provides good way to access the large data and to make large and complex calculations on the provided data. In DSS, the user can see the reflection of changes in one sheet to all the connected places. It is the best thing of DSS, that the user can make summary report at one place by connecting different sheets data. The report is discussing about the freight cost, appropriate country for import / export, effects of mark-up type, effects of discount etc. After studying this report, the reader can easily get the idea about DBMS and DSS both. It is giving full knowledge about appropriateness of DBMS and DSS. References teach-ict.com n.d., Third Normal Form, [Online]. Available: https://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/normalisation/miniweb/pg9.htm [Accessed: 10-May-2017] Paul Litwin n.d., Fundamentals of Relational Database Design, [Online]. Available: https://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx [Accessed: 10-May-2017]