Database Programming

er diagram for roadway travels

The main file in the database which is the only copy of the important data in a database is MASTER FILE

lalkesav@gmail.com

Certainly fuzzy logic is not the best in solving uncertainty, but..... it is on of the best alternatives to that exists to model uncertainty.

SELECT * FROM Person ORDER BY FirstName DESC

aga

A table means that it holds infomation and can be easily accessed!

A transaction must be an atomic unit of work; either all of its data modifications are performed or none of them is performed.

They r two types

1)create package command

2)create package body command

Failure to save the database will result in the changes being lost, just as failing to save a text document will cause changes to be lost.

nyammago

When two or more rows share the same number of columns, and when their corresponding columns share the same (or compatible) domains, they are said to be union-compatible.

Many millions

Importance of primary key

Object Model: deals with object oriented "blue-print" of your system. This includes, class diagrams (classes you will be creating), relationship between these classes, methods in the classes, properties etc.

Data model: deals with entities at the database level. Like how the classes in the OM will get stored in the database, in which tables etc. So DM deals with Table schema, relationship between different tables (PKs, FKs) etc.

Example:

DM does not have complex OO features like polymorphism, inheritance, overloading etc which are usually listed in an OM.

As a rough example, two classes in the OM can get stored (mapped) to a single Table in the DM, like both Employee and Manager persons can be stored in a single DB table.

In sql you use primary key more than one column in a table

in integral data types default value=0

in decimal type default value is 0.0

in boolean default value is fa

poda

HI,

First we need to maintain a doc or software for purchase, sales and stock details and need to track all the expiry good before one month or two months and return back to whole salers

Secondly we need to tract the customers satisfaction help them what are they requirements supply the medicines to there doors and give huge discounts and maintain good rap po with customers.

Third- create a site or blog and advt with sign board with mammoth discount.

Fourth- Exp's person or chemist need to keep the staff happy and maintain proper timings.

Prabhakar.

It means to make an actual back up. If you are using SQL Server just right click on the database highlight Tasks then select Back Up... follow the prompts and off you go.

A traditional file system can deliver routine scheduled reports after extensive programming efforts, but it cannot deliver ad-hoc reports or respond to unanticipated information requirements in a timely fashion.

Reduced data redundancy, Improved data integrity, Shared data, Easier access, Reduced development time

A subsystem of a Database Management System (DBMS) refers to a specialized component that performs a specific function within the overall architecture of the DBMS. Common subsystems include the Storage Management subsystem, which handles data storage and retrieval; the Query Processor, which interprets and executes database queries; and the Transaction Management subsystem, which ensures data integrity and consistency during concurrent operations. Each subsystem works together to provide the functionality and reliability expected from a DBMS.

1. someone deleting it

2. Virus on system

3. Did not save data

4. corrupt files

First normal form, second normal form, third normal form, fourth normal form, fifth normal form and Boyce Codd normal form. See the related question below.

The logical constists of the name of the table, the attributes it contains, their types, the constraints on the attributes, if any.

These cone-shaped buoys are always marked with red markings and even numbers. They mark the edge of the channel on your starboard (right) side when entering from the open sea or heading upstream.