For the data model Employment Agencies, copy and paste that data model graphic into your paper using MS Word

Subject:Computer SciencePrice: Bought3

Share With

For the data model Employment Agencies, copy and paste that data model graphic into your paper using MS Word. (I attached graph to the Question) In the MS Word document, list the following:

1. all the entities
2. all the attributes in each entity
3. the primary key for each entity
4. all the foreign keys
5. all the relationship cardinalities between entities (e.g., a professor can teach one to many classes; an individual class is taught by one and only one professor)
6. for each relationship between entities, specify the name of the attribute in one entity that will be used to match to an attribute in a related entity, including the specific attribute name in the second entity that is used for the matching. For instance, in a school data model: “The Student_ID attribute in the Registered_Class entity is used to match to the Student_ID attribute in the Enrolled_Student entity.”

Submit your MS Word document. 

Resources:

• Textbook: Module 3 – The Relational Data Model
• Video: Module 3 – Relational Database Tables and Their Characteristics (3:13 min.)
• Video: Module 3 – Relational Database Keys (1:48 min.)
• PowerPoint: Module 3 Review charts
• Textbook: Module 4 – Entity Relationship (ER) Modeling
• Video: Module 4 - Entity Relationship Diagrams: Part I - Entities and Attributes (3:46 min.)
• Video: Module 4 - Entity Relationship Diagrams: Part II Identifiers (1:19 min.)
• Video: Module 4 - Entity Relationship Diagrams: Part III Relationships (3:54 min.)
• Video: Module 4 - Entity Relationship Diagrams: Part IV Relationship Degrees (2:13 min.)
• Video: Module 4 - Entity Relationship Diagrams: Part V Associative Entities (1:19 min.)
• PowerPoint: Module 4 Review charts