Question

In: Computer Science

What is a Data Dictionary? What is a Database Engine? What is a Query Processor/Analyzer? What...

What is a Data Dictionary?

What is a Database Engine?

What is a Query Processor/Analyzer?

What is a Forms Generator?

What is a Reports writer?

What is a DBMS?

What is the difference between DB and DBMS?

Solutions

Expert Solution

What is a Data Dictionary?


Data Dictionary:-
----------------
->The data dictionary is a set of database tables used to store information about a database’s definition.  
->A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field i.e It contains information about database objects such as tables, indexes, columns, datatypes, and views.
->Which Contains the Metadata i.e Data About the Data.
->Oracle Server uses the database dictionary to verify SQL statements.that means used to validate Each And Every Column refernces in Different Rables.
->Mostly DBMS keep the data dictionary hidden from users to prevent them from accidentally destroying its contents.


What is a Database Engine?

DataBase Engine:-
-----------------
DataBase Engine is an API,that enables you to directly control the engine without going through the DBMS's
->Which improves performance of processing Speed.
->If we want Connect to the Database,we cant connect directly to the Database for that DataBase Engine will helpful to connect with the database.
why because The Database have so many Connectivities,instead of Giving Access for Every Client Will Supply DataBaseEngine to Control.  

What is a Query Processor/Analyzer?

Query Processor/Analyzer:-
----------------------------
Query Processing is a procedure of transforming a high-level query (such as SQL) into a correct and efficient execution plan expressed in low-level language.
->A query processing select a most appropriate plan that is used in responding to a database request.

What is a Forms Generator?

Forms Generator:-
--------------------
Forms Generator is a library for Node.js that helps with HTML forms.
->Which is Predefined library that is used to create Creative Forms.

What is a Reports writer?


Reports Writer:-
---------------
Reports Writer is used to extracts information from one or more files and presents the information in a specified format.
->Which allows us to select records that meet certain conditions and to display selected fields in rows and columns.

What is a DBMS?

DBMS(DataBase Management system):-
----------------------------------
DBMS Stands for Database Management System provides a platform to store and Keep the Track of Data in Secure Manner and Accessing the data by Efficiently.
->DBMS is Software To create a Database and Accessing the Database.Which applications store data as file.
->which is a collection of programs that facilitates users to create and maintain a database.
->DBMS has to provide some uniform methods to access the stored information.
->Which Uses the Tables To Store the data.
->It overcomes the drawbacks of Traditional file Processing system,In that Scenario of Storing data,Accessing the data,Fetching the Data,Modifying the Data,
View the Data is easily by applyig simple Query.Which introduces SQL Language to perform all these kind of operations.


What is the difference between DB and DBMS?

difference between DataBase and DBMS:-
---------------------------------------
Where DB Stands for Database,which is an organized collection of data.We can create Database to Store Well defined Objects.
for that we need one specific platform to Access the Data.i.e Called DBMS(DataBase Management System).
Database handlers create database in such a way that only one set of software program provide access of data to all the users.
Where as DBMS Stands for Database Management System
which is a collection of programs that facilitates users to create and maintain a database.


Related Solutions

Sometimes a data dictionary is called as ‘the database designer’s database’. State and explain your opinion...
Sometimes a data dictionary is called as ‘the database designer’s database’. State and explain your opinion regarding this term and support your position using real-life scenarios.
Describe what each line does in the following SQL query The lyrics database is provided under...
Describe what each line does in the following SQL query The lyrics database is provided under question 3 for context 1. select studioID, studioname, base from salespeople sa inner join studios st on (sa.salesID = st.salesid) where base < 300 2. select concat_ws(' ', firstname, lastname) as "Member Name"         from members; 3. select m.lastname, m.firstname, s.lastname         from members m inner join salespeople s using (salesID)         order by m.lastname asc; The lyrics database is provided below DROP TABLES...
Description of Variables/Data Dictionary: The following table is a data dictionary that describes the variables and...
Description of Variables/Data Dictionary: The following table is a data dictionary that describes the variables and their locations in this dataset (Note: Dataset is on second page of this document): Variable Name Location in Dataset Variable Description Coding UniqueID# First Column Unique number used to identify each survey responder Each responder has a unique number from 1-30 SE-MaritalStatus Second Column Marital Status of Head of Household Not Married/Married SE-Income Third Column Total Annual Household Income Amount in US Dollars SE-AgeHeadHousehold...
What is a data dictionary? What is its importance in ensuring data quality? What type of...
What is a data dictionary? What is its importance in ensuring data quality? What type of information would be listed in a data dictionary?
1.write about your plan for the database performance tuning, query optimization, and distributed database management systems.  Include...
1.write about your plan for the database performance tuning, query optimization, and distributed database management systems.  Include appropriate diagrams.
SQL query exercises: Consider the following database schema:                Product(maker, model, type)              &
SQL query exercises: Consider the following database schema:                Product(maker, model, type)                PC(model, speed, ram, hd, rd, price)                Laptop(model, speed, ram, hd, screen, price)                Printer(model, color, type, price) Consider the Drivers-Cars-Reserves DB for a small rental car company:                Drivers(id, name, rating, age)                Cars(vin, maker, model, year, color)                Reserves(did, vin, date) Give SQL statement each of the following operations: Find the colors of cars reserved by Smith. Find all id’s of drivers who have a...
What features of query cache or Data cache serve to improve RDBMS performance
What features of query cache or Data cache serve to improve RDBMS performance
What are the similarities and differences between database, data warehouse, and data mining?
What are the similarities and differences between database, data warehouse, and data mining?
Database design is the process of producing a detailed data model of database. This data model...
Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database. (Wikipedia). Using a diagram/chart software, elaborate a database design Requirements: Define your database objective Explain your database's type of table relationship Explain and design your database elements and datatypes (tables, fields, etc,)....
What single query can get data from 4 tables , using SUM or COUNT
What single query can get data from 4 tables , using SUM or COUNT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT