Results 1 to 18 of 18

what is database schema?

This is a discussion on what is database schema? within the Programming forums, part of the Web Designing & Development category; what is database schema?...

  1. #1
    Junior Member
    Join Date
    Jun 2017
    Posts
    28

    Default what is database schema?

    what is database schema?

  2. #2
    Member
    Join Date
    Dec 2015
    Location
    Guangzhou,China,51000
    Posts
    85

    Default Re: what is database schema?

    A database schema is the skeleton structure that represents the logical view of the entire database.

  3. #3
    Senior Member yatishkumar's Avatar
    Join Date
    Jul 2017
    Location
    Bangalore
    Posts
    100

    Default Re: what is database schema?

    The term "database schema" can refer to a visual representation of a database, a set of rules that govern a database, or to the entire set of objects belonging to a particular user.

  4. #4
    Senior Member
    Join Date
    May 2017
    Posts
    477

    Default Re: what is database schema?

    The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).

  5. #5
    Member
    Join Date
    Jul 2017
    Posts
    35

    Default Re: what is database schema?

    database schema is skeleton structure which describes about the visual view of structure table like the table creation with column name and its tuple.

  6. #6
    Senior Member
    Join Date
    Nov 2016
    Posts
    152

    Default Re: what is database schema?

    Agreed completely.

    Quote Originally Posted by yatishkumar View Post
    The term "database schema" can refer to a visual representation of a database, a set of rules that govern a database, or to the entire set of objects belonging to a particular user.

  7. #7
    Senior Member
    Join Date
    Nov 2016
    Posts
    150

    Default Re: what is database schema?

    Database schema represents the logical structure of the entire database..it defines how the data is organized and how the relations are among them are associated..

  8. #8
    Junior Member
    Join Date
    Jul 2017
    Posts
    14

    Default Re: what is database schema?

    A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of aschema 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.

  9. #9
    Senior Member Ashley234's Avatar
    Join Date
    May 2017
    Posts
    336

    Default Re: what is database schema?

    The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.

  10. #10
    Junior Member
    Join Date
    Jul 2017
    Location
    India
    Posts
    17

    Default Re: what is database schema?

    A database schema is the skeleton structure that represents the logical view of the entire database.A database schema defines its entities and the relationship among them. It contains a descriptive detail of the database, which can be depicted by means of schema diagrams.....

  11. #11
    Senior Member
    Join Date
    Nov 2016
    Posts
    152

    Default Re: what is database schema?

    Nice explanation.

    Quote Originally Posted by Ashley234 View Post
    The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database.

  12. #12
    Member
    Join Date
    Dec 2016
    Posts
    36

    Default Re: what is database schema?

    Thanks For Your Information.

  13. #13
    Member
    Join Date
    Sep 2017
    Posts
    53

    Default Re: what is database schema?

    Very well described. Thanks For Your Information.

  14. #14
    Newbie
    Join Date
    Feb 2018
    Posts
    3

    Default Re: what is database schema?

    Same to you

  15. #15
    Member
    Join Date
    Mar 2018
    Location
    Santa Clara, California, USA
    Posts
    40

    Default Re: what is database schema?

    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.

  16. #16
    Junior Member
    Join Date
    Apr 2018
    Posts
    15

    Default Re: what is database schema?

    A schema defines attributes of the database, such as tables, columns, and properties. A database schema is a structured description of the elements that comprise a specific database and the relationships between those database elements.

  17. #17
    Senior Member
    Join Date
    Jan 2012
    Posts
    2,574

    Default Re: what is database schema?

    A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.

  18. #18
    Newbie
    Join Date
    Nov 2020
    Location
    Newark NJ USA
    Posts
    1

    Default Re: what is database schema?

    Schema is also useful for find right medicines pharmacy in your area. Schema is prefer to right online pharmacy site for who are looking for right online pharmacy.