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?
fuzzy database manages the uncertainty and vagueness associated with either entities, attributes and relationships. this can be implemented in relational database model (fuzzy extension) or using object oriented databse model.
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?
Typically when someone uses the term field in relation to databases, they are referring to an attribute in a specific table within a database. Thus, if you have a database table used to store data about users of your system, a field (or attribute) would be first name.
