0
What else can I help you with?
Why data integrity is important to a database?
The data integrity is important in a database because it assures that all data in it can be traced and link to other data. This ensures that all the data can be searched and recover. It increases the stability , the performance and the reliability of a database.
A database is made up of related?
A database is made up of related Schemas and Tables. A single database can have multiple schemas and each schema can have multiple tables inside it. All of these can be related to one another using referential constraints like foreign keys.
How do you retrieve data from database in PHP?
There are many factors that must be taken into consideration when looking to retrieve data from a database, such as 'what database management system do i posses/supported by my host?' in most cases people looking to retrieve data using php posses SQL database management systems such as MySQL in their control panel which can be used to create, delete and alter databases, along with creating multiuser access to the databases.once the databases are created and their respected users are added and given their database privileges, one can begin adding and proccessing data to and from a database.assuming that all the previous has been acheived and there is data in the database, below is a set of php/mysql functions that can process multiple rows of data in a database table.$link = mysql_connect ("localhost", "USERNAME HERE", "PASSWORD HERE") or die (mysql_error());$mysql_db = mysql_select_db ("DATABASE NAME") or die (mysql_error());$db_search = mysql_query("SELECT * FROM `TABLE NAME`");if (@mysql_num_rows($db_search) > 0) {while($data = mysql_fetch_array($db_search)) {}}first you connect to your host, then select the database, query a selected table, check for rows of data in the table, place the array of data into a variable, and do what you please with the data now contained within that variable.for more information go to php.net/mysql
What is the difference between flat file and DBMS?
A flat file is a simple file containing data without any structured format, while a Database Management System (DBMS) is a software system that manages databases by organizing, storing, and retrieving data. A DBMS allows for more organized and efficient data management, supports relationships between data, and provides features like security and data integrity that are not available with flat files.
How do you retrieve data stored in the database into the textarea using PHP?
<?php // Connect to the database $link = mysql_connect('localhost', 'mysql_user', 'mysql_password') or die('Could not connect: ' . mysql_error()); mysql_select_db('foo', $link) or die('Can\'t use foo : ' . mysql_error()); // Retrieve the content $sql = "SELECT my_info FROM my_table WHERE id = '42'; $result = mysql_query($sql,$link); // Now assign a value $row = mysql_fetch_assoc($result); // "Wrap" the result in a textarea echo '<textarea name="bob" rows="10" cols="40">'; echo $row["my_info"]; echo '</textarea>'; ?> ... this will work for a single value retrieved from a single row. For a more in depth look at retrieving values from a DB visit: http://au2.php.net/manual/en/function.mysql-query.php For a complete textarea reference, visit: http://www.w3schools.com/tags/tag_textarea.asp Hope that helps
How do you load the data into oracle database to another database?
There are several different ways. If you are going between one Oracle database and another Oracle database you can create a database link. Another method would be an Oracle export to flat file and then a import to another database. This all depends on the type of database you are trying to load the data into.
What is network database?
We know a database is one that stores data related to each other. A network database is just like network database only difference between them is, in network database records are connected by means of a link.
Why data integrity is important to a database?
The data integrity is important in a database because it assures that all data in it can be traced and link to other data. This ensures that all the data can be searched and recover. It increases the stability , the performance and the reliability of a database.
Access is what kind of database?
AnswerMicrosoft Access is a relational database that can run from it's own internal table structure, or link to a variety of external data sources
How do you create a report using VB 6?
You can we the default support provided by vb or use other reporting tools like crystal reports. To use the default support select data report from components. To link the data report to database you will have to include a data environment component, ink the control to the database by selecting its properties and then link this data environment to the data report. You can call the data report the same way other forms are called.
Why would you copy a table from access and paste it as a link in Excel?
It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.
What is remote data?
A remote data object is one that would be located on a different "node". For instance, a node the hardware where the operating system resides, which houses a database. Nodes have IP addresses and names. Say that the main database resided on node "Payroll" (10.128.132.10). Via a database link, an object from another node "Accounting" (10.128.142.11) is referenced. An example of this could be a view which pulls data from a table in the Payroll database and joins it to a table in the Accounting database and the view shows data from both nodes.
What is Remote Data Object?
A remote data object is one that would be located on a different "node". For instance, a node the hardware where the operating system resides, which houses a database. Nodes have IP addresses and names. Say that the main database resided on node "Payroll" (10.128.132.10). Via a database link, an object from another node "Accounting" (10.128.142.11) is referenced. An example of this could be a view which pulls data from a table in the Payroll database and joins it to a table in the Accounting database and the view shows data from both nodes.
What is network data base?
In network database model , the records are related to each other through a link. By a link we mean that it is an association between precisely two records.
What is the largest database size allowed in Microsoft access 2003?
2 GB, but the user can link tables in multiple databases together if a database over this limit is needed.
A database is made up of related?
A database is made up of related Schemas and Tables. A single database can have multiple schemas and each schema can have multiple tables inside it. All of these can be related to one another using referential constraints like foreign keys.
How do you create a database link?
In order to create a database link, the command CREATE DATABASE LINK is used. Depending on the requirement, private or public databases may be created.
