|
|
coderzone
This is my first article and so please provide comments on it (good or bad).
The design of the database is one of the most important factors in the performance of the database and with a good database design you also need optimal queries to perform optimally. Everyone wants the performance of...
|
|
13 |
11,225 |
|
|
|
shabbir
1. Explain the difference between a database administrator and a data administrator.
Database Administrator :- A person (or group of people) responsible for the maintenance and performance of a database and responsible for the planning, implementation, configuration, and administration of...
|
|
5 |
55,183 |
|
|
|
shabbir
A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored....
|
|
10 |
121,155 |
|
|
 |
Shree Limbkar
1. What is database?
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.
2. What is DBMS?
It is a collection of programs that enables user to...
|
|
7 |
6,495 |
|
|
 |
Janu
Introduction
You have two dates (either in your code or in your database columns). How to calculate the difference between them in years, months, weeks etc!
This is one of the most common questions on many forums, and the logic in general is quite simple. Most programming languages give you...
|
|
3 |
15,058 |
|
|
 |
shabbir
Introduction
When I was managing a team of five developers I use to distribute the work among the team members and I was using the Excel for making notes of everything but on one day I though of writing a simple program for myself and used one weekend to write the program for my job but I though...
|
|
3 |
7,318 |
|
|
|
shabbir
The definition of stored procedure as from WIKIPEDIA
Stored procedure
A stored procedure is a program (or procedure) which is physically stored within a database. They are usually written in a proprietary database language like PL/SQL for Oracle database or PL/PgSQL for PostgreSQL. The...
|
|
9 |
67,843 |
|
|
 |
pradeep
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you "Is that database normalized?" or "Is that in BCNF?" All too often, the reply is "Yeah." Normalization is often brushed aside as a luxury that only academics have time...
|
|
12 |
16,738 |
