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.
What else can I help you with?
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 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 meant by marketing management answer in 6 lines?
what is meant by marketing management
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 the definition of tender?
What is meant by tender client database
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 key in database?
A key is a unique part of the record that is used to index.
What is meant by Actuate Encyclopedia Volume and what is its significance?
The volume is where your reports are stored. You need to understand that a volume can also contain many "folders" which are tied to separate database schemas. Think of an encyclopedia volume as a reports database, and the folders as database schemas, and you begin to understand how Actuate is organizing your reports, metadata, and Actuate system data. -C The volume is where your reports are stored. You need to understand that a volume can also contain many "folders" which are tied to separate database schemas. Think of an encyclopedia volume as a reports database, and the folders as database schemas, and you begin to understand how Actuate is organizing your reports, metadata, and Actuate system data. -C
