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
HTTP Header attack
What is the relation between access and database?
Access is no security
Database has security
limited data can store in access
we can specify the size and file growth. we can store n number of data's
only primary key can specify in access.
but in database we can specify primary key as well foreign keys and other keys.
What are the reasons for the continued growth of online Transaction processing?
The reason behind OTP is that it is time efficicent.After OTP log file will be generated and which can be used 4 easily data recovery in case of system crash.example of OTP is ATM ,chek clearing system used in bank.
Placid04
BIHAR ,INDIA
How might the police use a database?
so they can track people down and find out their contact details.
hope this helped :)
- sajida
Which tool is used to create a query object?
a computer, a keyboard, oh and you might need a brain too
How would you respond appropraiately to problems with database tables?
check data:spell check, format,accuraacy,consistency.
dml processor process the dml statements such as select,update,delete etc that are passed by the application programmer into a computer program that perform specified task by programmer such as delete a table etc.
How to improve bookshop manual system?
To improve a bookshop manual system, consider digitizing records for easier access and organization, implementing a barcode system for tracking inventory accurately, and utilizing a customer relationship management (CRM) software to track customer preferences and purchasing habits. Additionally, conducting regular audits to ensure accuracy and updating the system based on customer feedback can help improve efficiency.
What is the importance of management information systems?
Management Information Systems are important because they provide information that supports operations, management and decision-making functions in an organization.
Where to use database approach?
ADVANTAGES
- Provide very efficient "High-speed" retrieval
- Simplicity
The network model is conceptually simple and easy to design.
- Ability to handle more relationship types
The network model can handle the one-to-many and many-to-many relationships.
- Ease of data access
In the network database terminology, a relationship is a set. Each set comprises of two types of records.- an owner record and a member record, In a network model an application can access an owner record and all the member records within a set.
- Data Integrity
In a network model, no member can exist without an owner. A user must therefore first define the owner record and then the member record. This ensures the integrity.
- Data Independence
The network model draws a clear line of demarcation between programs and the complex physical storage details. The application programs work independently of the data. Any changes made in the data characteristics do not affect the application program.
DISADVANTAGES
- System complexity
In a network model, data are accessed one record at a time. This males it essential for the database designers, administrators, and programmers to be familiar with the internal data structures to gain access to the data. Therefore, a user friendly database management system cannot be created using the network model
- Lack of Structural independence.
Making structural modifications to the database is very difficult in the network database model as the data access method is navigational. Any changes made to the database structure require the application programs to be modified before they can access data. Though the network model achieves data independence, it still fails to achieve structural independence.
Read more: The_advantages_and_disadvantages_of_database_network_model
What is online payment management system?
Online payment management system is usually a software that automates the management of online transactions (payments.) So instead of dealing manually with Paypal or banks if payments went through and confirming it to customers, certain software (like Blue Snap) do all these in a matter of seconds. In addition, it also sends a confirmation email to merchants that payment has been made. The software also automates currency conversion, depending on its feature.
What is generalization in database?
Generalization means to categorize some things in to a general category . In database also generalization means the same. Consider an example like Car and Motorcycle can be categorized in to one general category VEHICLE .
Having one database streamlines data management, reduces redundancy, and ensures consistency across the organization. It simplifies data access and retrieval, enabling users to work from a single source of truth, which enhances collaboration and decision-making. Additionally, maintaining one database can lower operational costs and improve data security by minimizing the complexity of managing multiple systems.
What criteria are important in choosing a file organization?
file volatility, file activity, file size, file queries, data currency
What are the advantages of mysql database management system?
The fact that it is free is its biggest advantage over programs like oracle. Its also easy to use and very well trustworthy. Its great for small businesses that dont plan to generate alot of traffic
Can super key be as primary key?
I think super key is treated as the primary key because in a table their will be only one primary key.
What is the difference between file base system and data base system?
DBS has more security and data integrity.It reduce data redundancy and updating errors which can occur in FBS.Contains of concurrent data access.But also it's expensive to use and they are also complex.Damage to DB affects virtually all application programs.
Why would you want to override automatic query optimization?
Sometimes, the query designer may know information that can be overlooked by the query optimizer. Often, in the course of testing queries, one may find that it is actually faster not to use a certain index or to use a different index. When this is the case, database management systems such as Oracle include a facility to override the query optimizer, called query hints.
