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 do you means DataBase Management System?
A system that allows you maintain and administer a database.
What is computer- based training cbt?
Computer based training (CBT) is a method for training people based round computers.
Courses are prepared for on line access and may involve videos, documents and progress testing.
The advantage is that the training can be taken up by the student at any time without the need for direct supervision.
A good example of good, free CBT is that produced by the KHAN Academy (see link below), but in reality most Universities are also developing CBT courses some of which are free but most of which is charged for.
What are the advantages of using Access for a database?
It's cheap.
Access consists of a decent scripting language on the front end coupled with a lightweight database engine on the back end. It is not scalable, and doesn't work well for more than a single user. What it does have as a benefit is the controlling language and the set of database drivers that allow the scripting language, and many other applications, to talk to the database easily and with a minimum of programming. If the drivers and scripting language are coupled with a well-built database engine, it can be quite useful.
What fields in shopkeepers databases might be used?
Item name
Amount of item being sold
Price of Items.
Why Learning Management System Needed?
Every institute has lots of work which are to be carried in different department and for large number of students It really becomes difficult to manage and keep check on everything for Admin. Not only this managing data for years has become a problem for every institute. Generating reports has also difficult for large number of data. There are several such reasons due to which it is need of every good institute to use the system which can help them in building synergy between institute and students. There are several vendors who are providing excellent service for online LMS like VClassrooming, Blackboard etc.
What is added to a relational database to eliminate many to many relationships?
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
A junction table is added between the two tables involved in the relationship. The primary key from each table is added to the junction table and they are made a joint primary key in that table. Then two one-to-many relationships are set up between the junction table and each of the two other tables.
Which was the first commercial RDBMS?
The first commercial RDBMS was created by IBM and was called the SQL/DS. It was originally released in 1981. RDBMS stands for relational database management system which later became operating systems.
What is a server's physical case?
what is the difference between a server physical case and a client case
Nowadays, simply hashing the database does not provide enough encryption as hackers can run brute forcing software and/or dictionary attacks against them, also using hash decrypters.
With today's sophisticated GPUs, millions of hashes can be cracked a second with programs like John the Ripper and Hashcat. Salting the passwords and information is safer, but still not foolproof by a long way.
What have been the strongest influences on programming language design over the past 50 years?
Object oriented analysis and design.
What is the difference between tabular and datasheet subform layouts in the MS Access form wizard?
In MS Access, a tabular subform layout displays data in a grid format similar to a spreadsheet, allowing users to view multiple records at once. This layout is ideal for scenarios where data needs to be compared or analyzed side by side. In contrast, a datasheet subform layout presents data in a more traditional table format, emphasizing individual records and their details, often used for data entry or detailed viewing. The choice between the two often depends on the user's specific needs for data interaction and presentation.
What is called the standard database query language supported by all relational databases?
SQL stands for Structured Query Language. It is fairly standard but implementations generally have non-standard parts. These are usually to do with how data storage is specified, options to aid performance and extra things thought useful that aren't specified int the ANSI standard specification for SQL.
Why do Database Management is related to MS Access?
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Access is a Database Management System, so it is related to the management of data. It is what a database is for.
What is the values that the databases uses for the field unless the user enters another value?
The value that a database uses for a field is set to a default value, usually by the database designer. The value can be whatever the company wants it to be, as long as it is valid for the datatype of the field. The default value changes if and when a user or a programmer updates the field with a different value.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
Should database management system such as access always be used for database?
Depending on the size of information and simultaneous users. Access is a easy to use relational database system supporting up to 100 simultaneous users. However this slows down the network a great deal. If you want to have a more secure and more powerful dbms than you should look into mySQL, or Oracle. If you have only 5 people using the system, than Access may be your cheapest and best bet. Remember, when using DBMS's you want to get yourself the most effective output, for the smallest amount of cost(time, money, and resources).
How validate and retrieve data from database?
It is better to validate the data going into the database for errors rather then data coming out. The data to be retrieved can be done using the $_REQUEST or mysql_fetch_array or PDO statements. I am giving 2 simple examples
// The connection string or function here to connect to database
// Put the name of your database in place of db_name
mysql_select_db("db_name");
// Enter the name of table in place of table_name
$query = mysql_query("SELECT * FROM table_name");
while($fetch = mysql_fetch_array($query))
{
// add your table column names in the square blocks
echo $fetch['Name']."
";
echo $fetch['email']."
";
}
?>
If you want a particular data that can be obtained by using the where clause
The ID would come from user input
$data = $_REQUEST['ID'];
// Enter the name of table in place of table_name
$query = mysql_query("SELECT * FROM table_name WHERE ID='$data'");
while($fetch = mysql_fetch_array($query))
{
// add your table column names in the square blocks
echo $fetch['Name']."
";
echo $fetch['email']."
";
}
?>
When creating a database a is represented as a table?
table represent the value that are inserted during the user using that website
How can you change a manual system in a supermarket to a computerized system?
one time i saw this wolf and he tried to eat my sister but i threw skittles at his face and said "taste the rainbow jerk" but he told me through sign language (because, duh, wolves cant talk) that my sister had his precious jem from the bulgarian country side, and that eating her was the only way to make her regurgitate it. and THEN he tried to eat me, but luckily harry potter came on a broom stick and wacked him in the nose wth hermione and his nose fell off so then he looked like voldemort and then mr montgomery said "oh, i ate too many cookies"
