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.

Database Programming

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".

Answer

DBMS 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.

Answer

1)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

Answer

The 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.

Answer

ORDBMS = 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.

Answer

A 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.

Answer

the 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

Answer

the 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

Answer

In 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.

Answer

In 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.

Answer

In 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

Answer

DBMS :

- 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 ...

Answer

dbms 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.

Answer

1. 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..

567568569
Answer
Computer Programming
Database Programming
The Difference Between

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.

405406407
Answer
Computers
Database Programming

How do you recover deleted AIM profile pictures?

Contact AOL, although i doubt it is possible to recover.

343344345
Answer
Software and Applications (non-game)
Database Programming

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

336337338
Answer
Microsoft Windows
Database Programming
Hard Disk Drives

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).

333334335
Answer
Database Programming

A visual way to represent a database is with?

One way is to have a very large piece of paper.

328329330
Answer
Database Programming
C Programming

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

}

325326327
Answer
Software and Applications (non-game)
Computer Programming
Database Programming

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.
325326327
Answer
Business Plans
Database Programming
Project Management

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.

321322323
Answer
Computers
Database Programming
The Difference Between

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

315316317
Answer
Web Design and Publishing
Database Programming

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.

314315316
Answer
Database Programming
eCommerce

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.

313314315
Answer
Database Programming
Mining

How big bazaar use data mining?

332333334
Answer
Database Programming
MySQL
Oracle Database

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

299300301
Answer
Database Programming
Internet

Spss 16 license code?

Please buy a product license code from SPSS company or their authorized distributor.

311312313
Answer
Database Programming

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

307308309
Answer
Computer Programming
Database Programming
C Programming

What is basic terminology for data structure?

its a way in which u order ur data items in memory for easy retrieval again

303304305
Answer
Database Programming
Microsoft Access

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.

295296297
Answer
Database Programming
Hostels

Can anybody send you er diagram for hostel management system?

yes

297298299
Answer
Database Programming
Windows 7
Oracle Database

Does Windows 7 support Oracle 9i?

Yes. Download the Oracle instant client (or other versions) from Oracle's website.

287288289
Answer
Database Programming

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

291292293
Answer
Database Programming
C Programming

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.

283284285
Answer
Database Programming
Computer Aided Design

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

283284285
Answer
Database Programming
Math and Arithmetic

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.

283284285
Answer
Computer Programming
Database Programming
C Programming

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

281282283
Answer

Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.