Results 1 to 10 of 10

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
    69

    Default Re: what is database schema?

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

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

    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
    273

    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
    114

    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
    Member
    Join Date
    Nov 2016
    Posts
    92

    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
    Newbie
    Join Date
    Jul 2017
    Posts
    2

    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
    Member Ashley234's Avatar
    Join Date
    May 2017
    Posts
    97

    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
    7

    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.....