my project needs an implementation of supertype-subtype, however, we haven't tackled that topic yet at school. i know the concept of supertype-subtype, but i don't know how to write it out on mssql. i even don't know how to insert data using supertype-subtype.
here's the reqs's:
* there is a supertype named DOCUMENT. it has attributes such as DATE ISSUED, NAME OF REQUESTOR..
* one subtype is clearance
* another subtype is business clearance
now my question:
* how would i code this in mssql?
* how would i enter data if, for example, i will get a business clearance document?
please help me out. i'm completely lost.
thanks