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 is the characteristics of dbms?
Basic Characteristics of DBMS
• Represents complex relationship between data
• Controls data redundancy.
• Enforces user defined rules.
• Ensures data sharing.
• It has automatic and intelligent backup and recovery procedures.
• It has central dictionary to store information.
• Pertaining to data and its manipulation.
• It has different interfaces via which user can manipulate the data.
• Enforces data access authorization.
What is the foreigh key in DBMS explainwith example?
In the context of relational databases, a foreign key is a referential constraint between two tables.[1] The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. The columns in the referencing table must be the primary key or other candidate key in the referenced table. A table may have multiple foreign keys, and each foreign key can have a different referenced table. Each foreign key is enforced independently by the database system. Therefore, cascading relationships between tables can be established using foreign keys. Improper foreign key/primary key relationships or not enforcing those relationships are often the source of many database and data modeling problems.
What a tuple in a relational model?
A row of a table in relational model is known as tuple - is the easy answer. A tuple is a collection of elements that relate to one another : T = R(e1, e2, ... , en). One can view a collection of similar relations, R, as a table, where the elements of same category are projected underneath one another, and ordered as is suited for the table view. When implementing a relational database, the tuples can be spread all over in a way that suits those that make the storage system, and enables fast retrieval and manipulation of them. So, unless you specify the sorting - "Collating Sequence" of the table, you can expect a new ordering every time you view the table. The elements in the relations are bound together in the same way as rows in a table - but some relations may have more elements - "columns" and really belong to other tables - but is "projected" into the view you see as a table.
Because i'm smart and your not i will tell you the answer it helps people find data and it updates it and it can tell you anything and updates anything with in seconds
Security problems in file processing system?
Enforcing Security Constraints in file processing system is very difficult as the application programs are added to the system in an ad-hoc manner.
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 the meaning of the abbreviation 'SQL'?
Structured Query Language, SQL, is used for retrieving and managing data in databases.
What do you understand by a Database-Model?
A database model is a theory or specification describing how a database is structured and used. Several such models have been suggested. Common models include: * Hierarchical model * Network model * Relational model * Entity-relationship * Object-relational model * Object model A data model is not just a way of structuring data: it also defines a set of operations that can be performed on the data. The relational model, for example, defines operations such as select, project, and join. Although these operations may not be explicit in a particular query language, they provide the foundation on which a query language is built.
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
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 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 is a simple key in database?
A simple key consists of a single attribute to uniquely identify an entity occurrence, for example, a student number, which uniquely identifies a particular student. No two students would have the same student number.
What is a many to many relationship in dbms?
Many to many relationship in DBMS is usually a mirror of the real-life relationship between objects that tables represent.
Is database design language a programming language?
No, it doesn't comprise any binary or computer language syntax. It simply uses schematic to graphic representation of tables structures and attributes as a mechanism to ease to the design process.
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.
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.
