Database Programming

if you want composite key for using the sql use the following sql query:

select distinct(col_name) from table_name where col_name is null;

overall design of the database

dead

FIFO (first in first out)

In a relational database management system (RDBMS), the command for creating a new table is "CREATE TABLE". This is the standard in most SQL programs.

Hospitals, To keep Patient Records.

Insurance Companies.

Police Crime Records.

Schools for student records

Government agencies like tax for tracking

Benefit departments

Shops use them for till transactions and inventory

Basically anywhere that requires the storage of data to use in their operation will use a database of some design

True

two - * and ?

data base programming,Nigeria,C++ Programming

Data recovery in database environments is more difficult due to the complexity of structured data and the interdependencies between tables, which can complicate the restoration process. Additionally, databases often employ transactions and concurrency controls, meaning that incomplete or inconsistent data states can arise during recovery. The need to maintain data integrity and the potential for data corruption further complicate recovery efforts, making specialized tools and techniques necessary. Finally, large databases may have extensive logs and backups, requiring careful management to ensure a successful recovery without data loss.

So you get the particular kind of data you need, rather than millions of items you don't want.

DB2 enterprise server edition

One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.

yes. data redundancy is where there is duplication of data in a database. when this happens, anyone who has to make updates to a table in a database (that is, make changes to the database) will have to change that particular data that has been duplicated so many times in so many places. this creates a problem and it is not always going to be possible for a person to change everything correctly. this therefore leads to inconsistencies in the database. hope this helps.

Teradata TPump is a data loading utility that helps maintain (update, delete, insert, and

atomic upsert) the data in Teradata Database. Teradata TPump allows near-real time data to

be achieved in the data warehouse.

Teradata TPump provides an alternative to Teradata MultiLoad for the low volume batch

maintenance of large databases under control of a Teradata system. Instead of updating

Teradata Databases overnight, or in batches throughout the day, Teradata TPump updates

information in real time, acquiring data from the client system with low processor utilization.

coding redundancy

interpixel redundancy

psycovisual redundancy

i want er diagram for bus reservation system you shw me

Extranet

Flagged

database is a collection of related data in any size and in any complexity whereas database management system is software for defining, constructing and manipulating databases for various reasons.

no diff between varchar and varchar2

char store only chacter type but varchar2 store variable chacters.

also varchar2 shirinks the space if not fully filled but char cant.

By default a primary key is also a unique constraint, that means only one row can contain a specific value for this key (or no duplicates are allowed). Also an index is automatically created for a primary key allowing efficient access.

DML

select * from "table-name" where month="required month";