Database Programming

-- two dashes mean a comment in DB2 for VM and z/OS

-- 1st design your table - considered optional

-- 2nd declare your table - maditory. You still can not alter a table that

-- does not exist

-- 3rd alter the table to add the foreign key

-- DB2 for FOREIGN KEY

ALTER TABLE owner.Tablename

ADD CONSTRAINT name FOREIGN KEY (column name(s) )

REFERENCES REDBA.RESF_FINAL_CARD (column name(s) )

ON DELETE RESTRICT -- means stop them

or

ON DELETE cascade -- Cascade means to delete everthing here

or

ON DELETE SET value -- update the value of the column

;

-- note since you are doing DDL not dml the commit is implicit!! so

-- there is no COMMIT WORK needed

Fast access memory which is inside the actual CPU chip.

Correlated query has a subquery in it which accesses the column name of a table alias which is outside the subquery.

With out databases you wouldn't have any were to store information!

because our sun which also is a star, is hundreds of thousands of light years closer to us than the next nearest star. therefore its light is also proportionately greater. and during the day it illuminates our atmosphere to a greater degree than the light from the other stars , the stars are still shining, you just can't see them any more because they're dimmer than the light which is being refracted into the atmosphere by the sun. this refracted light also gives the atmosphere its blue color which is brighter than star light. you can kind of demonstrate this in a dark room by lighting a match, it will seem very bright, but if you flip on the light switch, it will seem very dim in comparison to the brighter light of an incadesant bulb. at night the earth blocks out the suns light from our atmosphere and allows the lesser light from the stars to be seen. hope thus helps,*** keary***

The Oracle link, below, gives an objective comparison between MySQL and Oracle (n.b., a great deal of the lengthy page contains computer terminology that the average layman may not understand). what is the difference between oracle and MySQL?

In relational database systems (RDBMSs), Truncate is a DDL command that automatically commits. It runs so fast, compared to a Delete, because it doesn't even log anything except the start point and end point of the transaction. Delete, by comparison, is a DML command and logs all the information it needs to roll back. In practice, most DBAs prefer to never trunc a table in a production environment. It's handy, though, in the world of prototyping, testing, or cleanup of dead databases.

* Defining the Schema The DBA defines the schema which contains the structure of the data in the application. The DBA determines what data needs to be present in the system ad how this data has to be represented and organized. * Liaising with Users The DBA needs to interact continuously with the users to understand the data in the system and its use. * Defining Security & Integrity Checks The DBA finds about the access restrictions to be defined and defines security checks accordingly. Data Integrity checks are also defined by the DBA. * Defining Backup / Recovery Procedures The DBA also defines procedures for backup and recovery. Defining backup procedures includes specifying what data is to backed up, the periodicity of taking backups and also the medium and storage place for the backup data. * Monitoring Performance The DBA has to continuously monitor the performance of the queries and take measures to optimize all the queries in the application.

ACCUMULATOR

A warehouse management system, or WMS, is a key part of the supply chain and primarily aims to control the movement and storage of materials within a warehouse and process the associated transactions, including shipping, receiving, putaway and picking. The systems also direct and optimize stock putaway based on real-time information about the status of bin utilization.

Inventory is a list for goods and materials, or those goods and materials themselves, held available in stock by a business.

I hope it helped.

Almost all companies use some type of marketing information system. Successful companies use the systems to gather data for industry trends, customer behavior, and other reasons.

It means that all the information about a specific office and its employs, their salary, Actually you can add any information using inside an office..........

Proably some kind of bug or virus. You must be using windoze. Try unplugging you machine for a few minutes and then re-boot. If the problem persists contact micro soft. Make sure you have the latest updates and virus software installed. I like AVG Free, and it's ...free. If the problem persists after that, I would think about switching to something that works, like Linux. Ubuntu and Fedora are good OS and allow you to try them out before you buy. But the cost is...free and so is the software. I don't get paid for saying this either, because it too is...free. Good Luck.

Yes, a Database Management System's main advantage is that it will enforce relationships between tables in a database preventing you from entering data in one field in another table that does not already exist in another table. So for example if you have a database that tracks online purchase, the DBMS would prevent a product that does not already exist in the Products table from being added to a shopping cart table. Or an employee ID from being added to a timecard table that does not already exist in the employee table. Databases can be setup without enforced relationships, but doing so usually results in orphaned records (for instance, where and employee id exists in the timecard table that does not exist in the employee table.)

J=Jewish I=International T=Tea party

is an advancement to a higher-level job with increased authority, responsibility and pay within the organization.

There are atomic and compound primary keys used to quikly find the rows of a table you are looking for. This is more than just an idex - it helps find the one row you want like finding a needle in a haystack.

Atomic keys use only one column and can not be broken down - hence atomic.

Compound primary keys are made up of two or more columns from the same table. For performance reassons try to use the first columns and preferably have them close together.

A table can have more than one unique index but only 1 (one, uno) primary key.

You can not create a primary key that uses a column from another table.

So far no one has implimented functional primary keys where the primary key is the result of a function.

There are encrypted primary keys.

Why use a compound primary key? So you can take the key apart quickly or validate its pieces first. If you use telephone numner (555) 555-1234 as a primary key would it not be nice to know

1) the first part is a valid 3 digits area code and not 011 a country code?

2) that the next 3 digits are a valid exchange

3) that the last part is valid

By keeping the parts separate you can alos do fun quiries on "How many phones are in my exchange of 555 ? How many are in my area code? How often does my exchange or phone number apprear in other states?

This would be much harder to do if the primary key was stored as a single number 5555551234.

Factless fact tables are used for tracking a process or collecting stats. They are called so because, the fact table does not have aggregatable numeric values or information. They are mere key values with reference to the dimensions from which the stats can be collected. - Jayakumar

The cross-appellant in a case is the person who files a cross-appeal to counter an appeal already filed by the original appellant. Usually, the original appellant would be the party which lost the case in trial court, and would be asking the Appeals court to overturn the trial court verdict. A cross-appellant is usually the party which received a verdict partially in their favor at trial, and is counter-appealing some aspect of the trial court's verdict to the Appeals court. A 'defendant-cross-appellant' is means that the party which was the defendant in the trial court, is now the cross-appellant in Appeals court.