Web Technologies and DBMSsTracking SystemSlide 3Slide 4SolutionSlide 6Slide 7Login pageAdd CustomerCustomer Elimination viewSlide 11ConclusionConclusionCS 8630 Database Administration, Dr. GuimaraesWeb Technologies and DBMSs Martin BorakCS 8630, Fall 2005Purchase and People trackingCS 8630 Database Administration, Dr. GuimaraesTracking System•Problem statement•Selection of Technology•Proposed Solution•Screenshots •Conclusion Presentation OverviewCS 8630 Database Administration, Dr. GuimaraesTracking SystemProblem statementGoodFellas Inc. needs a web based tracking systemRequirements:1. Members should be able to log to a secure website.2. Assign members to each customer3. Assist customers with their purchases4. Track of purchasesCS 8630 Database Administration, Dr. GuimaraesTracking SystemTechnology Selection1. ASP, IIS, and MS Access2. PHP, Apache, and MySQLCS 8630 Database Administration, Dr. GuimaraesSolutionER DiagramCS 8630 Database Administration, Dr. GuimaraesSolutionRelation schemaCS 8630 Database Administration, Dr. GuimaraesSolutionRelationshipCS 8630 Database Administration, Dr. GuimaraesLogin pageCS 8630 Database Administration, Dr. GuimaraesAdd Customer•INSERT INTO customer (LastName, FirstName, Address, City, State, ZIP, PhoneNumber)VALUES (value1, value2, value3…)CS 8630 Database Administration, Dr. GuimaraesCustomer Elimination view SELECT *FROM Customer_PurchaseCS 8630 Database Administration, Dr. GuimaraesInsert and list productsSELECT productName, price, SupplierName, DateOfPurchase, DataPaied, AmountPurchased, Status, CustomerNameFROM CUSTOMER, PRODUCT, PURCHASEWHERE CUSTOMER.CustomerID=PURCHASE.CustomerIDAND PURCHASE.ProductID=PRODUCT.ProductIDCS 8630 Database Administration, Dr. GuimaraesConclusionI have learned:•Server side scripting languages•Exposed to open source software•Start projects early!!CS 8630 Database Administration, Dr. GuimaraesConclusionQuestions?Inage source:
View Full Document