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
Relationship between a database and a table?
A table is contained within the database and consists of columns and rows. A table is meant to store data and, in relational databases, are related to other tables within the same database.
Starvation refers to the use of all resources. As an example a poorly constructed database, poor concurrency controls will result in dbms starvation as usage increases. In effect the database subsystem is STARVING for resources because all available resources are being consumed. As a result you will see a severe degrade in performance.
How do you insert data to a database using a PHP form?
You will need a table first, this can be created via your Database - PHPMyAdmin,
- So, the first step would be to go to your Control Panel for your website, down to PHPMyAdmin and then to the database you are going to be creating the table in
- Once there, you should see an option at the bottom of your page, not in the left hand menu. 'Create new table on database NAMEOFDATABASE'
- Name the table, Remember, names of tables shouldn't have spaces, use underscores if you need a space. You will also need to input the amount of fields.
- Once the fields are correctly named and whatnot, you can start thinking about inputting data into the table.
- Go to your page editor for a php file you should have created. You should know a little about PHP if you're wanting to input items with PHP, so, let's get to Inputting.
Inputting data in PHP - MySQL
- Say you've created a registration form, you have all the fields filled out correctly for the person to Register their details, now you need a way for your website to remember that they are now a member right?
- The table you should have created in your database is a users table, with fields for the Username, Password (which remember, should be set to MD5 in it's function setting), the gender of the Registering user and their Email address. (4 fields altogether then.)
- Once you have created variables, query checks for the items that need it and MD5'd the passwords, a query is needed to input the details.
e.g
mysql_query("INSERT INTO `users` VALUES('$name','$pass','$gender','$email')") or die("Errored due to:
".mysql_error());
This will Input the values into the table you created with the details of the registering person.
Notice that any form element in an HTML page will automatically be available to your PHP scripts.
How is the hex 1234 stored in big endian?
Big endian does not change the ordering, so it is stored as 0x1234
Delete queries are often run after queries have added those same records to history tables?
No, Delete queries are ran before the queries which adds the data to history table. This is to avoid duplicacy.
How much is a database administrator paid?
You will find the answer here: http://www.bls.gov/oco/ocos042.htm#emply
What does Record mean in database?
Record holds data about one object with its attributes specified in table.
What advantage do reports have over printed forms in database?
Reports allow you greater flexibility in grouping and summarising data compared to printed forms.
Explain the centralized DBMS architecture in detail?
combines everything into a single system including, DBMS software,hardware, application programs and user interface
Foreign dependency is when a country relies on another country, for example for money, jobs, food etc.
How do you calculate the number of necessary games for a round robin tournament?
Round robin play involves each entry playing all other entries. For example if you have 4 teams entered, each team plays all the other teams or 3 games each for a total of 12 games played.
If you have larger number of teams, split them up into pools. Ie. 12 teams 3 pools of 4 each team playing 3 games. You then can take the top 2 best records from each pool and put them into a championship pool so you would have 6 teams playing 5 games each and the eventual winner would be team with best record.
Can a database only be stored on a computer?
No, it can in fact be stored in a file outside of a computer...what boff wants to know that!?
the compexity of linear search in worst case is f(n) = n+1
A database is a collection of data. It should be integrated , consistent , non- redundant , durable and atomic in nature.
Integrity constraints in dbms?
The term integrity means to correctness and completeness of the data in data base. A relational data base is collection of related table. Table contains various information. Tables are connected by the foreign key relationship. When the contains with the certain command, insert, delete, update.The integrity of the data can be loss in many different waves.
What is a keyed vs sequential?
Keyed and sequential refer to two different methods of data access in computing. Keyed access allows data to be retrieved using a specific identifier or key, enabling direct access to a particular record. In contrast, sequential access requires reading through data in a specific order, typically from the beginning to the end, making it less efficient for finding specific records. Keyed access is often used in databases, while sequential access is common in file systems and data streams.
File management system in dbms?
it was the first method used to store data in a computerized database here each field or dataitem is stored in a disk sequencily in one large file.
art by mvs
