Database Case Study

Database- An Introduction

Databases and database systems have become an essential component of everyday life in modern society. Nowadays, they are as common as smart-phones. Everyday, most of us encounter several activities that involve some interaction with a database.

Databases and it's technology are having a major impact on the growing use of computers. It is fair to say that they play a critical role in almost all areas. What’s the Buzz. What is so special about databases? What makes them so important? To find answers of these questions, let's explore database...

What is database?

You can think of database as godown or warehouse which is used to store different type of things. Technically,a database is a collection of information organized

Some bottlenecks can come for using databases.

Potential Network Problems

Connectivity Issues

Authorization Problems

Database Maintenance and Management

Disadvantages:

Although the database yields considerable advantages over previous data management approaches, database do carry significant disadvantages.

Complex, Difficult and time consuming to design

Substantial hardware and software start up costs

Damage to database affects virtually all applications programs

Extensive conversion cost in moving from file-based system to database system

Initial training required for professionals and users

I hope this article has helped to focus on introduction of databases and also has provided you with basic details of what is and why and when we use databases. Happy Testing:)

Posted by Shivani Thakur at 12:55 AM No comments:

Email This

BlogThis!

Share to Twitter

Share to Facebook

Share to Pinterest

Tuesday, September 23, 2014

Key Points For Database

In fact, SQL is the only language the most databases actually understand. Whenever you interact with such database, software translate your commands into SQL statements that batabase know how to interpret.

Primary key selection:

Selection of primary key is the most important decision to make.Primary key can be considered as THE MOST CRITICAL CONSTRAINT and it must be unique.

But while choosing primary key, it should be kept in mind that using it should not reveal sensitive information which cause vulnerability.

Databases Over Spreadsheets:

Databases does have a number of benefits over spreadsheets. Databases does retrieve the data from tables far more rapidly and in much easier way. Databases are concurrent, fault tolerant and scale well. It can handle very large data sets and provide more meaningful reports.

Understanding the "NULL" value:

Null value is critical when database is considered. SQL NULL is state (unknown) and not a value. Value of NULL is often mistook as zero.If a quantity is NULL that does not necessarily mean that the output is