ASSUMPTIONS:
1. Each CONGRESS_PERSON can represent one district and one district is represented by one CONGRESS_MAN.
2. Bill is sponsored by one CONGRESS_MAN.
3. Every BILL has different name.
Above schema has three entity types
1. US_STATE_REGION: represents states and regions in US
2. CONGRESS_PERSON: who are elected from various regions and are related to US_STATE_REGION by relationship REPRESENTATIVE.
3. BILL: each bill is related to CONGRESS_PERSON, who presents it and is voted by all CONGRESS_MAN.
6. Design an ER schema with attributes, primary keys, cardinalities and participation constraints if appropriate. For...
Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...