answersLogoWhite

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 relational database relate to programming?

A relational database system is a set of generalized methods for organizing, storing and retrieving information. For certain types of computer applications, the use of a relational database greatly reduces the time and effort needed to design, write and debug new software, by eliminating the need to develop code to handle storage, sorting and retrieval for each program.

What are the problem encountered in manual billing system?

The problem encountered in manual billing system is wasting time.

What is the purpose of the vlan database?

Vlan database is vlan.bat file which is stored in flash memory and earlier in NVRAM. It is used to store vlan information. we can take back up of this file.

What is a database GUI?

The graphical user interface of the database.

What is bcnf explain with example?

define BCNF. Explain with appropriate example

What do hotels use databases for?

Hotels use databases to store the names and information of the people who are staying and when they are staying. They also use them to keep track of the hours people work, which rooms are clean and ready, which guests want wakeup calls or breakfast, and which ballrooms are going to be used for future events.

What advantages do databases have over flat files?

1. files are can easily get damaged for e.g by water or fire and etc but a data base cant so easily get damaged you can find delete or edit files on the data base easily while if you hv a big file it is hard

Is Ingres an open source database?

Yes. Development is managed by Ingres Corporation, but the source code is released under the GNU General Public License.

What is monolithic entity?

Something (x) which can be regarded as forming one single, large:

[e.g. nature: large block of stone, business: firm, etc.], and exists in its own right.

What is garbage in garbage out in database?

It means if you enter "rubbish" information into a database, you'll only get "rubbish" information out.

So check any data that is going to be inputted into a DB.

What kinds of data are used by a systematist?

Systematists use data taken from fossils, homologous features, and embryologic data.

What is Attribute in system analysis?

Knowledge of organisation

Knowledge of computers and software

Good interpersonal relations

Ability to communicate

Analytical mind

Breadth of knowledge

What is the difference between a reporting entity and a taxable entity?

the difference between a reporting entity and a taxable entity is, a reporting entity is the company or organization and the taxable entity is the individual.

What is the role of normalization?

In broad-spectrum, normal flora are not invasive and do not usually cause disease. They occupy niches that supply their requirements for nutrients, oxygen and space to reproduce. They may provide some benefits in unknown vitamins, or some discomfort as they produce gas from undigested food.

What is the purpose of using joins in database is normalization the only purpose of it?

The purpose of using Normalization is to avoid the data redundancy in tables. The normalized schema is much faster in performance so you can get a quick response from the database.

OLTP database designers follow the Normalization rules but the tables in Data warehousing(OLAP) data bases are in the De normalized form, they won't follow the Normalization technique. For this reason we are using more complex queries in Data warehouses which uses more system resources.

Some one might explain you better way.........

Thanks

Blueberry

What are advantages and disadvantages of circular queue over ordinary queue?

Circular queues are very efficient and work well with low level codes. Ordinary queues are the standard type of queue but they do not maximize memory data well.

What are the three update commands in sql?

The three update commands in SQL are SET, WHERE, AND FROM.