Expert Answer :ITEC630 Individual Project Assignment

Solved by a verified expert :”Designing an online reservation system for an international airline”. please this is a project topic and the following deliverable are required.Project DeliverablesThe project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. The planning part requires the use of MS Project software.Title page (project name, author, and date)Phase 1: Requirement analysisA. Problem definitionB. IssuesC. ObjectivesD. RequirementsE. ConstraintsF. Description of the proposed systemG. Logical model design1. Data flow diagramsContext diagram/Diagram 0/Diagram 1[Diagram 1 is optional]Descriptions of processes in each diagram2. Descriptions of outputs/inputs/performance/security or controlsH. Specific requirements, if any (interface, operational, resource, performance, etc.)Phase 2: System and database design (Physical model design)A. User interfaceDesign an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.How data will be input to the system?The physical layout for each inputThe input design and proceduresHow data will be output from the system?The physical layout for each outputThe output design and proceduresB. Data designDevelop a physical plan for data organization, storage, updating, and retrieval.Database designDatabase tables with their attributes should be presented (however their implementations are not required)Primary key(s) should be identified in each table, if anyThree steps of normalization should be included.Entity-relationship diagramsData file storage and accessC. System architectureDetermine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc.Phase 3: Project planA list of tasks or activities needed for implementing the proposed systemEstimating completion time and costsA project schedule for performing those activities (Gantt charts or PERT charts)Note that there is no other required software package except MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the planning part requires and for other parts, you can use any word editing software or any drawing tools software.