Database management System a Write the generic form of an SQ

Database management System

a. Write the “generic” form of an SQL program to build a table structure.

b. Write the “generic” form of an SQL query to produce a relation of degree 3 from a set and to limit its rows by one boolean condition.

Solution

is a special-motive programming language designed for managing statistics held in a relational database control system (RDBMS), or for movement processing in a relational information circulation management device (RDSMS).

in the beginning based totally upon relational algebra and tuple relational calculus, sq. consists of a statistics definition language, data manipulation language, and information control Language. The scope of sq. consists of data insert, query, update and delete, schema advent and modification, and information get entry to control. despite the fact that sq. is regularly defined as, and to a incredible extent is, a declarative language (4GL), it is usually procedural factors.

square changed into one of the first commercial languages for Edgar F. Codd\'s relational version, as defined in his influential 1970 paper, \"A Relational version of statistics for large Shared facts Banks.\"[10] notwithstanding no longer totally adhering to the relational model as described by using Codd, it became the most widely used database language.[11][12]

sq. have become a trendy of the yankee national requirements Institute (ANSI) in 1986, and of the international organization for Standardization (ISO) in 1987.[13] considering then, the same old has been revised to encompass a larger set of functions. regardless of the existence of such standards, maximum square code isn\'t always absolutely transportable amongst extraordinary database structures without adjustments