Database Programming

1. Requirement Analysis

2. Conceptual Data Base Design

3. Logical Data Base Design

4. Schema Refinement

5. Physical Data Base Design

6. Security Design

No you can't. SQL is not a programming language, so it doesn't create programs. It is a query language, and it creates queries. There is a difference. There are various things that programming languages have and that they can do, which would take a more detailed explanation to define. SQL is very limited in what it can do, being specifically designed to work with data and manipulate databases. It does not have the capabilities of a programming language. A query and a program are both a list of commands to do a task, but a program is far more extensive and can do far more things, and so it is very different to a query.

Dis Advantages: Security may be compromised without good controls, Extra hardware may be required, System is likely to be complex Advantages: Reduced data redundancy, Secured data, Integrated data, Controlled data inconsistency

A primary key field in a sql table is created using the PRIMARY KEY keyword. ex:

CREATE TABLE tbl_employee (

emp_num VARCHAR(10),

emp_name VARCHAR(100),

PRIMARY KEY (emp_num))

The above script creates a table called tbl_employee and sets the emp_num field as the primary key

1. it helps each application program to be executed in a sequence.

2. it requests the operating systems to execute an input operation.

3. it provides status information to the application program.

4. It processes data.

- RIYA G.

greedy method does not give best solution always.but divide and conquer gives the best optimal solution only(for example:quick sort is the best sort).greedy method gives feasible solutions,they need not be optimal at all.divide and conquer and dynamic programming are techniques.

Databases organize information into records, each of which represents a single unit of information

Search a selected transaction, then search and select the order, then click the match to transaction button to match a transaction to an order.

A constraint

Data Validation is a process that ensures that data entered into the database form, a web form, or a computer program conforms to the correct data type.

Form

E-R diagram for prepering greeting cards

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

A data warehouse differs from OLTP in that the former handles many large and complex queries regarding various rows of a table while the latter retrieves data from single rows. At the same time, a data warehouse is not real time and supports few users at a time compared to OLTP that can support many concurrent users.

- Rapid Processing

- Reliability

- Standardisation

- Controlled Access

Well last week I purchase Florida U.S database in Highleads.com and so far I'm happy with what i bought from them. They have different databases you can choose from and they accept paypal as a way of payment. I hope this will help you.

Reference http://www.highleads.com

types of validations are: required field validation range validation pattern matching validation database specific validation numeric validation

View is a virtual table that do not have any data of its own but have data that is derived from another table called base table. Create view is the command used to create a view (virtual table).

No Duplicate Tuples - A relation cannot contain two or more tuples which have the same values for all the attributes. i.e., In any relation, every row is unique.

• Tuples are unordered - The order of rows in a relation is immaterial.

• Attributes are unordered - The order of columns in a relation is immaterial.

• Attribute Values are Atomic - Each tuple contains exactly one value for each attribute.

It may be noted that many of the properties of relations follow the fact that the body of a relation is a mathematical set.

A strong entity is any powerful force or presence, whether it is meant to mean some sort of deity, a high power such as a government or a business, or even an individual or group, etc.

The DBA for a database is the Database Administrator. The DBA's roles are to manage the installation and configuration of the database software, to manage the allocation of space, to manage security, and (in concert with the developer) to manage data organization and query optimization. There are other roles, such as supporting backup and recovery, but this is just a small list.

For practical matters there is no limit. However some DBMS, e.g. Sybase, have a limit of maximum 50 nesting levels and a maximum of 50 subqueries in each side of a union. However, for practical purposes is difficult to believe that there is a use for a query that involves 5o subqueries.

Jose D. Montero