0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
Describe database normalization?
Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency
What does extracting data mean?
one example is when you are unzipping a game on the p.c using the help of winrar[extracting program]
Another example is when you take something out extracting it.
Importance of databases in business world?
Databases allow businesses to store information about their employees and about their customers. With a database employees can access this information using computers instead of going to a warehouse.
How to write a Sql query to remove decimal point in a number?
To remove the decimal and numbers:
select Convert(int,12.456)
To keep the numbers after the decimal but remove the ".":
select convert(int,convert(money,12.456)*1000)
Does data warehouse contain data?
Warehousing term is used whenever it is about something to be stored in great quantity with proper categorisation for easy accessibility in need; same applies for data warehouse. It only gets in dept in case of data; relevancy, timeliness and analysis followed by reporting are of prime importance.
Source(s): http://bit.ly/153rq7v
How do you protect your PHP database settings file?
you can put the connection file 1 level above your website's directory, and use random names, like 2134j12h5kh35.php
but really, if it's extension is .php, and in the unlikely event that someone knows where it is, the server will process it anyway and unless you echo your connection details for some strange reason, nothing will be displayed.
To keep records of stuff! For E.g. School: Keeping a record of all every student's contact details. And The Fields Would be, Name, Address, Date of Birth, parents contact phone number, allergies, doctor! Another Example Is, Doctors: For Storing information about the patients that come in. So, if they have an illness the doctor can keep track on the patients on how well/bad its doing. And The fields Would be, Name, adress, Date of birth, emergency Number, Age, allergies, Doctors Name!
Thank You For Reading
Arsenal-United !
Why Multiplexer is called a universally complete logic model?
Universally complete logic module is a programmable logic device capable of producing all possible functions of three variables or less.It can be proved that a multiplexer is capable of producing all possible functions of three variables..So multiplexer is a universally complete logic module.
SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S
the porpose of database is to sstore consistent,standardise data at a centralized place in a secure manner and to facilitatedata sharing among all the applications requiring it.
Difference between char and varchar datatypes?
Char is fixed length, while Varchar is variable length.
What is database development methdology?
Database systems can be either referential, flat or heiarchial.
Advantages of dbms with example?
There are several advantages of DBMS:
1. Redundancy problem can be solve
2. Security level is high
3. Referential Integrity
4. Multi user Access
5. Data Independence
By Sushil Kumar Sinha
What is complexity of binary search tree?
The complexity of binary search tree :
Search , Insertion and Deletion is O(h) . and the Height can be of O(n) ( if the tree is a skew tree).
For Balanced Binary Trees , the Order is O(log n).
Traditional file processing system lacks from DBMS in many ways . Major Disadvantage of FPS are it do not maintains data security and integrity efficiently.
* In NOT NULL constraint the particular data cannot be NULL,
* In UNIQUE constraint the same thing cannot be repeated, it must be unique,
* The primary key is simply the combination of both these constraints.
An entity is something that exists by itself, although it need not be of material existence.
Defference between direct sequential and index sequential?
reduce the chance of false identification.----apex
What is the difference between adodc and adodb?
The main difference between ADODC and ADODB is that whereas ADODB is a class library, ADODC is just but a data control. The other difference is that ADODC uses the system resources more compared to the ADODB.
