Phase 2 Grading Criteria

Group Name:

______________________________________________________________

Group Members:

______________________________________________________________

Web Shopping - 32 points

_____ (4 points) Browsing: Users and guests can browse and search by title or author/musician and view all

_____ (4 points) Login: New users must register to get a shopping cart, old users can sign in a view/change user info

_____ (4 points) Shopping Cart: Each user should have a shopping cart where she can change quantities and remove items.

_____ (4 points) Persistent Cart: The shopping cart should persist between user sessions.

_____ (4 points) Inventory (Part A): A user or guest browsing should see all relevant info about each product.

_____ (4 points) Inventory (Part B): A user or guest browsing should see at least two additional attributes not in relational schema.

_____ (4 points) Tracking: A logged in user should be able to see a list of all previous invoices.

_____ (4 points) Delivery Status From each invoice, a user should be able to see the information on the status of all packages.

Check Out - 28 points

_____ (8 points) Shipping: User should be able to choose shipping options for each package related to the order.

_____ (4 points) Billing: User should see the subtotal, taxes, discounts, shipping cost, and total.

_____ (12 points) Card/Billing/Shipping info: User should be able to choose from information on file, or add new information.

_____ (4 points) Consistency: The database should remain consistent if the order succeeds or the user cancels.

Data Import (Part B) - 8 points

_____ (4 points) Properly Mapped: All relevant data mapped into relational schema.

_____ (4 points) All Maintained: All XML data retained in database.

Management Information Section (Part B) - 8 points

_____ (8 points) Required Queries: Complete required queries reasonably.

Code - 8 points

_____ (4 points) Website Code: All code files (.cs) turned in.

_____ (4 points) Data Import Code (Part B): Queries used for importing XML data (.sql) turned in.

Total

_____ /84