I am looking for an example of expressing a "Composite Keys" in a data dictionary.
I am using an MSO Access application with a Lecturer Table and Subjects Table where I have taken the Primary Keys from their tables to create a table called Timetable.
From the information building the database file I must create a Data Dictionary but was caught off guard when I had to question myself in explaining the referencing of these two fields that create them as a Composite Key.
My "Data Dictionary" is comprised of a Field Name, Data Type with Field Size, Constraints, References and Field Description.
I have found it difficult to find any subjects on this matter which is directed by how a Composite Key in a Data Dictionary may be expressed and hope I may get some ideas here.
I hope someone can help
Thank you