0
What else can I help you with?
Difference between database and relational database explain with example?
Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.
What is the meant by anomaly in database?
Data anamaly means same type of data present in database as a duplication.So while updating or modifying the information in the database we gets the problem of data inconsistency to solve this problem we need to remove the duplicated data
What is relational database Explain the purpose of creating database?
A relational database is a type of database that stores and organizes data in tables with a predefined structure. The purpose of creating a database is to efficiently store, manage, and retrieve data for various applications or systems. Databases help to ensure data integrity, enable data sharing, provide a structured way to store information, and support data analysis and reporting.
Can any one please tell me the difference between database management and data warehousing in brief?
Database management involves designing the actual tables in a database and making sure that the database is up and running smoothly. This is performed by a database administrator (DBA). Data warehousing involves storing data in a database. The DBA designed the database, but someone else (or a program that someone else is running) is actually inserting the data into the database.
What is the four common object found in an access database and explain their use?
In an Access database, the four common objects are tables, queries, forms, and reports. Tables store the actual data in rows and columns, serving as the database's backbone. Queries allow users to retrieve and manipulate data based on specific criteria, facilitating data analysis. Forms provide a user-friendly interface for data entry and navigation, while reports present data in a formatted manner for printing or sharing.
Difference between logical database and physical database?
A logical database refers to the conceptual schema or model of data relationships and structures, independent of how data is stored or accessed. On the other hand, a physical database involves the actual implementation of the database on a specific hardware system, detailing how data is stored and accessed. The logical database design focuses on the organization of data, while the physical database design focuses on optimizing performance and storage efficiency.
What is a database object that allows you to organize summarize and print all or a portion of the data in the database?
A report is a database object that allows you to organize, summarize, and present selected data from the database in a formatted way for printing or viewing. It provides a structured presentation of data that can be customized to meet specific reporting requirements.
What is the difference between logical database and physical database?
A logical database refers to the way data is organized, modeled, and accessed by users, focusing on the structure and relationships of data. In contrast, a physical database relates to how data is actually stored on disks, including indexes, partitions, and access paths designed for efficient data retrieval and storage.
Explain database architecture with a diagram?
A database is an organized collection of data, today typically in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called adatabase system.
Explain the objectives and functions of DBMS?
The database management system is a program collection that issued in defining, creating, and maintaining the database. It has a 3 function; (1) database defining structure, (2) database populating, and (3) database manipulating.
What does form mean in a data base?
i think that form means how you present your information in the database program.
When validating data a completeness check is performed to confirm that all records in the database are present?
FALSE
