服务承诺
资金托管
原创保证
实力保障
24小时客服
使命必达
51Due提供Essay，Paper，Report，Assignment等学科作业的代写与辅导，同时涵盖Personal Statement，转学申请等留学文书代写。
51Due将让你达成学业目标51Due将让你达成学业目标51Due将让你达成学业目标51Due将让你达成学业目标私人订制你的未来职场 世界名企，高端行业岗位等 在新的起点上实现更高水平的发展
积累工作经验
多元化文化交流
专业实操技能
建立人际资源圈澳洲report代写范文：Design and Improvement of Website
2017-04-25 来源: 51due教员组 类别: Report范文
本篇澳洲report代写范文讲了经过对安东尼路葡萄酒公司网站的分析，确定了三个方面。首先，系统由产品系统，员工管理系统，客户系统，订单系统，交货系统五部分组成。每个部分都有其具体的功能。二是系统配置对确保公司正常运作至关重要。第三，需要改进计划，使网站和操作系统更加方便，多功能化。本篇澳洲代写由51due论文代写机构整理，供大家参考阅读。
This essay mainly focuses on system design and website improvement, which can be divided into four parts. The first part discusses about the database design. The second part focuses on software design. The third part depicts an improvement plan in its website and related risk assessment. The fourth part is a conclusion of the whole essay.
1. Database Design
Database design is to construct an optimal schema and establish database and its application system for a specific application environment. (Batini, Ceri and Navathe, 1992) As a trading company, database design is very important for the Company, which can be reflected in two aspects. On the one hand, customer information is crucial for the Company. The Company should maintain and protect customer information properly and avoid data loss. On the other hand, employee information and production information is also very vital for the operation of the Company. A good database is essential for the Company.
1.1 Database Software
Database is to organize and store information and proper software is very important for the database, which can be discussed in two aspects.
On the one hand, a choice of database software is the first priority. Currently, there are a lot of database software like Oracle, Microsoft SQL Server and Microsoft Access. (Luo, 2014) Proper database software is very important.
On the other hand, for the Company, the software should be simple and easily operated. In addition, the software should have reputation and have been tested for a long time. For Oracle, Microsoft SQL Server and Microsoft Access, they are all have the advantage of good reputation and there are the proper candidates for the database software. (Luo, 2014)
1.2 Database Schema and Description
The database schema is to produce a conceptual model that can reflect the organizational information needs. (Batini, Ceri and Navathe, 1992) It is characterized by a simple and clear representation of the Company’s business data requirements, data links and data constraints.
For Anthony Road Wine Company, it is a trading company selling wines. The database should focus on customer information, product information, employee information, delivery information and order and trade information. After the project is determined, users and designers through detailed investigation and study should fully understand the Company’s structure, business rules and data needs.
1.3 Test and Demonstration Data
After the database design and application development, the system will enter the stage of operation and maintenance. In order to ensure the safe and stable operation of the database system, all kinds of problems and the detailed operation plan and measures should be specified. Any of the factors that cause the primary problem of the system can bring the loss to the Company. For database, testing is an indispensable procedure, which lies in the monitoring of the database operation and data base maintenance.
2. Detailed Software Design
2.1 Modules & Programs
The modules and programs for the Company mainly lie in all five systems: product system, employee management system, customer system, order system, and delivery system. Meanwhile, these five systems should be connected with each other. The change of a system will directly influence the other four systems. The system process should be automatic updated according to the input and output data information.
2.2 Internal Logic for Key Programs
The Company should focus on the whole program of products, customers and delivery. The Internal logic for key programs are mainly lies in five perspectives.
In the first place, customer system could be improved that everyone could know the production information. Meanwhile, the age of customers must above 18 years old. An ID system could be set up to manage the ID information. The ID system should be updated to reflect the instant information about customers.
In the second place, product system can also be improved in four aspects. Firstly, sales information could be added into the official website. Below each product, the sales volume can be listed to show the popularity of the product, which requires the update of official website. The Company could have a deep discussion with Truevine, the website design company of Anthony Road Wind Company. (Truevine, 2016) Secondly, the storage volume of products can also be shown in the website, which can allow customers to know the storage information. This information should be updated automatically, which requires a good database design. Furthermore, in the end of each month, a sale report should be formed to show sales information monthly, quarterly and yearly. The report could enable the management level to know about latest business result, which requires a new report model in product system. Fourthly, when the storage volume of a product is decreased to a low level, an alarm should be alerted to remind the product employees to supplement storage volume.
In the third place, delivery system could be improved to meet the requirement of customers. Customers can choose the delivery companies according to their factual situation, including delivery time, delivery mode and urgent delivery.
In the fourth place, the comment category can be added into the official website. When customers receive the products and have a taste, they can comment on the website. The feedback can allow the Company to improve their products and services. A reward system could also be set to give credits to customers. Once they comment on the website, they can obtain some benefits like VIP rights or sales discount.
In the fifth place, an online communication system can also be set up to provide instant assistance to customers. When customers have questions, they can turn to the online communication system for help. The system can make the sales more convenient for customers.
2.3 Security
Once the database software is put into use, security is a topic that should be laid emphasis on. For the Company, information is the most important aspect that should be protected. In order to ensure the stable operation of the system, the operation strategy must be formulated. Database operation cannot be separated from the user's access and operation. Security policies include network security, user rights management, equipment security and data security according to specification for safety and failure at design stage. (Bertino and Sandhu, 2005) The implementation of authorization should be set by the mode password. IT department should often check the security and reliability of the system, the implementation of backup, recovery and data restructuring tasks.
3. Development Plan
The development plan for the Company lies in two dimensions. On the one hand, the Company should pay attention on its website design and functions. On the other hand, the Company should improve the database management, design and maintenance.
3.1 Development Stages
For the Company, now its scale is not very large. Now the Company’s sales are mainly from the local consumption in the United States. In order to have a better future, the Company should formulate a plan. The development plan can be divided into three stages.
Firstly, the Company should have a clear project work plan. The work plan should be in details. The project work plan should include time, staff and content. The Company should have a timetable that set the goal for each period. For each period, each development step should be fully discussed and negotiated. In addition, relevant staff should be responsible for the development plan.
Secondly, the management should measure the risks of the development plan. In addition, impact assessment should also be implemented. When updating the system, there is a risk of failure and destroy the original system. Therefore, the Company should have a backup plan for the risk. The impact assessment is also necessary to avoid negative impact.
Thirdly, development testing should be carried out frequently. Once the system and database is updated, relevant staff should have a test to identify whether these updates work normal and don’t destroy the original database and website.
3.2 Project Work Plan
A project work plan includes system outline, target, scope and current status and. The structure of the system and subsystem description, division of system function, system organization contact graph, data flow diagram, function module diagram and data dictionary should be considered. Then the demand analysis report of the project work plan should be submitted to the Company's decision-making departments to discuss the review, which is a basis for future design and work.
For the Company, the project work plan is involved in all five systems: product system, employee management system, customer system, order system, and delivery system. Among the five systems, product system and customer system is the most two important aspects. The five systems are united as a whole program to ensure the operation of the Company and each system is unique and indispensable. The mode of the project work plan is implemented by items. Each item is updated separately. After one item is put into use, it will take some time to measure the consequences.
3.3 Risks & Impact Assessment
In order to avoid system risk and operation risks, assessment needs to be carried out to ensure the smooth operation, which can be divided into two aspects.
In the first place, the IT department should monitor the operation of system. The staff should often evaluate the status of the database storage space and analyze the response rate to determine the optimization and improvement measures and timely adjust the operating conditions of the system.
In the second place, there is a risk that the information will be lost and a backup system should be set up to mitigate the impact of data loss. The loss can also be calculated in order to determine the severity of data loss.
In the third place, there are some mistakes in the process of system operation, which need to be modified in time to make up for design flaws.
3.4 Development Testing
After the completion of the structure of the database, data can be loaded into the database. Because of the very large amount of data in the database, in order to avoid wasting a lot of manpower, money and time, it usually specially designs an input subsystem to improve efficiency and meet the users’ requirements. The subsystem generally includes data entry, data verification, code conversion, data integrity constraints, security checks and other functions.
All these changes and updates need to be tested by all related staff and departments. Through the test and performance impact that influence different combinations of memory real-time database, it will lay the basis for the research work in the next step, which will make the changes and updates more successful and find problems in time.
4. Conclusion
A good design of database and website is crucial for Anthony Road Wine Company. In today's information age, information has become an important resource to determine productivity, competitiveness and economic efficiency. The management can only make the right decision in a timely and accurate grasp of the relevant information. Database technology is an important means for a given application environment, constructing the optimal database model and realizing the information storage, query and processing. Only the useful information is converted into data and stored in the database, it is possible to achieve the best data management and meet the various needs of users.
Reference
Anthony Road Wine Company. (2016).
Truevine. (2016).
Batini, C., Ceri, S. and Navathe, SB. (1992). “Conceptual Database Design: An Entity-Relationship Approach.” Proc, 2(86):89-97.
Luo, XQ. (2014). “The Application of Database Software.” Network Security Technology & Application
Bertino, E. and Sandhu, R. (2005). “Database security - concepts, approaches, and challenges.” IEEE Transactions on Dependable & Secure Computing, 2(1):2-19.
