1 / 22

Dynamic Website Design for Temple Beth-El of Ithaca, NY CS 501 Project - Milestone #1

Dynamic Website Design for Temple Beth-El of Ithaca, NY CS 501 Project - Milestone #1 March 7, 2006 Presented By: Peter Babinski, Christopher Benedict, Benjamin Darfler, Eugene Kim, Muir Manders, Vivek Shah, and Michael Veilleux. Presentation Outline. Review Feasibility Report

tallys
Download Presentation

Dynamic Website Design for Temple Beth-El of Ithaca, NY CS 501 Project - Milestone #1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dynamic Website Design for Temple Beth-El of Ithaca, NY CS 501 Project - Milestone #1 March 7, 2006 Presented By: Peter Babinski, Christopher Benedict, Benjamin Darfler, Eugene Kim, Muir Manders, Vivek Shah, and Michael Veilleux

  2. Presentation Outline • Review Feasibility Report • Goals for First Milestone • Current Status: Completed First Iteration • Requirements • Analysis and Definition • Specification • Preliminary Design • Implementation of Prototype • Evaluation • Goals for Next Milestone

  3. Feasibility Report Review Client: Jane Griffith, the Administrative Assistant at Temple Beth-El of Ithaca Scope: Build a dynamic webpage that, from the web browsers point of view, is easier to browse and more up to date with current webpage design. From the webpage manager’s point of view, the page contents must be easy and secure to manage from a remote location. Preliminary Requirements: (Vivek will discuss later) Feasible? Yes!

  4. First Milestone Goal: Iteration #1 Requirements Evaluation TODAY’S PRESENTATION Implementation Design Reference: Iterative Procedure Diagram from Dr. William Arms, http://www.cs.cornell.edu/courses/cs501/2006sp/slides/lecture1.html

  5. Work Breakdown Structure First Iteration Work Breakdown

  6. Presentation Outline • Review Feasibility Report • Goals for First Milestone • Current Status: Completed First Iteration • Requirements • Analysis and Definition • Specification • Preliminary Design • Implementation of Prototype • Evaluation • Goals for Next Milestone

  7. Requirements Analysis & Definition • Functional: • Must allow for WYSIWYG editing for creation/editing of page content • Includes editing of text and support for inline image addition • Must run on servers supporting PHP and MS SQL Server • Non-Functional: • Must retain close adherence to current look and feel • Includes keeping current graphics, color scheme and general layout • Must contain announcements under navigation in left justified sidebar • Must use Cloister Black font for title to maintain constancy between web and print material • Must use Garamond font for contents

  8. Presentation Outline • Review Feasibility Report • Goals for First Milestone • Current Status: Completed First Iteration • Requirements • Analysis and Definition • Specification • Preliminary Design • Implementation of Prototype • Evaluation • Goals for Next Milestone

  9. Requirements Specification State Transition Diagram

  10. Database Specification Entity-Relation Diagram: Users

  11. Database Specification Entity-Relation Diagram: Page Content

  12. Database Design DROP DATABASE BethEl CREATE DATABASE BethEl GO USE BethEl GO CREATE TABLE users ( userID int IDENTITY(1,1), login VARCHAR(50), email VARCHAR(50), password VARCHAR(30), PRIMARY KEY (userID) ) CREATE TABLE pages ( pageID int IDENTITY(1,1), pageName VARCHAR(100), pageDesc VARCHAR(300), pageFileName VARCHAR(100), PRIMARY KEY (pageID) ) CREATE TABLE containsPictures ( PRIMARY KEY(pageID, picID) ) CREATE TABLE containsEvents ( PRIMARY KEY(pageID, eventID) ) CREATE TABLE pictures ( picID int IDENTITY(1,1), picName VARCHAR(100), picFileName VARCHAR(100), PRIMARY KEY (picID) ) CREATE TABLE events ( eventID int IDENTITY(1,1), startShow DATE, endShow DATE, eventDate DATE, eventTitle VARCHAR(50), eventDesc VARCHAR(200), priority INTEGER, PRIMARY KEY(eventID) )

  13. Presentation Outline • Review Feasibility Report • Goals for First Milestone • Current Status: Completed First Iteration • Requirements • Analysis and Definition • Specification • Preliminary Design • Implementation of Prototype • Evaluation • Goals for Next Milestone

  14. Webpage Layout Design • Designed three prototypes for our client, from which she chose the first.

  15. Webpage Layout Implementation http://www.tcnj.edu/~babinsk2/Personal/501/index1.htm http://www.tcnj.edu/~babinsk2/Personal/501/index2.htm http://www.tcnj.edu/~babinsk2/Personal/501/index3.htm http://www.tcnj.edu/~babinsk2/Personal/501/index4.htm Implemented Layout

  16. Presentation Outline • Review Feasibility Report • Goals for First Milestone • Current Status: Completed First Iteration • Requirements • Analysis and Definition • Specification • Preliminary Design • Implementation of Prototype • Evaluation • Goals for Next Milestone

  17. Text Editor Design

  18. Text Editor License

  19. Text Editor Implementation Link to Implemented Editor

  20. First Iteration Evaluation • On Schedule Thus Far • Written Report to be Submitted on 3/10 • Client Feedback? • Prof. Arms’ and TA’s Feedback?

  21. Next Milestone: Second Iteration Requirements Evaluation PRESENTATION IN EARLY APRIL Implementation Design Reference: Iterative Procedure Diagram from Dr. William Arms, http://www.cs.cornell.edu/courses/cs501/2006sp/slides/lecture1.html

  22. Second Iteration Tasks Second Iteration Work Breakdown

More Related