Reference no: EM13316143

Your project shall have the following features but not limited to:

1. Create the DigitalX database. Design tables and relationships.

2. Ensure that email addresses may only be used once in the database.

3. Create a stored procedure to add a new customer to the database. The stored procedure must accept all customers' information as parameters and insert them into the database. The stored procedure must encrypt the customer's password and store the encrypted password.

4. Create stored procedures to encrypt and decrypt a customer's credit card number.

(Hint: you will need to use the EncryptByxxx and DecryptByxxx system functions for your stored procedures.)

5. Create a table-valued user defined function to support the order history page of the website as shown in appendix 6.

6. Design a high availability plan and backup schedule for the DigitalX database. A graph for system activity is provided in appendix 1. Use this graph as a guide when planning your backup schedule.

Implement your backup plan in the database you have developed.

You DO NOT need to implement your availability solution. Instead of, state the reason and plans of you high availability solution by words. (Not less than 200 words)

7. Create a SSIS package to implement incremental processing of products information.

8. A view must be created to allow DigitalX employees to view all orders on backorder. The view must include the customer's email, contact details, the date the order was placed and the order number.

9. A view must be created to allow DigitalX employees to view all the products on backorder and the quantity of each on order. Your view must aggregate the data from the backorder products so that each product appears only once in the list.

10. Identify areas in your database where indexes would help improve query performance and create indexes on those columns.

 

Attachment:- SQL-Server-Final-Project.doc