Exploring various database objects
There are several database objects you will work with consistently as your database portfolio expands during your career of creating and working with databases. These objects are as follows:
- Tables: Tables are the base objects in databases and are used to store static data. Tables contain records, which have one or more fields that display properties of the data. These tables should be designed around the Third Normal Form to ensure efficient data storage. All foreign keys, along with their constraints and indexes, should be created to ensure data integrity and speed of use.
- Views: Views are SQL queries that are stored in a permanent state in the database and can be used by other objects or external applications. They can consist of one or more tables with criteria filtering; however, they do not accept parameters. In certain conditions, they can be updated, though usually, they are read-only.
Now, let's learn how to work with...
