edited by
303 views
0 votes
0 votes
Describe the differences in meaning between the terms relation and relation schema.
edited by

1 Answer

0 votes
0 votes
  • A relation is simply you, with your mass and skeleton whereas a schema is simply your skeleton, it will get clear in the next point
  • For example, this is a table
    ID (Integer) Name (String) Address (String)
    102 Yonezawa Akinori Naha, Okinawa
    202 Murata Makoto Sendai, Miyagi
    104 Sakamura Ken Kumamoto, Kumamoto
    152 Matsumoto Yukihiro Okinawa, Okinawa
  • For example, this is schema of the above table
    ID (Integer) Name (String) Address (String)
  • You can also understand it as, schema is blueprint design, and relation is the actual model
  • Hence, "create" will define schema, and hence, an empty relation

Related questions

–1 votes
–1 votes
0 answers
1