Can a Database Contain Two Identical Records

User Generated

zryyb79

Computer Science

Description

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

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Thank you for the opportunity to help you with your question!

Yes, a database can contain two identical records. Structure of the database/table decides whether identical records impose negative effect on the integrity. If database table don't have any defined key or other 'unique' constraints, then we can have multiple identical records while opposite is not true. Although it is not a recommended practice in design of database.

Please let me know if you need any clarification. I'm always happy to answer your questions.


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags