discuss the problem of spurious tuples and how we


Discuss the problem of Spurious tuples and how we may prevent it.   

Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined badly. In database-ese, spurious tuples are formed while two tables are joined on attributes which are neither primary keys  nor foreign keys. To prevent spurious tuples, avoid joining relations that consist of matching attributes that are not (foreign key, primary key) combinations as joining on such attributes may generate spurious tuples.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: discuss the problem of spurious tuples and how we
Reference No:- TGS0275818

Expected delivery within 24 Hours