Question: Consider the schemas for the table people and the table s

Consider the schemas for the table people, and the table’s students and teachers, which were created under people, in Section 9.3.Give a relational schema in third normal form that represents the same information. Recall the constraints on subtables, and give all constraints that must be imposed on the relational schema so that every database instance of the relational schema can also be represented by an instance of the schema with inheritance.

View Solution:


Sale on SolutionInn
Sales0
Views275
Comments
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000