Data Definition Language Essay

Describe the ways in which database technologies could be utilise by an office stationery release company to achieve affordable leadership. Answer Sales databases could be employ to make the supply orbit more efficient and minimize warehousing and transportation costs.You can too use sales databases, as well as text tap and sentiment analysis, to determine what supplies are in demand by which customers and whether inevitably are different in different geographical areas. Business light databases could be employ to predict future trends in office supply needs, to help anticipate demand, and to determine the most efficient methods of transportation and delivery. trace and describe three basic operations used to extract effective sets of data from a relational database. Answer The select operation becomes a subset consisting of all records (rows) in the table that meets stated criteria.The join operation combines relational tables to provide the user with more information than is available in single(a) tables. The project operation creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the information required.List and describe three main capabilities or tools of a DBMS. Answer A data comment capability to specify the structure of the content of the database. This capability would be used to create database tables and to define the characteristics of the fields in to each one table.A data dictionary to store definitions of data elements in the database and their characteristics. In large bodily databases, the data dictionary may capture additional information, such as usage ownership authorization security and the individuals, business functions, programs, and reports that use each data element.A data manipulation language, such as SQL, that is used to add, change, delete, and retrieve the data in the database. This language contains commands that permit end users and programming specialists to extract data from the database to satisfy information requests and develop applications.