2,019 views
0 votes
0 votes
What is the difference between database model and database schema?

 

Any useful link please....

1 Answer

Best answer
2 votes
2 votes

A schema is a blueprint of the database which specifies what fields will be present and what would be their types. For example an employee table will have an employee_ID column represented by a string of 10 digits and an employee_Name column with a string of 45 characters.

Data model is a high level design implementation which decides what can be present in the schema. It provides a database user with a conceptual framework in which we specify the database requirements of the database user and the structure of the database to fulfill these requirements.

A data model can, for example, be a relational model where the data will be organised in tables whereas the schema for this model would be the set of attributes and their corresponding domains.

http://globin.cse.psu.edu/globin/html/docs/schema.doc.html

selected by

Related questions

0 votes
0 votes
0 answers
1
LavTheRawkstar asked Apr 14, 2017
2,216 views
what is the difference between Vertical and Horizontal fragmentations.If Data objects replicas are stored at multiple number of sites, Explain how the lock will be acquir...
0 votes
0 votes
3 answers
3
learncp asked Sep 5, 2015
588 views
What is the difference between the following two expressions, conceptually and  in terms of relational algebra ?1. names of girl students with more marks than some boy s...