6. Conclusion
Today, most database software (DBMS) is based on the relational model. A database is seen as a set of tables, structured according to normal forms and manipulated using non-algorithmic languages, the best-known representative of which is SQL.
This article successively presents :
the table normalization process to avoid data inconsistencies during updates;
operations on tables to extract the required data ;
SQL language for expressing retrieval queries ;
implementation of SQL queries in an application program written in Java.
The relational model is well suited to describing data in business applications. However, multimedia applications handling complex objects require more elaborate...
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Conclusion
Also in our database
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
The Ultimate Scientific and Technical Reference