CC6001 | Advanced Database Systems Development

Running head: CC6001 ADVANCED DATABASE SYSTEMS DEVELOPMENT
CC6001 Advanced Database Systems Development
Name of the Student
Name of the University
Authors note

CC6001 ADVANCED DATABASE SYSTEMS DEVELOPMENT
1
Table of Contents
Introduction..........................................................................................................................2
Features Implemented..........................................................................................................2
Deployment and Technology used......................................................................................3
Features of the ASP.NET....................................................................................................4
DDL Script...........................................................................................................................6
User manual.........................................................................................................................7
Registration..........................................................................................................................7
Login....................................................................................................................................7
Placing an Order..................................................................................................................7
Managing the Users and Order by staff...............................................................................8
Conclusion...........................................................................................................................8

CC6001 ADVANCED DATABASE SYSTEMS DEVELOPMENT
2
Introduction
In this era of changing environment of business, it is very essential to respond to the
requirement of the clients and customers in a manner that is timely and effective. If the clients of
an organization want to view the business online and have an instant admittance to the services
and products of the company, then it is required to do so.
In order to create a website of E-Commerce, many technologies need to be studied and
understood. These consists of server and client-side scripting technologies, architecture those are
multi-tier and the implementation technologies such ASP.NET, relational databases and the
programming languages such as C#.
Features Implemented
Any member of the website can easily register and then view the products those are
available.
 Only the customers those are registered can check out with the products irrespective of the
quantity of products.
 The Contact Us page is integrated with the website for the users so that the users contact the
admin/organization if the members customers are having any queries
 There are basically two roles available on the website which is staff and user.
 The visitor can view the products those are available in the website
 The user can do both the activities that is to see and then purchase the products
 The function of the admin is to add products, edit the information of the products and
remove/add the products

CC6001 ADVANCED DATABASE SYSTEMS DEVELOPMENT
3
 The staff can add , edit, remove, update view user and products details in the database that
are depicted on the website
Non-Functional and Security Requirements
 The website pages must be navigated in a way they are meant to be accessed by the different
users such as staff and member. The consisting files that should not be accessed outside the
scope of the parent.
 The admin can execute the task of administration on certain pages that they have the
privilege to access. The clients or the customers are not permitted to enter the pages of
administration.
Efficiency and Maintainability
 The loads of the pages should be formatted and returned in a manner that is timely depending
upon the request that is being made
 The administrators will have the capability to edit the aspects of the forms of the orders,
descriptions of the products, prices and directly the websites.
Normalized Tables for the Application
Member (id, name , last-name, address, mail, phone)
Product(ID, name, price, description, stock)
Order(ID, customerID, Quantity, payment amount)
Quotation (ID, Name, value, customerID, DateofQuotation)
Staff (StaffID, Name, address, Contact)