Database Management System related to DBMS - Free Sample

Question: Discuss about the Database Management System DMS. Answer: Database management system This is software of system for the management and creation of the database. DMS is useful for the programmer as well as for the user. This tool enables the user to engage with the system and update, read, create and destroy data in the system (Singh, 2015). The gap between the application program and the database is bridged by the DMS. Relational database The table which is formally described is used in the relational database. This table is used for the collection and storage of the data. Reassembling and access of the data is done through different way but in the process the table of the database is not recognised (Vicknair et al., 2010). In this process the SQL or the structured query language is used for the data accumulating for the report preparation and for the information generation from the relations database through interactive query. Appropriateness of the Database Management System The use of DMS would be appropriate for Dr John Smiths decision support system if it is able to address all the need of the project. The DMS would appropriate because of the usability factor. DMS would also be useful for the better visual display and reporting. The security of the data is top priority and there DMS is appropriate. The filtration and extraction of data, forecasting, planning and automation would be better done by DMS (Singh, 2015). It can be scaled up. There would be better software related support that would be provided. The cost factor is low in this approach. Rational database as Database Management System DMS uses the relational database as a model. Through the model of relational database the data are stored in the table format and each of them are classed the relation. In the relation there is one or more than one column for the data category. The relational model is easy to use and understand. The model is also useful for the DMS, it can update new data in the system and there is no need to modify the old ones (Vicknair et al., 2010). This is also useful for the better performance, flexibility, new capability development and for power of new technology. This model also provides the highest level of security of the data. Database query The query is a request format for retrieving the information from the database. The query is developed through three different methods. One is the menu based parameter selection. The second method is the example based query development (Kim et al., 2012). The third method is the special language based query development. Select custid, title, given_name from Td1cust where custid=c001; Select * from Td1cust where state=Victoria order by state ASC; Update tbitems set costprice(nz)=round(costprice(nz)+costprice(nz)*9.95%,2); Data base report When queries are given to the system, a result is generated for the query and that is called the database report. This report is very useful for the purpose of analysis and the process of decision making. Different tools are used for the running of the query through the use of minimum one language for query. SQL is the most useful and popular language (Kim et al., 2012). The other languages that are used for the purpose are HTSQL, SPARQl and Poliqarp. Decision support system This is specific type of information system which is computerised and useful for the support and decision making process of the business. This is a interactive system based on the software. This is useful for the compilation of the information from the large source of raw form of data. The current information based system can be asses through the system. This would also include the relational type data source, legacy, data mats and warehouse. The system would give the understanding about the different possible type of decision implication (Turban et al., 2011). It also helps to develop the comparative figure of sales for current and next week. The use of some other expert system or the use of artificial intelligence is there in the decision support system. Appropriateness of the decision support system There is different reason for which it would be appropriate to use the decision support system in this project. One of the main reasons would be the time saving approach in the decision making process. it just not only reduce the time of decision making but also improve the productivity because of the timely decisions. The decisions must be accurate to be effective for the business. The use of the DSS would enhance the effectiveness of the decisions. In the current project of developing the DSS for Dr John Smith, would have lot of other decision maker. DSS helps to develop and share facts and the different assumption related to decision. This approach is useful for the improvement of the interpersonal communication and that is useful for the decision making. The improved decision would useful for the development of the competitive advantage for Dr John Smith. The labour and the overall cost of the decision making are saved because of the DSS use. A clear perception is useful for the decision making and there is also less amount of frustration in the process. DSS in that context helps to create less frustration and more satisfied decision making (Turban et al., 2011). DSS is also useful in the performance monitoring process in the organisation. The system is useful for the greater control in the organisational process. All of these advantages of the DSS are useful for the project of the Dr John Smith. All of the above reason would make DSS appropriate tool for the implementation in the business decision making process. Appropriate type of mark-up for this business project The mark-up is the pricing process. This is very easy and less complicated approach of product pricing approach. After the development of the decision support system for the Dr John Smith, the developer needs to determine the prices of the service. In this process the first calculation would be to understand the cost of production (Betton et al., 2008). After calculating the product cost of the DSS development the mark-up value is added with the cost to arrive at the selling price of the service. Influence of mark-up selection in the customer purchase decision The price level impacts the decision of the customer in the purchase process. Higher price level negatively influences the customer in the buying process. Mark-up is less complicated approach of pricing. Here the desired profit level is added to the cost of the product through the percentage increase method (Betton et al., 2008). So to arrive at the correct selling price of the service the developed need to understand the affordability level of the customer and the desired profitability level that the service provider need to sustain the business. Large order discount impact on the profit of the business The discounts are useful for the increase in the sale figure. Increased sales figure would increase revenue figure for the business. There would be reduction of revenue per unit basis because of the discounts. So there must be enough sales to offset the decrease in the revenue and additional amount of revenue because of the activity. The discount that is given in the business would be able to increase the total revenue figure substantially. The discount would reduce the margin from each product and service sold (Schroeder et al., 2010). To increase the overall desired profit figure the business need to sale a critical amount to reach that. The current trend shows that the business would be able to reach to that point and achieve the desired profit from the discount activity. Appropriate type of Freight for the business There is different type fright system that would be there for the business. Different fright system has different cost structure and utility. The business of Dr John Smith sales different type imported merchandise like the bobbleheads, i phone skin, mugs, giftware etc. Now all of those are delicate items and supplier around Australia. Here the DSS shows that the less than truck load freight system would be most effective for the business (Turban et al., 2011). This is a cost effective, on time and reliable approach of fright. In this mode the shipment would share the truck with other similar type of other business. Different Freight type recommendation and the effect of the cost transfer to the business profit There could be some other type of fright system that is applicable for the business of Dr John Smith. There are some dedicated products that the business delivers to its customers. Those are to be delivered to the customer through some delicate approach. In that context the air ride truckload is useful fright type. Here the truck is partially filed and there is suspensions that are air ride type. But this type is expensive and can affect the profitability of the business if the margined of the products are not attractive. The air fright is fast and one of the cost effective approach that the business can avail (Turban et al., 2011). Guarantee delivery fright would be useful for the high priority and high margin products. The rail fright would also be useful for the business as it would save time and money for the business. References Betton, S., Eckbo, B. E., and Thorburn, K. S. (2008). Markup pricing revisited. Kim, W., Reiner, D. S., and Batory, D. (Eds.). (2012).Query processing in database systems. Springer Science Business Media. Schroeder, G. G., Klim, A. K., Heinz, G. M., Phillips, K. L., Raynor, W. J., Sengbusch, B. D., and Lindsay, J. D. (2010).U.S. Patent No. 7,689,456. Washington, DC: U.S. Patent and Trademark Office. Singh, S. (2015). Database management system.Journal of Management Research and Analysis,2(1), 72-80. Turban, E., Sharda, R., and Delen, D. (2011).Decision support and business intelligence systems. Pearson Education India. Turban, E., Sharda, R., and Delen, D. (2011).Decision support and business intelligence systems. Pearson Education India. Vicknair, C., Macias, M., Zhao, Z., Nan, X., Chen, Y., and Wilkins, D. (2010, April). A comparison of a graph database and a relational database: a data provenance perspective. InProceedings of the 48th annual Southeast regional conference(p. 42). ACM.