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

DBMS Project img1

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.