Answered

Westonci.ca is your go-to source for answers, with a community ready to provide accurate and timely information. Experience the convenience of getting reliable answers to your questions from a vast network of knowledgeable experts. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.

Can a database contain two identical records without a negative effect on the integrity of the database? why or why not?

Sagot :

sakshigupta4990

Yes, a database can contain 2 identical records.

Identical records imposing a negative effect on the integrity will depend on whether the database semantics allow duplicates or not.

If the database table doesn't have any defined key or other 'unique' constraints, then we can have multiple identical records. Otherwise, we will not have multiple identical records.

The database might be a list of all transactions for a store, in which case it would be very possible for two people to purchase the same item, causing duplicate records.

Yes, a database can contain two identical records. The database/table structure determines whether identical records break integrity. If the database table does not have a defined key or other "unique" constraint, then it is possible to have multiple identical records, but not vice versa.

Learn more about database at

https://brainly.com/question/518894

#SPJ4

Thank you for trusting us with your questions. We're here to help you find accurate answers quickly and efficiently. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Thank you for visiting Westonci.ca. Stay informed by coming back for more detailed answers.