As I said previously I have to do things as my lecturers want until June 8th so Advanced Databases, creating a model for international crowdfunding..
I have the following three tables: Project ----------- projectID <<Primary Key>> title catagory <<Foreign Key>> customer -------------- personID <<Primary Key>> forename country <<Foreign Key>> restrictions --------------- country <<composite Primary Key>> category <<Composite Primary Key>> ageRestricted genderRestricted My lecturer is saying that the composite primary key must be accessible without needing reference to two tables.. In ERD/UML is there anything wrong with having a look up table referenced from two other tables? Thanks for any pointers google has let me down as has the databases groups on facebook... Adam. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cwlp265mb0099a2ab7ea020cc04529251a6...@cwlp265mb0099.gbrp265.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
