Skip to main content
Bumped by Community user

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

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

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.

Source Link
Jeff
  • 1
  • 1

Expressing A Composite Key in a Data Dictionary

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