Topic Internet shopping sites (clothing, shoes, books, music, or others) Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project software for their project schedule. You are to submit one file (Microsoft Word) for this assignment. All diagrams and charts are to be embedded (copied and pasted) into your Microsoft Word file submission for this assignment. Please make sure they are large enough and legible. I need to be able to read them. The following layout/format including the title page and all three phases is recommended for the project. Title page (project name, author, and date) Each item below is to be labeled as below and addressed individually. No topics are to be combined. The following layout format covering a title page and all three phases is recommended for the project. Title page (project name, author, and date) Phase 1: Requirement analysis A. Problem definition B. Issues C. Objectives D. Requirements E. Constraints F. Description of the proposed system G. Logical model design Context diagram (with an accompanying written description).Diagram 0 (with an accompanying written description).Diagram 1 (Diagram 1 is optional) (with an accompanying written description).Descriptions of processes in each diagramDescriptions of outputs/inputs/performance/security or controlsThe 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 proceduresDatabase tables with their attributes should be presentedPrimary key(s) should be identified in each table, if anyThree steps of normalization should be included. (You are to show each step of normalization to 3NF – Be sure to identify each step in your normalization process) H. Specific requirements, if any (interface, operational, resource, performance, etc.) (You should not ignore any special interface, operational, resource, performance, etc. issues – All are to be addressed here). Phase 2: System and database design A. User interface Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.(You are to design the screens that will be used in your project- they are not to be copied and pasted from other sources). Be sure to include a written description for each of the items that corresponds with each screen and the input/output procedures. B. Data design Develop a plan for data organization, storage, updating, and retrieval. Database design Entity-relationship diagrams You are to draw an Entity Relationship Diagram (ERD) complete with Crows Foot notation. Remember that when reading ERDs the Entities and Relationships are read in both directions.Be sure to show the minimum and maximum cardinality for each direction.Data file storage and access C. System architecture Determine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc. Phase 3: Project plan A list of tasks or activities needed for implementing the proposed system Estimating completion time and costs (cost includes a breakdown of labor, hardware, software, etc.) A project schedule for performing those activities (Gantt charts or PERT charts) References are expected and are to be in complete APA format. Note that there is no other required software package except the MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the scheduling part of the project and for other parts, you can use any word editing software or any drawing tools software. Individual Project Rubric The individual project will account for 20% of your total points possible and students should use the APA format for the format of the individual project reports. The following rubric will be used when grading your individual project: Qualities and Criteria Poor [0-80) Good [80-90) Excellent [90-100] Format/Layout § Presentation of the text and structuring of text in an organized and thoughtful manner § Follows phases requirements (Weight 20%) Follows poorly the requirements related to format and layout. Follows for the most part all the requirements related to format and layout. Some requirements are not followed. Closely follows all the requirements related to format and layout. Content/Information § All phases of the project are addressed and contents in each phase are adequate § The project proposal is technically sound and realistic § The project is done using techniques covered in this course § MS Project software is used in the project plan § The project design can be implemented in reality § Activities and information are constructed in a logical pattern among phases to support the solution (Weight 70%) The project does not cover all phases and it is not done for the most part with techniques discussed in this course. The required software is used poorly in the project plan. The project proposal is hardly realistic and the tasks proposed can not be done easily in reality. Activities and information among phases are badly designed and do not support the solution. The project covers all phases with adequate contents in each phase for the most part and it is done with some techniques discussed in this course. The required software is used in the project plan for the most part. The project proposal is relatively realistic and some proposed tasks can be done in reality. Activities and information among phases for the most part are designed to support the solution. The project covers all phases with adequate contents and it is done with techniques discussed in this course. The required software is used in the project plan. The project proposal is realistic and the tasks proposed can be done in reality. Activities and information among phases are designed to support the solution. Quality of Writing § Clarity of sentences and paragraphs § No errors and spelling, grammar and use of English § Organization and coherence of ideas § APA style compliance (Weight 10%) The project is not well written, and contains many spelling errors, and/or grammar errors and/or use of English errors. The project is badly organized, lacks clarity and/or does not present ideas in a coherent way and it is somehow APA style compliance. The project is well written for the most part, without spelling, grammar or use of English errors. The project is for the most part well organized, clear and presents ideas in a coherent way and it is somehow APA style compliance. The project is well written from start to finish, without spelling, grammar or use of English errors. The project is well organized, clear and presents ideas in a coherent way and it is completely APA style compliance. * Some parts of this rubric are extracted from Dr. Stella Porto’s posting for ITEC-610.