Design and Develop E-Commerce Application

Question:

The learning outcomes that are assessed by this coursework are:

1. Design, construct and evaluate an e-commerce application involving the interaction between a range of software components.

Late submission of coursework policy:

Late submissions will be processed in accordance with current University regulations which state: “the time period during which a student may submit a piece of work late without authorisation and have the work capped at 40% [50% at PG level] if passed is 14 calendar days. Work submitted unauthorised more than 14 calendar days after the original submission date will receive a mark of 0%. These regulations apply to a student’s first attempt at coursework. Work submitted late without authorisation which constitutes reassessment of a previously failed piece of coursework will always receive a mark of 0%.”

You have been provided with a prebuilt SQL Server Database (see Section 1.2) that you must use as a means of data storage and retrieval. Most of the required functionality has been comprehensively documented for you as a requirements specification consisting of use cases, and user interface designs (see Section 2). You should strictly adhere to this documentation and use it as a basis for completing PART A of the assignment. PART B of the assignment provides you with more freedom to show creativity and innovation.

Following submission, you will be required to demonstrate your achievements to your tutor. This will allow your tutor to more easily assess your progress, and clarify any additions you may have added (during PART B). You will also be asked questions about the syntax and semantics of your source code. The level of understanding you display and the technical correctness of your answers will help to inform your tutors decision for a given assessment criteria. Once the viva has finished, you should get immediate feedback about your provisional (pre-moderated) mark for this assignment.

An explanation of the tables and the relationships between them: -A

· The User has a User Role, which may either be Student or Tutor.

· A Student studies one Course and a Course is studied by many Students.

· A Tutor teaches on one Course and a Course is taught by many Tutors.

· A Course consists of many Modules and a Module can be taught across many Courses.

· This many-to-many relationship is broken down into the table CourseModules, which has a composite key.

It is worth noting that this database design is simplified compared to that used in practice for such a system in a University. For example, a Tutor could teach on multiple Courses. For the purpose of this assignment however you should develop the web application based on the database design that has been provided.

Main Success Scenario:

1. System ensures a user is logged in (i.e. a Session exists).

2. System ensures logged in user is a Tutor.

3. System ensures page request is not a postback.

4. System queries the Courses table in the database, displaying the tutor's course name in a TextBox.

5. System queries the Users table in the database displaying all student users on the same course as the tutor in a ListBox.

6. System queries the Modules and Course Modules tables in the database retrieving all modules that are part of the student's course.

7. System displays each module (ModuleName and ModuleCode) in a Repeater.

8. Tutor selects course from ListBox and clicks update course Button.

9. System connects to database and updates tutor's course.

10. System updates Session CourseID value.

11. Tutor is redirected to UserAccount.aspx?UpdateSuccess=Course.