Tag: GGSIPU BBA NOTES

A Snapshot is a recent copy of a table from db or in some cases, a subset of rows/cols of a table. They are used …

In Oracle, INSERT statement is used to add a single record or multiple records into the table. Syntax: (Inserting a single record using the Values …

Constraints can be specified when the table is created with the CREATE TABLE statement, or after the table is created with the ALTER TABLE statement. …

In Oracle, CREATE TABLE statement is used to create a new table in the database. To create a table, you have to name that table …

SQL is a language to operate databases; it includes database creation, deletion, fetching rows, modifying rows, etc. SQL is an ANSI (American National Standards Institute) standard language, …

Physical database design translates the logical data model into a set of SQL statements that define the database. For relational database systems, it is relatively …

A functional decomposition is the process of breaking down the functions of an organization into progressively greater (finer and finer) levels of detail. In decomposition, one function is …

Relational Data Model In this model, data is organised in two-dimensional tables and the relationship is maintained by storing a common field. This model was introduced by …

The integration of the domestic economy through the twin channels of trade and capital flows has accelerated in the past two decades which in turn …

It is also referred to as demand-supply theory of exchange. The theory stresses that the rate exchange basically relates to the position of balance of …