0
What is the purpose of using joins in database is normalization the only purpose of it?
Wiki User
∙ 13y ago
The purpose of using Normalization is to avoid the data redundancy in tables. The normalized schema is much faster in performance so you can get a quick response from the database.
OLTP database designers follow the Normalization rules but the tables in Data warehousing(OLAP) data bases are in the De normalized form, they won't follow the Normalization technique. For this reason we are using more complex queries in Data warehouses which uses more system resources.
Some one might explain you better way.........
Thanks
Blueberry
Wiki User
∙ 13y ago
Wiki User
∙ 9y agoNo, Normalization is not the only reason for joins. Joins are used to combine related records from 2 relations. They allows to evaluate a join condition between attributes of relations.
Add your answer:
Earn +20 pts
Database Design?
form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No
What is the difference between data model and database model?
A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.
Database?
form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No
What is the purpose of using monitoring systems?
The purpose of using monitoring systems is to capture data. Another purpose of using monitoring systems is to monitor the environment for security purpose.
What software tool can be used to create a database add change and delete data in the database sort and retrieve data and create forms and reports using the data in the database?
datebase management system
Normalization form in details in points and examples?
Normalization is a process to reduce redundancy. By using normalization we can easily remove duplicate entries..
What is the purpose of using a business database software?
A business database software is designed to offer an organized mechanism of storing, managing, and retrieving information over the web. For above purpose, using a business database software is an easy and simple way to organize everything.
What is data abstruction in dbms?
Data abstraction in DBMS refers to the process of hiding the complex inner workings of the database system and providing a simplified view for users to interact with the data. It allows users to access and manipulate data without needing to understand the intricate details of how the data is stored or retrieved in the database. This abstraction helps in enhancing the flexibility, security, and usability of the database system.
What is normalisation in GIS?
Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships.Database normalization saves storage space and makes the data easier to index and analyse. Querying highly normalized relational databases can become quite complex since a large number of tables may need to be linked together.
For the purpose of DSN we have to specify a database name so how do we give a name to a database?
The same you would to any other file. Consider the purpose of your database, what you are using it for, what data you are compiling. Think about what product you are producing, what the central idea of the file is. That is your name.
What is the purpose of the SLQ database?
SQL (Structured Query Language) is a programming language used in database management to manipulate and retrieve information. Its purpose is to interact with relational databases, allowing users to create, modify, query, and manage data efficiently. SQL is widely used in various applications and systems to store and retrieve data in a structured manner.
What can be achieved from the database using forms?
what can be achieved from the database using reports
Can you create a database with only a form?
Yes , you can create a database using a form . But you have to do two things First make a form in html or jsp whatever you like. Then Connect the form to database using java database connectivity.Yes, we can create database with a form. First create a form using html or jsp then we can connect it to database using JDBC.
Is the relational database an example of oracle database?
A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.
Database Design?
form_title=Database Design form_header=Transform your company by incorporating a new database design. What program will the database be used with?=_ Please explain what you will be using the database for?="" Do you have a database that you're already using?= () Yes () No
What is the purpose of a query in a database?
The purpose of a query in a database is to retrieve specific information that meets certain criteria. Queries allow users to search, filter, and extract data from databases based on their requirements, enabling them to retrieve only the relevant information they need.
How do you connect to a database and table using ADODB?
How do you connect to a database and table using ADODB?
