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.
Chapter #4 Question #12. What is IVR? How is it used to query a database? Question...
Chapter #4 Question #12. What is IVR? How is it used to query a database? Question #14. What is master data management? What is data steward? What is the role of master data management in an organization’s integration strategy? Question #16. What are examples of internal sources of data for a data warehouse? What are examples of external sources of data for a data warehouse? Question #18. What is big data? What are the defining features of big data?
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. For each of the following, write a single SELECT query against the TSQLV4 database that...
1. For each of the following, write a single SELECT query against the TSQLV4 database that returns the result set described. Each of these queries involves two tables and can be written using a join operation. a. One row for each order shipped to France or Germany, showing the order ID, the last name of the employee for the order, and the customer ID for the order. b. One row for each employee who handled orders to Belgium, showing the...
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT