1 / 16

Web Technologies and DBMSs

Web Technologies and DBMSs. Stephen Borick. CS 8630, Summer 2004. JBSA Computer Book Store. Presentation Contents. Executive Overview Technology Selection User & Administrator Views Entity Relationships Relational Schema Crud Matrix Things Learned. Executive Overview.

jethro
Download Presentation

Web Technologies and DBMSs

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. Web Technologies and DBMSs Stephen Borick CS 8630, Summer 2004 JBSA Computer Book Store

  2. Presentation Contents • Executive Overview • Technology Selection • User & Administrator Views • Entity Relationships • Relational Schema • Crud Matrix • Things Learned

  3. Executive Overview JBSA Computer Book Store needs a web based shopping cart. The requirements for this system are: • Will need to find a way of connecting the database to a user’s browser. Users should be able to browse items by category. 2. Users should also be able to select items from the catalog for later purchase. It is required that the items selected can be tracked. 3. When the user has finished shopping, JBSA will need to be able to total up their order, take their delivery details, and process their payment. 4. An administrator interface to JBSA’s website is required so that the administrator can add and edit books and categories on site. 5. Technology to be used will be PHP/MySQL on an Apache web server.

  4. Technology Selection

  5. Technology Selection - 2

  6. Technology - 3

  7. Technology - 4

  8. User View

  9. Administrators View

  10. Actual Entity Relationship

  11. Relational Schema

  12. Tables

  13. Form Description

  14. CRUD Matrix: Forms Versus Tables C = Create or Insert a Record (row) R = Read/Query or Select a row U = Update or Modify D = Delete

  15. Things Learned • PHP, MySQL, and Apache Web Server • Entity Relationship Model is key to database design (see preferred next slide) • Back-up your system and use a UPS

  16. Desired Entity Relationship

More Related