![]() We need to create a conceptual schema before we even start with the physical schema within the DBMS. Schema is used in psychology to describe an organised pattern of thought or behaviour that organises categories of information and the relationships among them.īefore designing a database, we also need to look at the categories of information and the relationships among them. The word schema originates from the Greek word skhēma, which means form, figure, shape, or plan. It has different connotations within different contexts. If you were confused before, hope I haven’t just made it worse… Broad MeaningĪnother reason for the confusion is probably due to the fact that the term schema has such a broad meaning. The ISO/IEC 9075-1 SQL standard defines a schema as a persistent, named collection of descriptors. So, depending on the RDBMS you use, schemas and databases may or may not be the same thing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |