Posts

Showing posts from January, 2024

Schema in computer science

Image
Schema  πŸ‘‡     πŸ‘‰πŸ»Schema is logical representation of a data base.It is also known as entity type. Schema like a structure in which one or many tables lie.  E.g. :- πŸ‘‰πŸ»        Student(AGE,ROLL NO.,REG.NO.,CLASS)   Here Student is an entity & other materials are attributes.   πŸ“šπŸ—ƒ️Now talking about   How many types of schema :-   There are three types of schema:- (i) View  Schema (ii) Conceptual Schema  (iii) Physical Schema  View schema :-( External level schema):- πŸ‘‰It is also known as View level. View schema defines the design of database at the view level of data abstraction. It defines how an end user will intract with the database system. (There are many view schemas for database system .Every schema defines a specific group of data.  In other words we say like a Student entity represent specific attributes and other entities like Faculty, Infrastructure and so on represents specifi...