answersLogoWhite

0

We know that normallisation decomposites the large no of tables in to small no of tables,after the decomposite if we want to join that table and getting the original table.then that join is known as lossless join,otherwise it is known as lossy join.

R

X Y L M

X1 Y1 L1 M1

X2 Y2 L2 M2

R1 a table ,Which consists of attributes such as x,y,l,m.If we want to decomposite it in to small no of tables then wer will get

r1 r2

X Y L M

X1 Y1 L1 M1

X2 Y2 L2 M2

After we decomposite the large table we get two small table,If we want to join that two table for getting the original table then

R

X Y L M

X1 Y1 L1 M1

X2 Y2 L2 M2

We got the original table wiyhout any lossing attribute so this join is called as losslessjoin or lossy join.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is meant database administration?

Database management system is a software system (set of programs) that is used for the management of databases. Now to understand Database management system it is necessary to know about databases. Database is a data structure used to organize related data. In databases data is stored in such a way that it can be easily accessed and changed easily. Normally a database is a collection of tables. A table itself can also be called as database and Table is a collection of columns and rows. Database administration is a method of tending to or managing the affairs of electronic data and the person who perform these activities is called Database Administrator. A database administrator (DBA) is responsible for the design, implementation, maintenance and repair of an organization's database.


Does a database report allow the user to enter or modify data in the records?

No, a database report typically displays data from the database in a structured format for analysis or presentation purposes. It is not meant for entering or modifying data directly. Users would use a database management system interface to input or edit records.


What is meant by marketing management answer in 6 lines?

what is meant by marketing management


What is meant by the term merge SQL with the Oracle software?

SQL - Structured Query Language - is a standardised query language for requesting information from a database. It was first introduced as a commercial database system by Oracle Corporation.


What is the definition of tender?

What is meant by tender client database


What is meant by importing data into a database?

Importing data into a database refers to the process of transferring data from an external source, such as a file or another database, into a database system. This allows users to store, organize, and manipulate the data within the database for various purposes, such as analysis, reporting, or application development.


What is meant by 'The execution of each transaction as atomic'?

In database management, atomicity refers to the property of transactions where either all operations within the transaction are completed successfully, or none of them are executed. This ensures that the database remains in a consistent state, with all changes committed or none at all.


What is meant by forcasting in management?

define forcasting in production management


What is forcasting meant in management?

define forcasting in production management


What is meant by administrative system in business?

What is meant by administrative system in business? What is meant by administrative system in business?


What is meant by management process?

Management process refers to planning and controlling the performance or execution of an activity in an organization. There can be two types of management processes including; process management and project management. Process management deals with the performance and management system. Management process is conducted by the top management of the company. It is the most important process because it gives the control to management over the tasks of the company.


Type of management meant to improve productivity in the workplace?

Scientific Management