Windows Sql Server Database Design

8605 Words Jul 21st, 2015 35 Pages
Tasman International Academies

Diploma in Information Technology (Level 7)

ASSESSMENT: Windows SQL Server Database Design and Optimization

STUDENT NAME:: RANJIT SINGH STUDENT ID :: 14112532

ASSESSOR NAME:: IMRAN SIDDIQUE

DATE SUBMITTED:: 20/07/2015

SUBJECT:: ASSESSMENT (THEORY)

Assessment: Task One Theoretical Questions Outcome 1 (1.1)
Q1. Briefly explain following designing requirements that are required when designing the Hardware and Software infrastructure:
a) Storage requirements
A lot of considerations go into analyzing the storage requirements of a database server. In addition to the physical size of the database, you need to consider the transaction growth rate and data-distribution requirements. Some industries, particularly financial and healthcare institutions, are subject to requirements regarding data retention, storage, and security that must be taken into account in determining storage capacity. You’ll now learn how to determine the current storage capacity of a database server and identify factors that affect its growth. We’ll also look at how to forecast future disk-storage requirements, taking into account any relevant regulatory requirements that may apply to your business or enterprise.
b) Network requirements
All database…
Open Document