Windows Sql Server Database Design And Optimization Essay

Q:1. Briefly explain following designing requirments that are required when designing the hardware and software infrastructure :

2. Identify what types of technology will be involved in the architecture and explain the purpose of each technology.

Team Mates as you know that we have chosen the Requirements in System Development Life Cycle, so have came across the following stages in the Requirements in my research which will be posted below specifically under their requirements.

Design – The requirements needed for functioning, support, and training are designed in this step. Emphasis is given to the functioning of the system and is produced as a high level guide. All the technical details for developing the system are created in a final system design.

• The interconnection requirements for information systems (including systems supporting mission/business processes and common infrastructure/support services) (Krause, 2009)

A relational database is a group of data which classified into a set of tables that can be accessed in several ways without having to reconstruct the tables’ oftenly.Relational Database was proposed by Edgar Codd around the time 1969 since then it has become very prevalent for commercial applications. In the 20th century there were countless Relational Database System (RDBMS) ,take for instance: IBM.DB2 and Oracle.

Design involves translating the identified requirements into a logical structure and consists of "defining the hardware and software architecture, components, modules, interfaces, and data to satisfy specified requirements It involves defining the hardware and software architecture, specifying performance and security parameters, designing data storage containers and constraints, choosing the IDE and programming language, and indicating strategies to deal with issues such as exception handling, resource management and interface connectivity. System design helps in specifying hardware and system requirements. The system design specification is a starting point for the next phase of the model.

Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

Briefly explain following designing requirements that are required when designing the Hardware and Software infrastructure:

Q:1. Briefly explain following designing requirments that are required when designing the hardware and software infrastructure :

Q.1 Briefly explain following designing requirements that are required when designing the hardware and software infrastructure:

Q1. Briefly explain following designing requirements that are requires when designing the hardware and software infrastructure:

In previous chapter the requirements, domain and technical analysis are done to capture the granular requirements build as component architecture. This section provides high level design (HLD) of the components and steps on coding and implementation.

At most need Analysis assist the system to verify and make clear that what types of requirements are needed to the particular system?

Existing I.T. Infrastructure: Includes existing computer units/terminals (if any) and the hardware and software components that can be a factor in design proposal.