250 likes | 709 Views
u Bulletin.com Target Clients Students WWW Professors u Bulletin.com Community/ Private Business u Bulletin.com Statement of Purposes u Bulletin.com Site Features u Bulletin.com u Commerce u Tools u Entertainment u Stores For Sales For Lease Wanted Text Books Rooms Jobs
E N D
uBulletin.comTarget Clients Students WWW Professors uBulletin.com Community/ Private Business
uBulletin.comSite Features uBulletin.com uCommerce uTools uEntertainment uStores For Sales For Lease Wanted Text Books Rooms Jobs Tutoring Auction Calenders* Calculators* Messageboards* Teacher Eval. Course Eval. Financials* QT-TV* WebRadio* MP3* Horoscopes* Showtimes* Amazon.com* AffiniaStores*
uBulletin.com • Harry Hong • Man Wai Ho • Helina Truong • Kham Vo
uBulletin.comOrganizational Chart Kham Vo (CEO) Man Wai Ho (Web Design Mgr.) Harry Hong (Technology Mgr.) Helina Truong (Database Mgr.) Kham Vo (Software Mgr.) Kham Vo Harry Hong Kham Vo Man Wai Ho Harry Hong Harry Hong Man Wai Ho Helina Truong
uBulletin.comEngineering Students WWW SQL Data Base Server NT/IIS/ASP Web Server Professors Community/ Private Business
uBulletin.com Hardware Requirement NT/IIS WebServer NT/SQL Database Server PowerMac
uBulletin.com Software Requirement MS Window NT 4/IIS/ASP MS SQL Server 7 DreamWeaver (Macromedia)
uBulletin.comSite Features uBulletin.com uCommerce uTools uEntertainment uStores For Sales For Lease Wanted Text Books Rooms Jobs Tutoring Auction Calenders Calculators Messageboards Teacher Eval. Course Eval. Financials QT-TV WebRadio MP3 Horoscopes Showtimes Amazon.com AffiniaStores
uBulletin.comDatabase Design • Fast storage & retrieval of data. • Memory saving. • Privacy/Security issue. • Easy maintenance & expansion.
Entity Relationship Diagram(ERD): Auction Category ID Bid Amount PostingFeeID Commission ID Member ID Member ID LowerOfRange LowerOfRange Time of Bid Bid ID Category Preferences HigherOfRange HigherOfRange Bids Percentage Posting Fee Commission Rate Posting Rate Member ID LName Total Auction Fee FName Members Address Total Fee ID ZipCode Auction Items Commission ID Phone Posting Fee ID Email Member ID Item ID Post Date Category ID Item Categories Log on Info Item Name Start Date Category Item Desc. End Date Member ID Password Min Bid
Entity Relationship Diagram(ERD): Textbook Email TextBookID DeptID Phone Contact DeptName NewPrice SchoolID ContactID OldPrice Textbook_ Price_Info Contact School_Dept MyPrice CourseID CourseName TextBookID Member ID CourseSect CourseID ProfID LName Term FName Textbook_ Info Textbook_ Courses Course_Info Professors Members Address TextbookID TBDesc ZipCode CourseTitle TBTitle Date Phone SchoolID? TBEdNum Sold Email DeptID TBStatus MemberID Schools ProfID? Publisher Publishing_ Info ProfLname ProfFname SchoolID PublisherID SchoolID? PublisherID SchoolName ISBN# Author DeptID PublisherName TextBookID
ERD: Teacher Evaluation SchoolID SchoolName School ProfID ProfLname DeptID DeptID Member ID ProfFname DeptName SchoolID? LName FName Members Teacher_Evaluation Professor School_Dept Address ZipCode SchoolID CourseID ProfID Phone Comment Grade Email PostID Course_Info Log on Info Term CourseID ProfID? Member ID Password CourseName CourseTitle DeptID CourseSect SchoolID?
ERD: Course Evaluation SchoolID SchoolName School CourseID Term CourseTitle ProfID? DeptID Member ID CourseSect DeptID DeptName LName CourseName SchoolID? FName Members Course_Evaluation Course_Info School_Dept Address ZipCode SchoolID CourseID ProfID Phone Comment Grade Email PostID Professor Log on Info ProfFname DeptID MemberID Password ProfLname SchoolID? ProfID
ERD: ForLease, ForSale, & Wanted For_Lease ContactID Contact Member ID LName Contact FName Members For_Sale Category Email Address ZipCode Phone Category ID Phone Email Category Wanted Log on Info MemberID Password
ERD: Room Email Phone Contact ContactID Contact City Member ID CitytID CountyID LName FName Members Room_Postings City Address ZipCode CountytID Phone County Email Room_Types County StateID RoomTypeID RoomType Log on Info State StateID MemberID Password State
ERD: Jobs JobType StatusID Status IndustryID Industry JobTypeID IndustryID Industries Job_Types Job_Status City Member ID CitytID CountyID LName FName Members Job_Postings City Address ZipCode Phone CountytID Email County County StateID Log on Info Contact State MemberID Password Contact ContactID StateID State Phone Email
uBulletin.com Web Design Goals • user-friendly interface. • Mininal number of clicks. • Intuitive (no guessing). • No information overload (no cluttering). • Security. • Privacy. • Minimal download time.
uBulletin.comSite Features uBulletin.com uCommerce uTools uEntertainment uStores For Sales For Lease Wanted Text Books Rooms Jobs Tutoring Auction Calenders Calculators Messageboards Teacher Eval. Course Eval. Financials QT-TV WebRadio MP3 Horoscopes Showtimes Amazon.com AffiniaStores
Data Flow Diagram: uCommerce (Non-Auction) Buy Choose Category* Enter Search Search Results Register Submit Form Web Site Visitors Ok! No Verify? Fill out Form Success? Yes Log-on Yes * Categories Wrong! Log-on? Sell Choose Category* For Sales For Lease Wanted Text Books Rooms Jobs Tutoring No