Windows Sql Server Database Design 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.

The database environment consists of the system hardware, software, people, procedures, and data. The hardware that will be used for the database is a network of Dell

By applying this rule, patient and employees table has to be divided into smaller tables. Patient table limits hospital to enter more than one appointment, drug allergy, symptom, prescription entries.

So for anything beyond 3 years we feel the capacity utilization will max up at around 70%

For Capability and Storage availability which is directly related , it is significant to understand how many products the

grow at an exponential rate. So does the need to insure the integrity of the data and secure the

In addition to the ERD for the logical design of the database you should make recommendations on how the database will be physically implemented in terms of hardware and software requirements. Issues such as backup and recovery, data integrity, and security should also be addressed.

Describe 5 components of the database system and why they are important part of the system?

So, database project started at 1997 and project went well. But it is very much state of the art technology and IT is also difficult for everyone at first. After researching more than 2 years about individual card holder transaction records and a selection of non-card holder sales records, the size of the database was larger and larger. Therefore, Boots wanted to get the right structure database with maximum flexibility and also it can achieved to store data at the lowest level of granularity for user to build it up to any level they require during analysis. Commercial analysts can also have rapid real time access to all of the data without having to make special requests on IS support. The database structure should be to support the analytical process.

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

Database System is one of the most important concern in the field of Informational technology. It contains the most reliable

This subsection will provide and present the essential and fundamental designs following the software development means which are considered

Location and roles of database servers: - Also according to the roles and location of the database servers the storage requirements

John W. Brackett states that “The subject of software requirements is often given far less attention in software engineering education Because of the dependence of this module on than software design, even though its importance is Software Specification: The hardest single part of building a software system is deciding precisely what to build. No other part of the conceptual work is as difficult as establishing the detailed technical requirements, including all the inter-faces to people, to machines and to other software systems. No part of the work so cripples the resulting system if done wrong. No other part is more difficult to rectify later” (Brackett, 1996). This paper will give the definition of software requirements; how they are determined, specified, documented, and who is included in the process of requirements; and the roles these individuals play in processing requirements. The end of this paper will bring all of these concepts together to help explain why these processes are extremely important.