0
Can a Database contain two identical records without negative effect on the integrity of the database Why or why not?
Sure, not an issue but it will mean you can get multiple hits for the same query. You have to take that into account in your program.
Guidance is to have a unique key for every table but that is not a requirement.
Think of an example where you are using a database to collect poll answers. All you have is the answers from all people, no unique information from the persons because that is not important to your survey.
Or, say you keep information in that same table of location of the city where the survey was taken it. There is a possibility that more than one row will have the same data.
You can get meaningful information from the database.
What else can I help you with?
What are the differences between positive and negative databases?
There are two different contexts is which these terms are used; the first is regarding "reputation", a positive database contains entries correponding to entities with good, or at least not bad, reputation. A negative database has the entries corresponding to entities with decidedly bad reputation. In the second context, a positive database is what you normally thing a database to be, say entries containing names and credit-card numbers; a negative database contains all of the possible entries not included in the positive database, i.e., all possible name-creditcard combination except the ones in the positive DB. In fact a negative database has all possible character combinations (or for that matter bit combinations) of a given length that are not present in the negative db. This scheme has a potential for data security and personal privacy.
How has the use of electronic database affected the airline industry?
negative one half
What are negative aspects of developing a DNA database?
Some negative aspects of developing a DNA database include privacy concerns, potential misuse of genetic information, and the risk of creating a discriminatory society based on genetic data. There are also ethical considerations regarding consent and the security of storing sensitive genetic information.
What db has no sound?
dB is a logarithmic scale, so the answer, basically, is negative infinity.dB is a logarithmic scale, so the answer, basically, is negative infinity.dB is a logarithmic scale, so the answer, basically, is negative infinity.dB is a logarithmic scale, so the answer, basically, is negative infinity.
What is a photo negative scanner used for?
A photo negative scanner is used to scan negatives. Scanning negative photos is used to create digital images of standard photos. These images can be used for recreating the images, or for storage of images in a database.
If records in a database are stored using a key which is one byte long how many records can the database store?
If the key is one byte long, then there are 8 bits that can be positive or negative. With all permutations of 8 bits, that leaves 2^8 (two to the eighth power) possibilities, which is only 256 total unique values.
What are the advantages and disadvantages of a negative database?
i would honestly ask someone who is highly skilled in computers to give you this complex answer i don't know the answer but i can say someone who knows a lot will give you the correct answer to your question
What are the data types would be used to store a whole number?
bit, int, numeric(8,0) depends on which database you are using
What is a field length check in a database?
Most database field types have an inherent data length limit, however the business rules of the application may require a lower maximum limit on the field. For example, an integer field may hold positive and negative values in the hundreds of thousands or more, but if the field is designed to hold the price of something, it makes no logical sense to permit values that high if it is for items in a supermarket.
What is the net field midway between the two identical negative charge?
Electric field at the mid point between the two identical negative charges will be zero. In the same way, if both charges are of identical positive, the field at the mid way will be zero.
What is atomic values in database design?
This is quite an elemental question. Think about it- what would be termed atomic? One that cannot be divided, as from its Greek definition. Atomic values in a relational database mean that they cannot be further divided, according to domain rules defining that attribute. An attribute is a column in the table that people normally think of as a relational database, and the notion is pretty correct. Domain rules define what data and its type can go into a column, and others are inadmissible. For instance, let's say that the database of a particular bank is organized as a set of tables, that is it is relational in nature, and one particular table lists the details of all account holders with the bank. All these details can reasonably form the attributes of the bank's customers, and can therefore be allowed to represent columns in this table. Suppose we have a column that holds the account numbers of the customers, and the domain rule defines that an entry in this column must necessarily be a non-negative, non-zero, integer. By this rule, 2453536 is an atomic value, whereas No. 10, Bowers Avenue is not, since the latter can be split further, and it also does not satisfy the domain rules.
What is a negative association?
Association rule mining is a data mining task that discovers relationships among items in a transactional database. and Association rule analysis is the task of discovering association rules that occur frequently in a given data set. the question like: what items a customer id "not likey" to buy giiven that he buys a certain set of items. We call these types of rules as the negative association rules.
