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.
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.
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
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 tender client 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.
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.
define forcasting in production management
define forcasting in production management
What is meant by administrative system in business? What is meant by administrative system in business?
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.
Scientific Management