Windows Sql Server Database Design

3374 Words Jul 22nd, 2015 14 Pages
Tasman Interna tional Academies

Diploma in Information Technology (Level 7)

Assessment: Windows SQL Server Database Design and Optimization

Subject Code: WD 602

Purpose: People credited with this unit standard are able to: Explain purpose designing hardware and software in database. Gain knowledge of server administration, designing physical storage, designing server-level security, data recovery solutions and object-level security.
Aim: The assessment aim is towards achieving competency in candidate performance of demonstrating knowledge of Designing and optimization of SQL database server.
You will be required to demonstrate the competency in the following aspects through submitted written/demonstrate work on the assessment Tasks.

• Design hardware and software infrastructure.
• Design physical storage
• Design Database security
• Designing physical database
• Designing data recovery and data archiving.


Student ID : 14111938 Date Submitted 20/07/2015 Assessor Name MR. IMRAN SIDDIQUE Signature Outcome 1(1.1)
Q:1. Briefly explain following designing requirments that are required when designing the hardware and software infrastructure :
a) A:- STORAGE REQUIRMENTS: There are 2 sources of capacity requirements:- business and technical requirements of the organization. The technical requirements are dictated by need and availability. You should also…
Open Document