understanding of database

 Database: -

A collection is a group of information that has been organized in such a method that it may be quickly searched, controlled, as well as modified. In all other senses, the knowledge is formatted in such a form in which it can be processed. (Valcheva)

Advantages of Database

• Lowering reporting mistakes and increasing stability

• Enhanced customer information accessible via the use of multitude & of query languages.

• Better information privacy.

• Lower expenses for entry of data, retention, and querying.

• Competing requirements may be managed (Thakur).

Primary key: -An essential key is utilized to guarantee information in the particular segment is one of a kind. This is a component that cannot have defective characteristics. It can either be the main table part or a fragment constructed deliberately by the database, as denoted by a characterized succession.  (SHUBHAMSINGH10, 28 MARCH2020)

Foreign key: - This key is component or grouping of parts in an interpersonal data set worktop that connects data from two tables. It is a category (or segments) that refer towards another table's subsector (usually the important key). (SHUBHAMSINGH10, 28 MARCH2020)

(Valcheva)

 

References

SHUBHAMSINGH10. (28 MARCH2020). Difference between Primary Key and Foreign Key. geeksforgeeks.

Thakur, D. (n.d.). Advantages of Database. ecomputernotes.

Valcheva, S. (n.d.). Database: Meaning, Advantages, And Disadvantages. intellspot.