PDA

View Full Version : What is Schema and its types?



Joylinford
07-17-2017, 02:17 PM
What is Schema and its types?

reckonbilling
07-18-2017, 02:06 AM
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects. You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

XML schema
Flat file schema
Envelope schema
Property schema

fayeseom
07-18-2017, 04:25 AM
A schema is nothing but a collection of objects
Types of schemas:
-- Star schema
-- Snow flake schema
-- Galaxy schema (or)integrated schema (or) constellation schema

johnsmith8446
07-18-2017, 06:20 AM
there are lots of types available for schema but i know some types i.e Snow flake schema,Star schema etc

deepakrajput
07-18-2017, 06:26 AM
A group of objects is known as schema.