Data Model Assignment: Logical Data Modeling I’ve attached a “Employment Agencies” data model. List the following below in the MS Word document. all th

Data Model Assignment: Logical Data Modeling I’ve attached a “Employment Agencies” data model. List the following below in the MS Word document.

all the entities
all the attributes in each entity
the primary key for each entity
all the foreign keys
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)
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.” Data Model for Employment Agencies
Barry Williams
Database Answers
18th. September 2004
Agencies
agency_id
address_id (FK)
agency_name
agency_rating
agency_phone
agenoy_email
website_address
other_agency_details
Ret Agency Categories
agency_category_code
agency_category_description
eg Administration, IT, Tutoring
Addresses
address_id
Agency_Categories
OK agency_id (FK)
agency_category_code (FK)
Local_Offices
office_id
agency_id (FK)
address_id (FK)
office_phone
office_email
other_office_details
line_1_number_building
line_2_number_street
line_3_area_locality
city_town
state_province_county
country
other_details
Contacts
contact_id
office_id (FK)
date_last_contact
first_name
middle_name
last_name
gender
contact_phone
contact_email
contact_from_date
contact_to_date
other_details

Purchase answer to see full
attachment