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
It's real time 3 tier architecture, where the SAP central database stored.
What is the advantages of management control system?
Management Control System asists the operator in doing multi-tasking works, so as to concentrates on a more priority task. The task performed are from a previous operation that are stored in the data memory.
Data Warehousing is the process of unifying data from multiple data sources under a single unified schema. A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process.
Is it possible to access the private variable in CPP from outside the class?
Private variables can only be accessed from outside of a class by using any public function of that same class. Or this can be accomplished by using Friend functions.
What is the difference between a programming language and a database?
Programming language is to develop an application where a database is a place at which we can store the data about any objects and a software which maintains this database is called DBMS.
What are the benefits of normalizing a table in a database?
The following are some of the benefits of normalization:
removes redundancies
achieves consistency.
improves data accessing speed
improves the performance of the server
decreases time accessing from the database.
generally efficient working of the application
Normalization was introduced just to have CONSISTENT Data by avoiding REDUNDANCIES. While doing so, it introduces some overhead by having few new tables which definitely has an impact over PERFORMANCE and SPEED, because of involving many tables in the JOIN operation which itself proves the complexity. In short, you can prefer normalization for having Consistent and Clean Data with the cost of Performance and Speed.
What is a good Enterprise Resource Planning system for small companies?
Quickbooks is typically pretty simple.
Guess you'll need a relay. Hook it too the battery for 12V.
What is the testing procedure for the Save dialog box of Notepad?
You are in notepad. You are ready to save your file. All you have to do to direct your file to the directory you want it to go to instead of the default, is choose "save as" under "file". Either choose an existing directory or create a new one. You can name the file anything.
What are the different types of databases?
There are presently two types. (A) Analytic Databases - read only and used to store archived data for analysis work and (B) Operational Databases - Operational databases - Theseallow you to modify the data (add, change or delete data).
These types of databases are usually used to track real-time information. For example, a company might have an operational database used to track warehouse/stock quantities.
DB2 is a family of relational database management system (RDBMS) products from IBM that serve a number of different operating system platforms. According to IBM, DB2 leads in terms of database market share and performance. Although DB2 products are offered for UNIX-based systems and personal computer operating systems, DB2 trails Oracle's database products in UNIX-based systems and Microsoft's Access in Windows systems.
How can you store pictures on SQL Database?
In short, the SQL database column has to be defined as either an image column or a binary column (SQL2k) In earlier versions, 6.5 & 7, they should have been defined as a BLOB (Binary Large Object). A more precise answer can be given if you supply additional information such as DB version, programming langauge used.
**
As explained here you can store images within SQL server however I would not recommend this.
In doing so you will bloat the database dramatically, and the reconstitution of the images when recalled from the database is a big performance hit.
I would recommend storing the images within the file system (saved to your hard drive as normal) and linking the images to a database record by defining a column that hold the path and file name to the image.
In doing so your database overhead is simply that field and not the entire image.
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..
How a vehicle is owned depends on how it is titled. Generally if it is titled "John Doe and Mary Smith", each person owns the vehicle equally and must be given equal rights of the use. If the title reads "John Doe or Mary Smith" each person owns the entire vehicle and whomever has possession cannot be forced to relinquish the vehicle except via legal procedures. States enact laws that govern ownership of vehicles, contacting the state DMV should give more specific information.
How do you draw DFD for pharmacy management system?
Contex level,0 level,first level DFDs for hospital management system
In what field are the latest medical inventions?
In most medical fields scientists are constantly introducing new developments . It is probably in the field of Radiology and Imaging where most technological inventions have appeared in the latest years, but from laboratory technologies up to nuclear medicine, all large and small branches of medicine are constantly evolving in technology and systems.
Example er diagram for hospital?
how to draw e-r diagram for hospital management system plz show the figure?
What are Database of a hospital management system?
Hospitals have to store a lot of data, like data about patients, staff, supplies, appointments, surgery, medication etc. To maintain and process all of this data and provide the information they need to run the hospital it is essential that they have databases.
the series of steps taken in order to carry out an experiment
DDL stands for Data Definition Language, and so it follows that creating a table is DDL, creating a view is DDL and so on.
How do you accept hotel reservation?
Hotel reservations can be accepted via phone or online at the hotel website. Some third party discount companies also can accept hotel reservations. A debit or credit card may be needed at the time of the reservation.
