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

What are Subsystem of Management information system?

Management reporting system, Decision support system, Excutif information system

What is hierarchial diffusion?

Diffusion that occurs downward or upward through an organizational hierarchy; when mapped, it shows up as a network of spots.

What are differences between data types numeric and non numeric?

Numeric data are data that can be quantify. i.e age, e.t.c While Non-numeric data are data that cannot be quantify but can be categorise. Such as colour, name e.t.c

Query command in citrix?

change user /?query

install mode - we can perform installations to the presentation server

execute mode - normal running mode where it runs users sessions.

qfarm /?query

queries the farm.. you can get informations like current running processes, running apps, load and many more.

Difference between database and relational database explain with example?

Database = Generic name for a system to store data

Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.

What are the function of a warehouse?

Warehouses are basically used to store or keep goods, including those that will only be taken out for distribution or when an order is placed. Warehouses can act as storage for materials that are going to be used or that have to be kept and not be used (e.g. samples, documents, collected returns, or materials from discontinued programs).

The 3 Main function of warehouses are:

1: Movement - from one location to another, or temporary relocation

2: Organization - of goods as produced or as received, and for shipping

3: Storage - of materials either for distribution or long-term holding

What is the difference between an operational and a transactional database?

The difference is not so much in the database itself but with the application that uses it. An operational application does all database queries/updates in a single one-and-done manner. Transactional applications have multiple steps that are considered a single unit and may involve dozens of database operations that must all be completed before any are finalized. Otherwise, the entire transaction is rolled back.

Can you create a database in Microsoft Word 2007?

You can lay out data in a tabular format in Word and do things like sort it and even do some calculations. Using Word you can create data in a format that could later be used in a database application, such as comma separated text. When doing a mail merge, you can create your data with Word rather than sourcing it externally, and it will be stored in a file with fields to be used in you mail merge. So Word does have some limited databasing capabilities, but you would not use it to make a proper database as it does not have all the facilities to do so.

User visible register?

Registers that are used during prigramming and specified directly by the instruction.

What is the example of online transaction processing?

one of the examples of online transaction processing is the E-Commerce. But not just one example there are many of them..

How do email service provider websites earn money?

Advertising, of course! Even this site obtains some of its funding from advertisers. While some of them provide random topics, the more sophisticated ones actually 'read' your email and put related advertising beside the mail. If you talk to someone about finding genealogy links, advertising related to family tree products will show. Or talk about karate and martial arts links will arrive.

What is the conceptual meaning of average for a data set?

For any data set, the average would be sum of all the values , divided by the number of values ...

Hence the average of 1,2,3,4,5 would be :

1+2+3+4+5 / 5 , or 15 / 5 = 3

What is main difference between dbms rdbms why it is called relational database?

There are mainly three different Database architectures and they are network, hierarchical and Relational. The DBMSystems that follow the Relational architectural concepts are known as RDBMS. This is supposed to be superior in design and performance to the other two and there are, to my knowledge, no functional DBMS following the other two concepts in the market today.

Do you consider all your academic results to be a fair reflection of your academic ability if there is a significant reason for the difference please comment?

Do you mean this in terms of school academic achievements? If so, most people have probably encountered unfairness one way or another academically. However, it would be quite difficult to fairly judge "all" of one's academic abilities since the one to judge may have various opinions. For instance, teachers and educators can have difficulty determining what is exactly "fair" and what is not fair considering that many things vary from person to person. Mostly, educators determine one's results by seeing how far the person is from reaching his or her academic goal.

Find out functional dependencies?

A constraint between two sets of attributes is known as functional dependency in relational database. Determination of functional dependencies is vital in database denormalization, normalization and relational model.

Where can you find php scripts that support postgresql?

Hello everybody please where can i find php scripts lms cms... that support postgresql??

THANKS for advance.

How do you input panel data into stata?

Type "help xtset" in Stata. Stata's xtset command does not necessarily expects that your panel has both a cross-section (x) variable and a time (t) variable. Let's say you have data collected yearly from a bunch of countries. In this case the order of the observations for each country matters, so you use: xtset country year But sometimes your panel isn't a real panel, in that while the observations may be correlated within the x dimension, their t dimension order does not matter. Suppose, for example, that you have multi-country data collected by city. Say you expect the variables of interest to exhibit intra-country correlation, but clearly the order in which cities show up in your data set for any given country is irrelevant. This is a panel, but not a proper one. If you want to use xt commands, then you xtset it like so: xtset country

What is spruz?

Spruz is a social network platform that enables you to make and maintain your own online community. It was started in 2007. It is also very affordable and easy to use. It empowers brands to make their own focused online communities.

What are the roles of database and database administrators?

A database is a storage that contains data. To manage data in the database different roles are assigned . One such role is of a DBA that is database administrator that is responsible for managing the database.

A database stores data and manages data. It allows people to enter data and get information from the data in the form of queries or reports.

A database administrator looks after the maintenance of the database, including things like the design, testing, security etc. He services the needs of users that have to access the database.