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
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.
Why are tables the foundation any database system?
Because the database is the collection of data / information.And the table holds these information in separate form so we can say that the tables the foundation of any Database System.......
What could be used in stead of a table to enter records?
Data is stored in tables, there is nothing better to hold the data. Instead of entering data directly on a table, it is better to use a form which can give you more control through data validation to help make sure accurrate data is stored. You can also use code behind the forms to perform calculations and enter data on multiple tables.
Is Data mining is the process of searching huge amounts of data with the hope of finding a pattern?
true
Record
What are the advantages of seigneurial system?
The seigneurial system offered several advantages, particularly in medieval Europe. It provided a structured social hierarchy, enabling lords to manage land and resources efficiently while granting peasants access to land in exchange for labor and dues. This system fostered agricultural productivity and local economic stability, as lords could invest in improvements while peasants benefited from protection and communal support. Additionally, it facilitated the development of local governance and community ties, as lords often acted as judges and protectors of their vassals.
Data Hierarchy refers to the systematic organization of data, often in a hierarchical form. Data organization involves fields, records, files and so on.
A data field holds a single fact. Consider a date field, e.g. "September 19, 2004". This can be treated as a single date field (e.g. birth date), or 3 fields, namely, month, day of month and year.
A record is a collection of related fields. An Employee record may contain a name field(s), address fields, birth date field and so on.
A file is a collection of related records. If there are 100 employees, then each employee would have a record (e.g. called Employee Personal Details record) and the collection of 100 such records would constitute a file (in this case, called Employee Personal Details file).
Files are integrated into a database. This is done using a Database Management System. If there are other facets of employee data that we wish to capture, then other files such as Employee Training History file and Employee Work History file could be created as well.
The above is a view of data seen by a computer user.
The above structure can be seen in the hierarchical model, which is one way to organize data in a database.
In terms of data storage, data fields are made of bytes and these in turn are made up of bits.
Are Highly structured and organized data is stored in database files?
are structured and organized data stored in database files
Does a relational database store data in the form of a list?
A relational database stores data in the form of TABLES.
What are the potential cost of implementing a database system?
5. What are the potential costs of implementing database?
When implementing a system, the cost is a very area that should be considered as well after determining it requirement, alpha and beta test are passed upon implementation it cost should had been considered. In this case of database it implementation cost includes hardware, software , maintenance and location are the regular database implementation dimension.
Ø Hardware: We need something for it to live on. This could either be bought, or hired.
Ø Maintenance: The system will at some point require updating - costs of this will need to be considered. There will also be essential maintenance from time to time although this may be covered under your contract if you get an external company to do it for you .If you own the hardware then you will also have to consider staffing to do the maintenance part - does your team have the skills or do you need another.
Ø Software: Lots of free software lots of expensive software - what are we going to use and what the best for the job are for it.
Ø Location: In the location, where and which part the earth should our system be operates from is very import, though in the case of database technologies most are hosted online in the means one can operate from anywhere or part of the earth. But is very important to consider the location of system source.
By Enebeli Edwin Ndudi
Unisel-Malaysia
What is the difference between triggers and cursor in sql server?
In SQL Server, a cursor is the actual set of records retrieved by a query. Once declared as a cursor, the set of records can then be manipulated one by one. A trigger is a set of statements that is set to execute only when a certain action occurs, for example, whenever the last name on a table is updated.
Does primary key allows null value?
No. A primary key requires a value because it is the field that all other values in the row depend on.
How responsibiliies of database administrator can be implemented?
Sorry we do not know what you mean by "responsibiliies".
and if you meant this word to be "responsibilities", then I am afraid the question itself does not makes sense.
If you meant you question to read "How can the responsibilities of a database administrator be implemented" then the answer would be :-
By hiring a database administrator.
I hope this illustrates for you the importance of taking the time to make sure that your question is asked clearly because those of us that answer questions for people cannot do so if people do not make their questions clear and unambiguous.
Is Quickbooks a relational database?
Sometime in 2011 or 2012 Intuit upgraded QuickBooks, replacing its flat file system with SQL Anywhere from Sybase iAnywhere, allowing QuickBooks to store data in a relational database format.
How to define a user defined function in SQL?
Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.
Who are the people involved in DBMS?
IBM, Administrator, developers of the codes, these who use the applications of code,..
How do you know if you need a relational structure'?
When you have repeated data and/or you need to track actions or events
