0
What else can I help you with?
What are the things to be learned for web developing?
You need to learn some programming/scripting languages and learn how to use a database. I have given examples below. Programming/scripting languages: - HTML - PHP - Javascript Database: -PostgreSQL -MySQL
What is database management tool?
it is used in Mysql which is a program used for programming. It helps in managing and analysing the given data and is mainly used when there is large amount of data to be analysed!!
What is query in mysql?
Query is any command given to My Sql
What are the various reasons that lead to the occurrence of NULL values in relations?
A given field in a database table might be for a values that, in certain case, no such values exist or can be determined. For example, in an employee database, a field might be a foreign key to that employee's direct manager. However, in the case of the CEO, there is no such person. In that case, the field would be set to Null.
Data base state vs database schema?
The database schema is the description of the database. It defines how the database is set up and what data it is to contain and control. This description is given to the DBMS to manage the data. The database state is an image of how the database looks at any given time. The database schema is set unless you change how the database is structured. The database state will change whenever new data is entered into the database and the database is updated.
What is structural database design?
The logic structure is independent of any kind of data model,in the practical application, the general database used by theenvironment has given (such as SQL Server or Oracel or MySQL. Due to the current use of the database basically is relational database, so the first thing to the E-R diagram into relation model, and then according to the characteristics andlimitations of specific DBMS conversion for the specificsupport of DBMS data model, the final optimization
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 DCOUNT?
DCOUNT is like COUNT, except that it works on an Excel Database or List. It returns the number of cells in a column or or a field of a database that contains numbers and meets a given criteria. It needs the full list or database, a specified field to count values from and criteria that uses one or more fields.
What is the range of database application?
The range of database application are given below: 1- Personal Database 2- Workgroup Database 3- Department Database 4- Enterprise Database
Why null values in database?
The 'null'-content of any given field is just that. It's a 'nothing'. Example, if you create a database to hold chemical values for instance. If the values are, for example, real nubers. That would imply that any value that has 0 in it, is just that; zero. It was beeing measured, and found to contain zero. On the other hand if a value was not tested, the value of that compound should be set to 'null'. If a 'null' value isn't supported by the database a workaround is to set 'null' values to -1 (as per the example above). --
Disadvantage of temporal database?
temporal database is concept related to database store for a given timestamps so there is more storage required of storage media then simple conventional database.
What is relation instance in DBMS?
In DBMS, a relation instance refers to a particular set of data rows within a database table at a given point in time. It represents the actual values stored in the database for that specific table. Each row in a relation instance corresponds to a record or tuple within the table, containing values for each attribute.
