Global Meetings and Interpretation (GM&I) is an international organization that offers online event organization for world business leaders to gather and discuss possible business partnership around the globe. GM&I determines the online meeting’s start and end dates, number of sessions in each meeting, begin and end times for each session, and assigns interpreters to each meeting. The interpreters have a set of language skills. Each online meeting has a set of language interpretation needs, and interpreters are assigned to each meeting according to the languages spoken in the meeting.

Currently, GM&I’s scheduling operations are supported by a legacy system that runs on desktops Windows operating system. The GM&I staff access the legacy application via a shared folder. Because of the nature of desk top applications, the GM&I scheduling system is not accessible via a browser, and this   puts limitations on the GM&I staff, when they are travelling and would like to access the scheduling system. The database of the scheduling system is not accessible to their legacy database globally as well. The database of the scheduling system can only be reached by the users in the GM&I building. GM&I is looking to improving their scheduling system and migrate their system to a Web Application where their database be accessible via web as well. They need new/improved database and new web accessible scheduling system which is connected to the database.

There is no in house technical experience to fulfill the requirements of this new IT project.

The users of the new web-based scheduling system are GM&I staff, Meeting Attendees (Businessman around the globe) and Interpreters.

The new system will be a web-based scheduling application with database, should be capable of the following functionalities:

• Allow GM&I to staff to login and access scheduling application features according to their roles
• Allow GM&I to staff to create a new meeting, assign begin and end dates, crate one or more sessions for each meeting with begin and end times, select one or more languages for the meeting, assign interpreters according to the language needs of the meeting.
• The system shall allow web access by Meeting Attendees (Businessman around the globe) and allow online registration for the meeting.

Th system should have the following qualities:

• Fast response when a user logs in and uses the system
• The look and feel of the web pages should be user friendly
• Users should be able to use the system easily

GM&I employees are identified by their first name, last name, employee IDN, office phone, personal cell phone number  and  the meeting(s) involved ( managed) . GM&I employees can arrange /manage more than one meeting.

Meeting Attendees (Businessman around the globe) are identified by, customer IDN, first name, last name, company name, email address, phone number and languages they prefer. Meeting Attendees must be registered / enrolled at least one meeting. And they may need Interpreter. Some Meeting Attendees will not ask for Interpreter. Meeting Attendees may have more than one phone number and email address.

The Interpreters are identified by Interpreter IDN, first name, last name, languages he/she knows, email address and phone number. Each Interpreter must be assigned to only one meeting. An Interpreter cannot be in more than one meeting. Some Interpreters may translation in more than one language.

An Online Meeting is identified by meeting IDN, meeting name, start and end dates, and associated sessions. Each meeting must have one GM&I employee, may have more than one Interpreter, and must have Meeting Attendees. There may be meeting without any Interpreter (Meeting Attendees may be fluent in English)

QUESTIONS:

Question 1: Draw and present your USE CASE diagram for the above project.

Question 2:  For the database; Describe each Entity for this business case. For each Entity write the Attributes and write the Relationship (s) between Entities.

Question 3: For the database; Develop/draw Chen’s ER Diagram to present your solution.  Your Chen’s ER Diagram should reflect the Entities, Attributes and Relationships you defined in previous questions.

Question 4: Which Acquisition Strategy that you selected for the given GM&I case? Why?

Question 5: GM&I is looking to improving their system and migrate their system to a Web Application. Develop Navigation Structure Design for Web Application. You will be using block diagrams to define the basic components of the user interface and how they work together to provide functionality for the website users.

Question 6: In Input Design Process, write types of Input Validation you would use for the given case.  You should consider the Input Validation for GM&I staff, Meeting Attendees, and Interpreters.