Q Assignment is about the DBMS software framework is joined with the software’s, application and other devices. Home, - DBMS Part A– Project Planning 1. Business Overview – explain the background of the chosen business scenario The MT Albert Football Club is offering club services to the football players. It is international football club in the New Zealand which provide advance services to football players. The main aim of MT Albert Football Club is to assist football players to feel comfortable. The club organization has stated separate membership approach for its members. The card is issued to the selected football players, staff members and other employees of the club. This card membership program not only increases the security measure of club but also assist in collecting the required amount of information. The new database design system has been used in MT Albert Football Club to maintain an effective data record of all the staff members and players in the club. Data base design system This data base design system is the advance system used in club to properly classify all the collected data by using separate heading and subheading. The design drawing, table and chart will be used to portray the collected data in the system. This data base design system will assist MT Albert Football Club to increase the overall security measures by designing the separate the IT program. It will help management of MT Albert Football Club to create separate user name and unique ID the concerned person (Hogan, 2018). 2. Business requirements – list the client’s requirements There is below given list which reflects the list of client’s requirement. Arrangement of IT experts: MT Albert Football Club needs to hire proficient IT experts in the process team to design database system (Nashat, & Amer, (2018). Installation of ER diagram: This new diagram will be installed in the database system of MT Albert Football Club to establish nexus between all the related persons such as employees, managers and clients for with the club. Database table:This database table is accompanied with the primary and relative keys which reflects the key details about the associated persons such as their names, ranking and players scores. SQL Server- The SQL server is the main part of the database system which will assist MT Albert Football Club to directly collect the data from the various sources. It also assist management of MT Albert Football Club to modify and change the gathered data as per their wish (Eastman, 2018). Program testing-The program testing will use all the primary and relative keys to reveals the hidden information. This testing will run with the support of the QRL server used in the database system to pull the data. Exporting data from the database-:The import and export of data is the features available in the database management system. It would be done through the QRL query method. It will assist MT Albert Football Club to directly import and export data from the database system for the clients. Easy flow of information- This database system will assist in easy flow of information in MT Albert Football Club and also helps in assessing the player’s details in effective manner. These above given features will make this database system more attractive and assist in satisfying the players needs and demand in efficient manner. 3. Expected Project Outcomes – list your project deliverables There are several expected project outcomes which MT Albert Football Club would have from the undertaken project. However, the project outcomes could be defined as intangible and tangible benefits. If the benefits comes in terms of cash inflow and other seen benefits then it will be tangible benefits. On the other hand, intangible benefits will increase the satisfaction level of players in the club (Nashat&Amer, 2018). Ideally, if there is find any issue and problems at the time of undertaking of the new project, then the prior efforts should be made to eliminate those issues at the initial level. The main purpose of this new project is to increase the overall security measures and promote the MT Albert Football Club for the better storage and security of the collected data. In the starting, users need to prepare the list of possible outcomes such as increased security program, confidentiality of the data and ease the existing process. MT Albert Football Club could find the several benefits from the undertaken project which are given as below (Hogan, 2018). 1- High storage of data in database system:This database system will assist MT Albert Football Club to gather data of employees, staff members and players. The auto updating feature will also provide the up-to-date information about all the associated person of club. 2- ER diagram based data system: This system focuses on the implementation of the ER diagram which will help in pulling query from the system and reveal the hidden data. 3- Applications and designed software’s:The database system will be accompanied with the several software’s and application. It will assist in saving data from the ill-intentioned persons. 4- ER design and drawing: This feature will assist in setting the direct connection with all the stakeholders. 5- Technical interpretation- This new project will assist all the concerned persons to understand all the key technical terms in easy and determined approach (Coury & Semmel, (2018). 4. Technical and administrative details - the description should cover the following - DBMS software used, storage, backup and recovery plans DBMS software’s framework: The DBMS software framework is joined with the software’s, application and other devices. It is based on the online cyber computing system which will be used to gather the data form the concerned person and keep the data safe and secure. The SQL server and application device will also be used to set up communication process in the MT Albert Football Club and concerned person (Jadon, et al. 2018). There are several technical and other administrative intents of the database systems are given as below. Data Storage- The newly design database system should have high space to keep the data store in its drive. With the increasing number of files and pictures and information, MT Albert Football Club need to use database system which could keep high amount of data saved in system (Malhotra, et al. 2018) Backup: It is the safe measure program which will assist MT Albert Football Club to keep the data safe and secure. This method will help in keeping the data secure at more than two place. It is required to keep the data safe at another place. It helps in taking the back up of one file from another place if one folder is destroyed. Recovery plans: The recovery plan of the database system will assist MT Albert Football Club to recover the data in case of emergency and disaster situation. It will assist in recovering the data in easy and determined approach. Secure methods- The use of software and Anti software application in the database system will assist in safe and secure data in efficient manner. The DBMS system framework is joined with the simple process which will assist all the employees and staff members of MT Albert Football Club to give ranking and evaluate the player’s details. However, MT Albert Football Club could also use some other advance software’s to support its DBMS system to make it more effective (Smidt, Thornton, & Ghorbani, 2018).
Related :- Q International Financial Reporting Standards The assignment describes about the impact of IFRS (International Financial Reporting Standards) adoption on the quality of financial reporting and disclosure Q Ethical requirements of APES 110. Assignment describes analysis of situations and stating whether they are or are not a breach of the ethical requirements of apes 110 & case of breach Q PAN AFRICAN RESOURCES Assignment describes that if investors invest their capital in Pan African Resources Company then they might face issue in creating value on the investment. Q Legal Opinion In The Case Of Kadlec V/S Lakeview,a common law practice The assignment is for Legal Opinion In The Case Of Kadlec V/S Lakeview to understand the cause and history of the disunity and to know who will get the benefit. Q Supercar, Building the Car of the Future to make decision Assignment focuses on Supercar, Building the Car of the Future to provide you with opportunity to think about how strategic management affect decision making. Q Compensation Policy of Amazon for the compensation policies The assignment is for Compensation Policy of Amazon, describes its compensation strategy, best practices they are applying, and compensation-related challenges. Q MOD003353 Business Environment, new product in business practices The assignment on MOD003353 Business Environment application of innovation and technology improves the productivity of an organisation. Q Product Risk Factor Matrix to Redesign the product risk factor matrix Assignment discusses about Product Risk Factor Matrix includes a matrix titled “Product Drivers and Risk Factors,” which focuses on Intel. Q Business Law Analysis- Tort Law for matter to criminologists The assignment describes about Business Law Analysis- Tort Law,Describe the four bonds that form the basis of Hirschi’s delinquency theory. Q New and Improved Rewards at Work,effectiveness of equity-based rewards This assignment discusses about New and Improved Rewards at Work with innovative employee rewards to boost morale and acknowledge employee needs for creativity.