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.
What are the differences between different types of Database Management Systems?
DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data.
RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS. Invented by E.F. Codd, the only way to view the data is as a set of tables. Because there can be relationships between the tables, people often assume that is what the word "relational" means. Not so. Codd was a mathematician and the word "relational" is a mathematical term from the science of set theory. It means, roughly, "based on tables".
AnswerDBMS includes the theritical part that how datas are stored in a table.It does not relates tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with another and handling datas stored in tables.
Answer1)rdbms is object based database management system while dbms 2)rdbms can maintain at many users at same time while dbms not 2)in rdbms is relation is more important than object itself while dbms entity is more important
AnswerThe main advantage of an RDBMS is that it checks for referential integrity (relationship between related records using Foreign Keys). You can set the constraints in an RDMBS such that when a paricular record is changed, related records are updated/deleted automatically.
AnswerORDBMS = ODBMS + RDBMS = (O + R) * DB * MS. On a logical level, an ORDBMS is the MS process methods applied for DB data structure, which is complied with O object and R relational concepts.
AnswerA database has to be persistent, meaning that the information stored in a database has to continue to exist even after the application(s) that saved and manipulated the data have ceased to run. A database also has to provide some uniform methods that are not dependent on a specific application for accessing the information that is stored inside the database.
An RDBMS is a Relational Data Base Management System. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables.
Answerthe difference is dbms has no tables
while rdbms has and also it describes
about the relationships among the tables
dbms for small organisatiions
where rdbms for large amonut of data
Answerthe difference between dbms and rdbms is that it doesn't show the relation while rdbms show the relation and moreover dbms is for small organisations where rdbms for large amount of data
AnswerIn DBMS all the tables are treated as different entities. There is no relation established among these entities. But the tables in RDBMS are dependent and the user can establish various integrity constraints on these tables so that the ultimate data used by the user remains correct.
AnswerIn DBMS there are entity sets in the form of tables but relationship among them is not defined while in RDBMS in each entity is well defined with a relationship set so as retreive our data fast and easy.
AnswerIn DBMS tables are not related. In RDBMS tables are related
In DBMS only one user can access the same database, at the same time. In RDBMS many users simultaneously access the same database
RDBMS is more secure than DBMS
In DBMS store and retrieve small amount of Data In RDBMS store and retrieve large amount of Data
AnswerDBMS :
- Set of data and tools to manage those data. - Will not support RELATION SHIP between data. - Ex : - Foxpro data files and earlier Ms Access.
RDBMS :
- Same as DBMS - Will Support RELATION SHIP between Tables. - Ex : - ORACLE,SQL 2000,DB 2 ...
Answerdbms support 6 rules which were proposed by the developer of dbms and where as rdbms follows 8 rules which were proposed by the developer of rdbms.
Answer1. dbms is a single user system rdbms is a multiuser system 2. dbms stores do not store data in the form of tables while rdbms stores it in the form of tables. 3. most of dbms are not supporting client/server architecture as it is supported by rdbms. 4. most dbms do not support distributed databases
DBMS - Database MAnagement System
Different types of dbms
1.DBMS simple databses management system , dbms does not support codd rules more than 5/6 rules.
2.RDBMS like sql server,mysql . Rdbms support more than 7 codd rules
3. ORDBMS like oracle 9i or later version
Answer:
DBMS refers to DataBase Management System
and relatioonal data structure is the way of organizing the data stored so that each attribute is related to one another and that's y they are used for geographic information storing purposes.
Answer
A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of the database in a computer platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists. DBMSs may use any of a variety of database models, such as the network model or relational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. It helps to specify the logical organization for a database and access and use the information within a database. It provides facilities for controlling data access, enforcing data integrity, managing concurrency controlled, restoring database.
Answerwell, DBMS differences depends upon many aspects likewise: Vendors, Security, Easy to access(UI) etc..according to my opinion based on security ORACLE is far better than others..
What is file oriented approach and database oriented approach?
The file is store the data as document type, we don't have give particular data-type of data which will be store in it.
But in database system there are specified structure (like in table format) of data store. First we have to make format with particulate data-type for the data, which will store in it.
other
The file has no record system, while database system store data with record in row, it is easy to maintain.
How do you recover deleted AIM profile pictures?
Contact AOL, although i doubt it is possible to recover.
What is the purpose of a table in a database?
to hold information of different domain. without it, all data would have been scattered around every fields. it would have been a choase
istiak
www.databizsoftware.com
What are the advantages of using database system instead of file system?
1. Redundency of data means some information may be duplicated in several places in file processing s/y .this can also be refined through DBMS.
2. Accessing of data is difficult in file processing s/y .to access the different data
we requried different program many times in other word for different type application requried different application program .
3. Multiple user can access the same data in DBMS.
4.Security also provided by DBA(Database adminstraror).
A visual way to represent a database is with?
One way is to have a very large piece of paper.
Write a program in c language to add two numbers?
//program to add two numbers
#include<stdio.h>
#include<conio.h>
void main()
{
int a,b,c;
clrscr(): //its prototype or header file is conio.h
printf("\n enter first number :"); //its prototype or header file is stdio.h
scanf("%d",&a); //its prototype or header file is stdio.h
printf("\n enter second number :"); //its prototype or header file is stdio.h
scanf("%d",&b); //its prototype or header file is stdio.h
c=a+b;
printf("\n the sum of two numbers is :%d",c); //its prototype or header file is stdio.h
getch(); //its prototype or header file is conio.h
}
Example of open source appication software?
Examples of open source software
- Linux (see http://www.linux.org/): a computer operating system and kernel originating as a UNIX system and existing in many versions.
- GNOME (see http://www.gnome.org/): a desktop development environment providing tools for developing desktop applications (as well as its own basic desktop applications) and available for Linux and other UNIX systems.
- KDE (see http://www.kde.org/): another desktop development environment.
- Apache (see http://www.apache.org/): a web server program (for supplying pages in response to requests) used in most web server computers and available for Windows as well as Linux and other UNIX systems.
- Firefox (see http://www.mozilla.org/firefox/): a web client program (for viewing and hearing web pages) available for Windows and Mac as well as Linux and other UNIX systems.
- Dovecot (see http://www.dovecot.org/): an email server program (for sending and receiving email) supporting POP3 and IMAP and available for Linux and other UNIX systems.
- Postfix (see http://www.postfix.org): an email server program (for sending and receiving email) supporting SMTP and available for Linux and other UNIX systems.
- SquirrelMail (see http://squirrelmail.org/): an email application (for reading and writing email through a web client program) supporting IMAP and SMTP and available for Windows and Mac as well as Linux and other UNIX systems.
- Thunderbird (see http://www.mozilla.org/thunderbird/): an email client program (for reading and writing email) supporting POP3, IMAP and SMTP and available for Windows and Mac as well as Linux and other UNIX systems.
- OpenOffice (see http://www.openoffice.org/): an office application set (for word processing, spreadsheet manipulation, picture drawing and data base access) compatible with all other major office application sets such as Office and available for Windows and Mac as well as Linux and other UNIX systems.
- KOffice: (see http://www.koffice.org/): another office application set.
- Asterisk: (see http://www.asterisk.org/): a Private Branch eXchange (PBX) providing features such as interactive voice response, conference bridging and call queuing (as well as analogue, digital and VoIP telephony), supporting H.323, SIP and IAX2 (and other VoIP protocols), and available for Mac as well as Linux and other UNIX systems.
- FreeSWITCH (see http://www.freeswitch.org/): a VoIP development environment providing tools for developing applications like phones and switches, supporting H.323, SIP and IAX2 (and other VoIP protocols), and available for Windows and Mac as well as Linux and other UNIX systems.
- GnuGK (see http://www.gnugk.org/): a VoIP gatekeeper (for some H.323 deployments) available for Windows and Mac as well as Linux and other UNIX systems.
Why is delegation an important management concept?
No one person can do it all. It is important to share the work around and to make sure that subordinates can do the work and the business can functions when the management are not there, on holiday or leave the organisation. It is important to consider succession planning and to look at growing some of your next managers from within (otherwise your best staff will not see any promotion opportunities). It is a good way to provide on the job training and to see what people are capable of outside their day job. It is good sometimes to have new ideas and not just rely on the same old faces. Some jobs are best suited to certain people and that is the way organisations should run. People can feel appreciated when they are given other roles.
One important point to keep in mind is that delegation is no excuse for abdication. Making someone responsible for an aspect of the management of the business is a fantastic way to build the skills base of the company and enhance the loyalty of employees. The downside is that sometimes, managers see delegation as just get on with it now that you have the responsibility but a good manager will still keep up to date on progress rather than just abdicating responsibility. Get the balance right and a business can fly.
What is the difference between DBMS and Data warehouse?
A DBMS is a Database management System, it consists of the tools needed to access or build a database. A Data Warehouse is merely a collection of data from one or more sources collected together to enhance the the activities of data mining, which is performed with a DBMS or a RDBMS*.
*Relational Database Management System
What is web enabled data warehouse?
See also questions on Data Warehouses.
Adding a web interface to a database provides a standard interface that allows users to query the database using a wide range of very different computer platforms.
It is a low cost development solution, as web interfacing is now a well developed technology with many different vendors offering solutions and development tools.
Anything that a database can do can be controlled or performed through a web interface.
Role of data mining in e-commerce?
Statistical Analysis and Goal Seeking -- IE, how many people read my answer I posted to this question today? Or next week? Or... Well, the point is to find out something about the 'commerce' itself, this will hlp you create better commerce in the future.
How big bazaar use data mining?
Sql query to list all the constraints in the table?
SELECT * FROM user_constraints WHERE table_name='TABLENAME';
NOTE : Here TABLENAME should be in UPPER CASE LETTERS
Spss 16 license code?
Please buy a product license code from SPSS company or their authorized distributor.
What does the word procedure mean in science?
the word procedure in science is talking about the steps taken or used in a particular class, lab or experiment that the teacher wants you to show him or her
What is basic terminology for data structure?
its a way in which u order ur data items in memory for easy retrieval again
What is the purpose of a form in access?
A form is a simple way to display data for a number of users. Setting up a form correctly can increase the speed users work at.
Can anybody send you er diagram for hostel management system?
yes
Does Windows 7 support Oracle 9i?
Yes. Download the Oracle instant client (or other versions) from Oracle's website.
What is the importance of relational database?
Importance of relational database
----------------------------------------------
Relational databases can be considered as stores of information grouped together logically. Relational databases are used in all data related jobs. Especially in today's world of information, relational databases have increased importance, since they are used to store, manage, and retrieve data in a managed, organised and logical way. More information on relational databases, and their importance, can be found in detail here: http://tinyurl.com/relationaldatabase
Is it possible to change the data type for a field that already contains data?
You can change the data type of an existing field using a union, however, you should understand that bit format dependance is not portable usage, and that you should initialize the field every time you change your desired type.
Answer: without specifying the context, this question cannot be answered.
Advantages of vector data models over raster model?
• Data can be represented at its original resolution and form without generalization.
• Graphic output is usually more aesthetically pleasing (traditional cartographic representation);
• Since most data, e.g. hard copy maps, is in vector form no data conversion is required.
• Accurate geographic location of data is maintained.
• Allows for efficient encoding of topology, and as a result more efficient operations that require topological information, e.g. proximity, network analysis.
• Compact data structure; requires less space to store data
What is cardinality ratio?
In mathematics, the cardinality of a set is a measure of the "number of elements of the set". For example, the set A = {2, 4, 6} contains 3 elements, and therefore A has a cardinality of 3. There are two approaches to cardinality - one which compares sets directly using bijections and injections, and another which uses cardinal numbers.
What is a first-in-first-out data structure?
Hi,
In terms of a set of objects, the frist-in-first-out approach consists in that the first object to have been added to the set will be the first to be let out. Such a structure would provide you with at least two basic operations: to add objects in, and to get objects out. And a structure built along this approach would not allow for the possibility of letting you choose which object to retrieve: the objects get out in the order they got in (or were put in, to be more specific).
A classic illustration and representation of this approach would be that of a tube the size of the objects you put in. You can add the objects only at one end, and get the objects back only at the other end. This way, you see that there is no way to get the objects in between. Of course, the size of the structure is not necessarily as limited as that tube, and depends on the implementation.
.
Valentin Laurent
