DBMS Project Sample Assignment
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).
Part B – Database Design
1. ER Diagram including primary key, foreign key, cardinality and constraints
Figure 1: ER Diagram of MT Albert Football Club
2. Relational schemas – state the relational schemas and specify the normal forms the schema satisfies
Relational Schema of Mt Albert Football Club:
|
Table Name |
Attributes |
Constraints |
|
Football_Team |
Football_Team_id |
Primary Key |
|
Football_Team_name | ||
|
No_of_players_in_team |
Foreign Key references table players | |
|
Coach_id |
Foreign key references table coach | |
|
Club_id |
Foreign key references table club | |
|
Club |
FootballClub_id |
Primary key |
|
FootballClub_name | ||
|
No_of_employees |
Foreign key references table employees | |
|
No_of_players |
Foreign key references table players | |
|
Players |
Player_id |
Primary Key |
|
Players_fname | ||
|
Players_lname | ||
|
Players_phone | ||
|
Players_street | ||
|
Players_city | ||
|
No_of_players |
Foreign Key references table players | |
|
Football_Team_id |
Foreign Key references table Football_team | |
|
Physio_id |
Foreign Key references table physios | |
|
Employee |
Employee_id |
Primary Key |
|
Employee_fname | ||
|
Employee_name | ||
|
Employee_phone | ||
|
Employee_street | ||
|
Employee_city | ||
|
Employee_club_id |
Foreign Key references table Club | |
|
Employee_type | ||
|
Club_manager |
Club_manager_id |
Primary Key |
|
Club_manager_fname | ||
|
Club_manager_lname | ||
|
Club_manager_tasks | ||
|
Club_manager_phoneno | ||
|
Club_manager_address | ||
|
Club_id |
Foreign Key references table Club | |
|
Employee_id |
Foreign Key references table Employee | |
|
Manager |
Manager_id |
Primary Key |
|
Manager_fname | ||
|
Manager_lname | ||
|
Manager_phone | ||
|
Employee_id |
Foreign Key references table Employee | |
|
Receptionist |
Receptionist_id |
Primary Key |
|
Receptionist_fname | ||
|
Receptionist_lname | ||
|
Receptionist_phone | ||
|
Employee_id |
Foreign Key references table Employee | |
|
Physios |
Physios_id |
Primary Key |
|
Physios_fname | ||
|
Physios_lname | ||
|
Physios_phone | ||
|
Physios_type | ||
|
Physios_office_location | ||
|
Coach |
Coach_id |
Primary Key |
|
Coach_fname | ||
|
Coach_lname | ||
|
Coach_street | ||
|
Coach_city | ||
|
Coach_phone |
References
Coury, B. G., & Semmel, R. D. (2018). 11 Supervisory Control and the Design of Intelligent User Interfaces. Automation and human performance: Theory and applications, 132.
Eastman, C. M. (2018). Building product models: computer environments, supporting design and construction. CRC press.
Hogan, R. (2018). A Practical Guide to Database Design. Chapman and Hall/CRC.
Jadon, A., Williams, Z. T., Kafka, C., Rotta, H., Roy, S., & Lum, C. W. (2018). A Database System Architecture for Air-to-Ground UAS Link Characterization. In 2018 AIAA Information Systems-AIAA Infotech@ Aerospace (p. 1726).
Malhotra, S., Doja, M. N., Alam, B., & Alam, M. (2018). Generalized Query Processing Mechanism in Cloud Database Management System. In Big Data Analytics (pp. 641-648). Springer, Singapore.
Nashat, D., & Amer, A. A. (2018). A Comprehensive Taxonomy of Fragmentation and Allocation Techniques in Distributed Database Design. ACM Computing Surveys (CSUR),
Smidt, H., Thornton, M., & Ghorbani, R. (2018, January). Smart Application Development for IoT Asset Management Using Graph Database Modeling and High-Availability Web Services. In Proceedings of the 51st Hawaii International Conference on System Sciences.
