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 does data mining mean and how is it done?
Data mining is a computer science which extract patterns in data sets. It can be used to predict which people are most likely to respond to a sales offer or what type of garment is preferred by a certain type of customer.
The term data mining is generally known as the process of analyzing data from many different perspectives in order to correctly organize the data. Sometimes data mining is also called knowledge dicovery.
How can you start a career in data security?
First you'll have to study the career, if you're still wanting to continue, proceed to talk to people already in the field, begin to acquire the necessary skills if you don't already have them and apply to jobs.
Would it be a good idea for a small firm to outsource database management?
It would be a great idea for a small firm to outsource a database management because you can keep records easily, and when you need to find something, it's all in the database.
What are some specific uses for database management software?
Such software does several things. Most basic is that it recives and proceses requests to access the data contained in a database and returns results for those queries. It also ensures that only those with permission to access the data may do so. You could use it to store bits of programming or accounting data for a company or for yourself.
What are the benefits of using a database management software?
A database management system allows companies and organizations to create,modify,and retrieve databases.It is the best way to manage customer databases effectively. It relates data on different terminals so personnel can be linked up,which also decreases data duplication.Database management systems usually offer multiple checks for data validity,and can increase the speed in which complex requests are completed.
What is a good database management software?
A good database management software that is out there today is NonProfitEasy. It is the only software that is program-centric meaning that in one click you can see a 360 degree overview of any program and everything that is associated with it. You can see donations associated, volunteers activities, volunteers interested, volunteer hours, events, beneficiaries, etc.)
Designed by nonprofits, NonProfitEasy™ helps nonprofits develop and manage stakeholder relationships (volunteers, donors, members, staff, board, foundations, government agencies, service partners) within one simple, integrated application.
How can you get off direct mail marketing databases?
The Direct Marketing Association's (DMA) Mail Preference Service (MPS) makes it possible for you to remove yourself from many (but not all) direct mail marketing databases for approximately five years. To register with DMA's Mail Preference Service, mail your request with a $1 fee to:DMAchoiceDirect Marketing AssociationP.O. Box 643Carmel, NY 10512
What are the objectives of database management systems?
Shareability: An ability to share data resources is a fundamental objective of database management. In its fullest interpretation, this means different people and different processes using the same actual data at virtually the same time. Rather far reaching ramifications stem from the stated objective of shareability:
- - Serving differently types of users with varying skill levels
- - Handling different user views of the same stored data.
- - Combining interrelated data
- - Setting standards
- - Controlling concurrent updates so as to maintain data integrity
- - Coordinating restart and recovery operations across multiple users.This list indicates some of the additional problems which arise in managing shared data. A central implication of sharing is that compromise will often be required between conflicting user needs as, for example, in the establishment of a data structure and corresponding storage structure.
The bulk of organization data, as traditionally handled in accounting systems, lied in the enclosed region of historical, internal, financial data. A database management system must be capable of reaching beyond this region to handle greater diversity in the data stored, including subjective data, fragmentary marketing intelligence data, uncertain forecasts and aggregated data, as well as factual marketing, manufacturing, personnel and accounting data.
Evolvability: Evolvability refers to the ability of the DBMS to change in response to growing user needs and advancing technology. Evolvability is the system characteristic that enhances future availability of the data resources. Evolvability is not the same as expandability or extensibility, which imply extending or adding to the system, which then grows ever larger. Evolvability covers expansion or contraction, both of which may occur as the system changes to fit the ever changing needs and desires of the using environment.
Adaptability is a more advanced form of evolvability in which built in algorithms enable a system to change itself, rather than having a change made to it. Adaptability involves purposive, self organizing, or self controlling behavior, that is, self regulation toward a single criterion of success: ultimate, long-term survival. A system exhibiting adaptive behavior actively seeks a particular state or goal by changing itself in response to a change in itself or its environment. Evolvability implies the gradual unfolding, development and growth of a system to better meet the needs of the using environment: and it implies change of the system in response to changing needs and technology. With the present state of technology, such change is externally administered. In the future such change may occur automatically within the system, thus exhibiting adaptive behavior.
Integrity: The importance and pervasiveness of the need to maintain database integrity is rooted in the reality that man is perfect. Destruction, errors and improper disclosure must be anticipated and explicit mechanisms provided for handling them. The three primary facets of database integrity are:-
- protecting the existence of the database
- Maintaining the quality of the database
When a database table has a key which consists of more than one field, a partial key refers to any one of those fields.
Transaction Log
It is Database Management System.
Database : Database is a well structured format to store data like Files, Tables, Excel sheets etc.
Database Management System : It is a package of software which control the creation, maintenance, and the use of a Database. It allows organizations to conveniently develop databases for various applications by Database administrators (DBAs) and other specialists. A database is an integrated collection of data records, files, and other database objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models such as relational model or object model.
What term is used to refer to the data that are used to describe the data in a database?
Data definition is the term used to describe expected data value.
varchar
What is the need for aggregation?
Aggregation is an important concept in database design where composite objects can be modelled during the design of database applications. Therefore, preserving the aggregation concept in database implementation is essential. In this paper, we propose models for implementation of aggregation in an Object-Relational Database Management System (ORDBMS) through the use of index clusters and nested tables. ORDBMS is a commercial Relational Database Management Systems (RDBMS), like Oracle, which support some object-oriented concepts. We will also show how queries can be performed on index clusters and nested tables.
What is the meaning of can manipulate data?
The phrase "can manipulate data" refers to the ability to change, organize, or analyze data in various ways to extract meaningful insights or perform specific tasks. This may involve using software tools or programming languages to sort, filter, aggregate, or visualize data. Data manipulation is essential for tasks such as data cleaning, transformation, and analysis in fields like data science and analytics. Ultimately, it allows users to derive valuable information from raw data.
Can you add new columns to a database after creating the structure?
Columns are added to a table, not a database (which is a collection of tables). Adding a column to a table is achieved by using the Alter Table SQL command.
Is SQL An application to manage Data in a database?
SQL is a language broad term to define a type of database. More specific ones are My SQL (open source) and MicroSoft SQL
What is Naive end user in dbms?
These are the users who communicate with the database on the daily bases ( at regular period) Their main job is to constantly querying and updating the database using the standard queries.this is called canned transaction. Examples are bank-teller and reservation clerks.
What is the difference between Primarey key and Forn Key?
establishing a relation between two tables called fornkey.......the colum name should be unique is called "primary key"...a table contain only one primary key...a table contain more then one fornkey....
What is the benefit of float data type?
Floating type numbers can't be stored in integer type variables. If we do that then their fractional part will be lost. So, we use float data type to store numbers with fractional parts.
What is a super key in database?
S a subset of A, is a super key if S -> A.
That is, the combination of all attributes in S, determines all attributes in A.
Example:
R(studentNo, firstName, lastName, course, instructor)
FDs:
studentNo -> firstName, lastName, course
course -> instructor
Is studentNo a super key?
Yes, because studentNo yields the attributes firstName, lastName and course and course yield instructor. So with studentNo as super key, we are able to retrieve all the other attributes in relation R.
Is course a super key?
No, because we can only retrieve the instructor attribute and nothing else.
