1 / 19

MU Bulletin Board

MU Bulletin Board. Member: Carol Lim Yi Wang Lei Wen Mentor: John Boyer Programmer/Analyst of MSA/ Student Life. Introduction. System Overview – Reason / Purpose Research Customer Requirement Server & Development Environment – Hardware Software language System Interface

mannie
Download Presentation

MU Bulletin Board

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. MU Bulletin Board Member: Carol Lim Yi Wang Lei Wen Mentor: John Boyer Programmer/Analyst of MSA/ Student Life

  2. Introduction • System Overview – Reason / Purpose • Research • Customer Requirement • Server & Development Environment – Hardware • Software language • System Interface • Function Design • Database design – ERD, dataflow diagram , system process flow • Security and protection • Testing • Problem facing • Future work

  3. Overview • Purpose of our project • Focus on local market • Lower down the costs (shipping and handling, time and resources) • Faster the news spread (fill the forms and submit) • Gather all information from different categories • User friendly (update and safe)

  4. Research • CollegeThrift.com • www.collegethrift.com • Ebay • Amazon • Yahoo • Off Campus • http://offcampus.missouri.edu • Roomate Search Engine • http://roommates.missouri.edu/ • TigerBay (Offline)

  5. Customer Requirement • Public user • View Information only • Register user • Register (username, password, address etc) • Login/Logout • View Information • Post Information • Update Information • Delete Information

  6. Server & Development Environment • Internet Connection • Internet Explorer 6.0 and Netscape 5.5 • Linux system (EBW Computer Lab) of University of Missouri • dbms-unix.cecs.missouri.edu (MySQL)

  7. Software Language • PHP • HTML • SQL • JavaScript • CSS • XML/RSS (Really Simple Syndication) • Photoshop • Microsoft Office

  8. First User Interface News

  9. Second User Interface

  10. Function Design • Car (done!) • Book (done!) • Furniture • Ticket • Rental • News (done!) • Electronic • User Account (Login / logout) (done!)

  11. Function Design (continued) • CREATE TABLE Book ( • Bid INT NOT NULL, • ISBN INT, • Bcondition VARCHAR (100), • Btitle VARCHAR (20) NOT NULL, • Bprice DOUBLE NOT NULL, • Author VARCHAR (50), • Bpost_date DATE, • Bpicture VARCHAR (100), • Caid INT NOT NULL, • CONSTRAINT PK_Book PRIMARY KEY (Caid, Bid), • CONSTRAINT FK_Book FOREIGN KEY (Caid) • REFERENCES Catalogue (Caid) ON DELETE CASCADE);

  12. Data Flow Diagram

  13. Old ERD

  14. Current ERD

  15. System Structure

  16. Security and protection • Server Side Validation • Password Encryption • Session Protection

  17. Testing • Fundamental Error Checking • Input Testing • System Integrate & Testing • Common library files.

  18. Problem Facing • Temporary MySQL Server • Late Permission Using of MySQL Server • Limited Time to Implement (3 weeks) • Communication Problem • Lack of User’s Feedback

  19. Future Work • Finish the Remain Functions • Improve Interface • Add more useful Functions (Bid, Online Payment, Category Adding etc.) • Find a Stable Web and Database Sever

More Related