0
What does a database expert mean when she says that a databse displays both entity and referential integrity?
Wiki User
∙ 14y ago
Entity integrity, also known as a check constraint, is a database imposed restriction that the value of a field be limited. For instance, you could say that a number can only be in the range of 1 to 100, and the database would not allow you to insert or modify a row to have a value outside that range.
Referential integrity, also known as a foreign key constraint, is a database imposed restriction that the value of a field be contained in the primary key or a unique key associated with another table. For instance, you could say that a programmer's name be contained in a table of employees, and the database would not allow you to insert or modify a row to have a programmer that is not also an employee. In this example, to clarify, the employee table would contain people that are programmers, as well as analysts, managers, officers, etc.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is mblob?
A BLOB is a binary large object which is a chunk of data for a database. An mblob is a medium blob used in php code for an SQL databse.
What is the difference between Statement and PreparedStatement?
* Prepared Statement is Pre-compiled class , but Statement is not. * So in PreparedStatement the execution will be faster. Actually when u submit a simple statement to the databse, at first the DBMS parses it and sends it back with the result, so again when u send the same statement again the DBMS server parses it and sends back the result so here a lot of time is wasted and because the statement is again parsed though it has been sent twice or thrice it consumes a lot of time and response will be slow.Prepared Statement is used when u want to execute a statement object many times. when u submit a PreparedStatement the DBMS server parses it and creates a execution plan. This e-plan can be used when u again send the same statement to the database.That is the DBMS server zest executes the compiled statement rather that executing it from first, hence we get an precompiled statement.And also the advanatge of using this PreparedStatement is it is used to send dynamic sql statements, which u can give values later than giving the values at the time of creation.
What is databse integrity control?
Integrity control means keeping the data consistent and correct by means of controls that a database administrator puts on the database. Only persons with privileged accounts can load data into the database. Even with that, there are rules on the table fields that allow only a certain type of data to be inserted.
What is a databse record?
Database is a collection of interrelated data. One entry in a database is referred as one record.
What is the largest unit of a database?
is a Field.
What is the definition of a databse?
A database is a source of data.. a collection of data.. whether it's in paper form, or otherwise.
What kind of databse is Adobe Stock Photos?
The Adobe Stock Photos database was a photography database. It was a royalty free image database before it was terminated in the year 2008 by the Adobe company.
What are databse anomalies?
Database anomalies are unmatched or missing information bits caused by limits or flaws within a database. Databases are designed to collect and sort data.
What is Schema in the term of Database Management System?
Schema means structure of the databse. Like, tables, constraints, relation
What is fuzzy database?
A fuzzy database incorporates fuzzy logic to handle imprecise or uncertain information. It allows for flexible querying and supports reasoning with vague or incomplete data. Fuzzy databases are useful in situations where traditional databases fall short due to their reliance on crisp, exact values.
What is mblob?
A BLOB is a binary large object which is a chunk of data for a database. An mblob is a medium blob used in php code for an SQL databse.
What are the disadvantages of temporal databse?
One major disadvantage of a temporal database is the very likely ability for you to lose necessary information from the database if you forget to create alternative downloads or storage. The information in a temporal database is only saved for a certain period of time.
What sort of tasks might be required soon after the initial creation of a database?
After creating a database make sure that it is sorted as per the requirement.Select a suitable database management system.(software to create,update,querying,administration and updation of data bases.)Create a databse model that can be used for suitable applications.
What is a field in a databse?
In a database, a field is a column in a table that is designed to store a specific type of data, such as numbers, text, or dates. Each record in a table consists of data stored in multiple fields, with each field corresponding to a particular piece of information. Fields help organize and structure data in a database for efficient storage and retrieval.
