Advertisement

Database Schema

What does Database Schema mean?

A database schema is a visual and logical architecture of a database created on a database management system.

It provides a graphical view of the entire database architecture and structure. It provides a means for logically grouping and displaying database objects such as tables, fields, functions and relations.

Advertisement

Techopedia explains Database Schema

A database schema typically shows the different tables, their fields and the relationship between them and other tables. The database schema is defined within the native database language; therefore the logical structure and visualization of schema might vary in each database language. It helps database administrators in understanding the architectural layout of the database.

In addition to tables and fields, a database schema defines a database's:

  • Indexes
  • Views
  • Triggers
  • Database links
  • Events
  • Procedures
  • Functions
Advertisement

Share this Term

  • Facebook
  • LinkedIn
  • Twitter

Survey: Why Is There Still a Gender Gap in Tech?

Do you work in the tech industry? Help us learn more about why the gender gap still exists in tech by taking this quick survey! Survey respondents will also be entered to win a $100 Amazon Gift Card!

Related Reading

Tags

DatabasesData ManagementEnterprise

Trending Articles

Newest Articles

Go back to top