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
8 factor to consider when choosing a database management system?
The hardware needed to run the dbms
the database dbms shouild meet the orgnisations needs for a short period of time
Difference between isql plus and sql plus?
Basically in isql we use browser and we can also use mouse here. But in sql we use terminal where we cannot use the mouse. Commands syntax are different from each other.
What are the advantages of numerical filing systems?
- Numerical filing is best for filing large numbers of records.
- It allows the files of patients with the same or similar names to be distinguished more easily.
- The numerical system provides greater security because reference to a patient's name is avoided
What Is The Relation Between Database And Tps And Mis And Dss?
TPS refers to the number of database transactions made per second. MIS or management information system gather relevant data that are from inside and outside of an organization which are then stored in a database. The DSS or decision support system typically gathers inventory data which are organized into relational databases for the purposes of timely analysis.
What kind of program is Microsoft access?
Microsoft Access is a type of database management program. It offers a graphical user interfaces that one can use to create and manage databases.
What is meant by a Relational Database Management System?
A "Relational Database Management System" (RDBMS) is a method of arranging data records such that they have something in common with each other (i.e., they can "relate" to each other in some way) and can be easily accessed in a meaningful way to the person examining that data. A simple RDBMS is a hand-written shopping or to-do list, which may include groceries and/or clothing and/or pet needs and/or stop at a bank and/or doctor's office visit, etc. Although the listed items - - which can be construed as database records - - may have nothing to do with each other, per se, they are all related in that they need to be obtained by the person who wrote the list. In this case, the piece of paper they are recorded on would be considered the "database" (i.e., no computer is necessary), and which might be arranged alphabetically and/or by retailer and/or location, etc, though, in this case, a sequential order of some kind, isn't necessarily important. More complex examples of an RDBMS would be an accountant's spreadsheet of a client's income and expenses, or an insurance agent's actuarial tables, or a telemarketer's "call" list. Typically, such "databases" consist of a variety of information about multiple individuals, include people's names, addresses, phone numbers, e-mail addresses, birthdates, etc. Due to the potentially high number of records, a special computer program might be required to record and sort the data. It is up to the programmer (i.e., the person managing the RDBMS) to code the software (usually utilizing a "Structured Query Language" (SQL)) such that the RDBMS's user (i.e., given the aforementioned list, that would be the accountant, insurance agent, or telemarketer, respectively) can arrange, display, print, and/or use it in a meaningful way (i.e., the user might want lists sorted alphabetically by name and/or city and/or state, and/or numerically by phone area code, etc). A far more complex RDBMS would be used by local, county, state, or national governments, in order to maintain hundreds, thousands, or millions of records on citizens for a variety of purposes, including education, health, security, social welfare, criminal backgrounds, income taxes, etc. Again, both the breadth and complexity of the records would require a well-designed database.
Binary relationship in database?
A binary relationship is a type of relationship between the entities, which links to types of entities in it.
Oracle-based human resources management system from PeopleSoft, Inc.
What is the importance of auditing to an entity?
auditing helps to detact error and fraud at an early stage
It also helps management to improve or comeup with better strategies to quality management system .
Difference between data warehouse and datamart?
A data warehouse has multiple functional areas whereby a centralized organizational unit is responsible for implementing it. On the contrary, data marts focus on particular functional areas hence are simple forms of a data warehouse.
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
