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
|
Describe the parts of any existing video gamemidnight club
: Describe the parts of any existing video gamemidnight club.You should describe its gameplay, theme, etc. Write at least two full pages. The more you describe the better. Include pictures of the game.
|
|
What are similarities and differences between monopolies and
: What are similarities and differences between monopolies and oligopolies? How would you classify Microsoft? How would you classify the power industry in your area? Explain your reasoning.
|
|
How much work is required to move a tiny charge
: Four spheres are arranged as in the figure in the corners of a 2cm-side square, How much work is required to move a tiny charge of 10nC from C to A
|
|
What is the slope of the line described by this equation
: What is the slope of the line described by this equation: P = 3Q + 1/2? P is plotted on the vertical axis, and Q is plotted on the horizontal axis.
|
|
Create a ssis package to implement incremental processing
: 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.
|
|
Find the recoil speed of the rifle
: A rifle with a weight of 30 N fires a 3.0-g bullet with a speed of 240 m/s, Find the recoil speed of the rifle
|
|
Where will he choose to operate on this graph
: If Kevin is a rational consumer, where will he choose to operate on this graph? Identify the equilibrium point that maximizes Kevin's net benefits by selecting point A, B, or C.
|
|
Determine the time required for one complete revolution
: A particular satellite was placed in a circular orbit about 145 mi above Earth. Determine the time required for one complete revolution
|
|
Determine the components of the reaction at c
: Knowing that P=109.2 kips and Q=72.8 kips, determine (a) the components of the reaction at C, (b) the components of the force exerted at B on segment AB.
|