An external view of Sports Steward Agency (SSA) system of the steward’s registration includes steward’s information for example name, address, phone number, email address, qualification, experiences etc. of stewards. To complete this SSA model we also need to store the information of all events and also store each event handle by the team of stewards with their role and date, time day, week etc. of the event. These all thinks represent by using Unified Modelling Language (UML). These system requirements and specification document is the part of the project documentation so that some features of this system are following: –
1.2 Detail summary of project: –
This project involves the complete database design for the Sports Steward Agency (SSA) and also designs a prototype. This prototype shows the UML diagrams. So that web developer easily understands the working of the system.
Purpose of the system: – The main purpose of this project to store and maintain all the formation in a system not use the pen and paper to store the information related to the SSA. If we design all these things all excel then this environment is not user-friendly for the users and very complex to maintain all the data related to SSA. The main disadvantage is the user need go to SSA Company and apply for the job and also steward need to go to check the schedule. How we create a prototype of SSA web site. So that user register for steward’s job at any time and anywhere and also steward and owner or admin see all the information related to the event at any time and anywhere.
For users: – users register on this website for the steward’s job. For the registration, the user adds their basic information like name, address, phone number, email if any, qualification and list of the role that he/she able to play in any event. System store all the information and owner/ admin may to may not offer the job. If the user gets the job then the system will provide user id that is Steward Id and one-time password to the user. Then user easily views the entire schedule related to their work and also able to update their qualification or roles.
For admin or owner: – in this system or model admin or owner can add and update each event. In the event, he/she store the data related to the event. He/she also set schedule of each steward according to time and time.
Input data: – when user open SSA website then user have the option for registration and log in. for the new user they must be register first and all information that see in the registration form like name, address, phone number, email, qualification, role etc. if the user already the member of this site then just log in and view all the information related to each event. Admin or owner input data related to each event, they also add and update the event data. They also add and update the schedule of each steward those work in SSA company.
Data store in database: – database store information related to each steward, each event and schedule of stewards. This schedule table store information related to event date and time, day, week, event information, steward information and each role play by each steward in the event according to date time and place.
2.1 HCI design guidelines: – designing guidelines are the part of HCI (human-computer interaction). It provides the best guideline how to interact with the technologies. The main purpose of this project to create a website that manages all the game’s event and offers jobs to the user online registration. The main purpose of HCI design guideline to produce the safe and usable system as well as the functional system. I follow the following instruction to produce a website with good usability: –
Software packages/tools currently in the market for data modelling (creating ERDs): – there are many packages/tools currently in the market for data modelling but I discuss only three tools in this report and these are following: –
2.4 Software packages/tools currently in the market for database management (creating the database): – there are many packages/tools currently in the market for database management but I discuss only three tools in this report and these are following: –
2.5 Conclusion: –
2.6 Data Protection Act 1998: –
According to data protection Act 1998, it protects how your personal information will be used in business, organization or government. Under section 7, if you view any organization data without their permission then organization hold on them reasonable fee.
Under section 14, if someone requests to correct the information then it must be corrected by the company. If the company don’t correct the data then court immediately order to correct data otherwise distorted. In some cases, compensation may be rewarded.
Under section 10, if data not used anyway or anyone then it wills potential to cause damage.
Under section 11, any company and organization’s data not directly used in marketing. There are some rules for data protection those follow by each and every one and this is called data protection principle. These rules are following: –
2.7 Issues on collecting and keeping personal data in databases relating to DPA1998:-
Some issues are we don’t personally share the data with another one. And not access any type of data without owner permission. If data owner graded permissions only when I access the data. If you view any organization data without their permission then organization hold on them reasonable fee. If someone requests to correct the information then it must be corrected by the company. If the company don’t correct the data then court immediately order to correct data otherwise distorted. In some cases, compensation may be rewarded. If data not used anyway or anyone then it wills potential to cause damage. Any company and organization’s data not directly used in marketing. But another side it is beneficial for any company and organization.
3.1 Assumptions and ERD: – I create the database according to the SSA case study. I create four tables. EVENT_INFO, STEWARD_INFO, ROLE1 AND WORK.
ERD (entity relationship diagram): –
In this use case diagram, the new user can open this SSA website and also able to register on this site. For registration, they need to add their information and click on submit button. Steward (existing users) can open SSA website and log in. After stewards able to view/ update their personal information also view work schedule that set by the admin.
Admin/owner able to view/update/add stewards information, events information and also set the work schedule for stewards
3.3 Class diagram: –
I create class diagram according to the ERD.
3.4 Sequence diagram: –
In this diagram admin /owner open the website and view/update/ add the entire information store in this SSA site’s database. For example, admin view/update/add event information, admin add/update/view steward information and also set schedule for each steward according to date and time.
In this diagram new users firstly open the SSA website. Then it displays two open registrations and logs in. when the new user clicks on the registration then they need to add their information in registration form then click on submit button. Then the system automatically sends the username and password if new users match the criteria. For existing user open SSA website and click on login option then it displays the login form type their username and password and log in the SSA website. Then steward able to view their work schedule and also able to view and update their personal information.
4.1 Implementation: – for implementation, I first create the database in Oracle SQL developer and according to the ERD. Also, add data in all tables according to the requirements. For testing purpose, I run some queries and it generates correct output/result.
4.2 Main functions: –
4.3 Testing plan: –
s.no |
Test plan name |
Expected Result |
Actual result |
Pass/fail |
1 |
List all events in the database |
Display list of all events |
display all event |
Pass |
2 |
Search a steward by name and/or id |
Display steward information according to name/id |
Display steward information according to name/id |
Pass |
3 |
List all the stewards for an event |
Display all the stewards work in event=”E101” |
Display all the stewards work in event=”E101” |
Pass |
4 |
Show the details of an event and the names and contact numbers of all the stewards assigned to it |
Display event =”E101” with that event detail also display steward name and phone number those work in this event |
Display event =”E101” with that event detail also display steward name and phone number those work in this event |
Pass |
This project is very inserting and I learn many things when I work on this project. Firstly I read the case study and make a plan firstly I done the theoretical part task 1 and 2. Then I create the ERD for the database in stage 1 and UML diagram for website creation in stage 2. At last implement database in Oracle SQL developer. I have done all the work according to my plan and learn about many things. For example how to create ERD, use case diagram, class diagram, sequence diagram, implementation of the database. Protect act etc. this project is very helpful to SSA and stewards. SSA’s owner easily manages all data and job seeker easily find/ apply for steward job.
References
Alhir, S. (2003). Learning UML. Sebastopol, Calif.: O’Reilly.
Ambler, S. (2003). The elements of UML style. Cambridge: Cambridge U.P.
Anon, (n.d.). Database | Cloud Database | Oracle. [online] Available at: https://www.oracle.com/database/index.html [Accessed 2018].
Chia, K., Seow, E. and Teo, K. (2004). Database. Singapore: Pearson Prentice Hall.
Curtis, B. (2014). Practical Oracle database application. [New York]: Apress.
Date, C. (2004). An introduction to database systems. Boston: Pearson/Addison Wesley.
En.wikipedia.org. (2018). Data Protection Act 1998. [online] Available at: https://en.wikipedia.org/wiki/Data_Protection_Act_1998 [Accessed 16 Apr. 2018].
Greenwald, R., Stackowiak, R. and Stern, J. (2009). Oracle Essentials. Sebastopol: O’Reilly Media, Inc.
Harmon, P. and Watson, M. (1998). Understanding UML. San Francisco: Morgan Kaufmann Publishers.
Holt, J. (2007). UML for systems engineering. London: The Institution of Electrical Engineers.
Kimmel, P. (2005). UML demystified. Emeryville, Calif.: McGraw-Hill/Osborne.
Momen, A. (2012). Oracle Database XE 11gR2 jump start guide. Birmingham, UK: Packt Pub.
Munnelly, B. and Holden, P. (2002). ECDL3 for Microsoft Office 95/97. London: Prentice Hall.
Naiburg, E. and Maksimchuck, R. (2002). UML for database design. Boston: Addison-Wesley.
November 14, 2. (2018). Human-Computer Interaction and Your Site — SitePoint. [online] SitePoint. Available at: https://www.sitepoint.com/computer-interaction-site/ [Accessed 16 Apr. 2018].
O’Neil, P. (2014). Database. Elsevier Science.
SILBERSCHATZ, A. (2019). DATABASE SYSTEM CONCEPTS. [S.l.]: MCGRAW-HILL EDUCATION.
Wang, J. (2011). Oracle Database 11g. New York: McGraw-Hill.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download