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
How does google's business model use personal data?
I'm also looking for the answer :D share it to me if you know ..
LIKE it .. ajejeje :J
What are the companies that use encrypted databases?
There are many thousands of companies that use encrypted databases. All banks use them.
Can you use SQL to pull data from Oracle?
yes....
example:
select *from employee;
dml command in sql language
USE VIRRTUAL DJ (5).......YOU RECORD THE AUDIO PART YOU WANT....(THE FINAL FILE WILL BE IN WMV,YOU WILL CONVECT INTO ANY AUDIO FILE FORMAT YOU WANT......
Well, I still use SnowFox Audio Converter. It's a good software, which could extract audio from almost all video files, convert a batch of audios, trim audio and many other useful features.
How do you calculate tax using a query in Microsoft access?
The easiest way to do this, assuming you have a fixed tax rate, is to simple create a calculated field in a query.
Let's say you have a table with Price, Quantity, and TaxRate in it. Create a query based on that table, and bring these three fields into the query.
Now create a new, calculated query in a new column. In the first row (the name) of the query, put the following:
SalesTax: (Price * Quantity) * TaxRate
When you run the query, you should see SalesTaxt as a new, calculated field. Now you can use this query for any forms or reports you need this value in.
Hope this helps.
Richard Rost
www.AccessLearningZone.com
What is used for importing into excel data that is stored on a website?
The traditional method of creating a web query uses the New Web Query menu command found on the Data menu under Import External Data.
See related links for examples.
What is the difference between sybase and oracle?
difference is only in their name. Sybase is developed by a farmer named sybase and oracle is developed by an actor oracle. sybase is tool which will help farmers and oracle is used to invent the actor inside us.
Erroneous means something that is incorrect or wrong. Therefore Erroneous Data is essentially Incorrect Data.
What is the difference between the where and having sql clauses?
The short answer is that the WHERE clause is used for comparing values in the base table, whereas the HAVING clause can be used for filtering the results of aggregate functions in the result set of the query. SELECT * FROM tablename WHERE ID > 100 ...is an example of a WHERE clause. Here's a simple example of a HAVING clause that returns the count of workers with the same last names... SELECT WorkerLastName, COUNT(WorkerLastName) AS WorkerCount FROM tblWorker GROUP BY WorkerLastName HAVING COUNT(WorkerLastName) > 1 The HAVING clause allows you to filter the results of aggregate functions, such as COUNT() or AVG() or SUM(), or MAX() or MIN(), just to name a few. HAVING provides you a means to filter these results in the same query, as opposed to saving the results of a WHERE clause SQL statement to a temporary table and running another query on the temporary table results to extract the same results. To do the HAVING SQL above without the HAVING clause would require the following SQL: SELECT WorkerLastName, COUNT(WorkerLastName) AS WorkerCount INTO TempTable FROM tblWorker GROUP BY WorkerLastName SELECT * FROM TempTable WHERE WorkerCount > 1 DROP TABLE TempTable
What are the limitations of a file-based approach?
* Separation and isolation of data * Duplication of data * Data dependence * Incompatibility of files * Fixed queries / proliferation of application programs
Why is it important to synchronize data process models?
It is important to synchronize data to show consistency and completeness of the total system requirement earlier captured in the data model and process models.
How do you handle database in php?
Please refer link. The presentation gives complete understanding of how to deal with database (Mysql) with php.
Example for first normal form?
A relation is said to be in 1NF iff each arttribute of the relation is atomic i.e each column must contain only single value.
basic rules for 1NF
1.eliminate duplicate column from the same table
2.create separate table for a gr. of related data and distinguish each row with a unique column or set of column
The field can contain any characters. A maximum number of 255 characters is allowed in a field whose data type is Text.
To what extent does the digital divide effect third world countries?
use wikipedia :) thats alot of help. x use wikipedia :) thats alot of help. x
Describe each of the data hierarchy levels?
Character - a letter
Field - a group of characters. Like letters make up a word.
Record - a group of fields describing a single entry. Like if we put you into a phone book we would use your name, address and phone number (the fields) of you record.
File - a group of records. Like the A's in the phone book.
Database -groups of related files. The phone book.
Computers categorize information in order to handle it quicker. Placing similar files in the same destination allows the processor to retrieve it quickly.
Where can I find a worldwide hotel database?
I've got mine from here:
Hotel Database with all 510,417+ Hotels in the world
Cheapest database that I could find and I am very satisfied with the files!
What is transaction processing?
you were introduced to the concepts behind transaction processing. But you may still be wondering just what this is. Transaction processing has been around since the mainframe days of computing. You may have heard of, or have even used, products such as CICS, Tuxedo, or TopEnd. These are all examples of transaction processing systems, which provide transaction services to applications that use them. There are a number of attributes that make up transaction processing.
In order to discuss transaction processing, we must first agree on a definition of what a transaction is. A transaction is an atomic unit of work that either fails or succeeds. There is no such thing as a partial completion of a transaction. Since a transaction can be made up of many steps, each step in the transaction must succeed for the transaction to be successful. If any one part of the transaction fails, then the entire transaction fails. When a transaction fails, the system needs to return to the state that it was in before the transaction was started. This is known as rollback. When a transaction fails, then the changes that had been made are said to be "rolled back." In effect, this is acting similar to the way the Undo command works in most word processors. When you select undo, the change that you just may have made is reversed. The transaction processing system is responsible for carrying out this undo.
What is the difference between sorting and searching in a database?
Searching allows you to find data that meets specific criteria. Sorting allows you to organize that data, based upon the rules you choose (most common is alphabetical).
Neighbor Table, topology and feasible successor
yes, as you can save data on to it. It contains fields such as album and artist, and hundreds of records - information for each individual thing, which are both key features of a database
According to DB Engines regular ranking study, Oracle is the most popular DBMS.
MySQL comes in second, then MS SQL, then a large gap before the rest of the database management systems.
db-engines.com/en/ranking
- a report on a database is the answer to a query -
e.g.
SURNAME NAME AGE
Smith Willow 24
Neet Charlotte 20
Sindad Daniel 13
Juugo Ryan 17
QUERY: Everyone over the age of 18
THE REPORT WOULD LOOK LIKE THIS:
SURNAME NAME AGE
Smith Willow 24
Neet Charlotte 20
