Question

The owner of a small chain of appliance stores wants to build a database to help track data about its regions, stores, employees and jobs.  The chain has divided the map of where its stores exists into various regions. Each region has a description (of boundaries).  Each store is named, has an average market size (expressed in dollars) and belongs to s specific region. Each store also has an address, city, state, and zip.  The database should capture the employee's name, address, date of birth, and the position (job) held.  A job has a title, a description, a starting pay rate and pays hourly or a salary.  Each store belongs to one and only one region. Regions have one or many stores.  Each store employs one to many employees – though each employee is assigned to only one store.  Each employee only has a single job title (at any given time) – though many employees may share the same job title.  Use Word – and draw a conceptual model for this planned database. Identify tables, attributes, keys and relationships

need word document with the conceptual design and Access Database that implements the conceptual design by creating the tables, PK's, relationships and enters a few rows of data into each table

Answer 1

i have uploaded the screenshots of the work i have done in ms word ..

region store Employee job STORETABLE O Type here to search 臼 ENG 0405 US 02-02-2018

Page 2cfz, MARKET RESION TABLE abGKIN TAHLE.tinlutas: r삐tKH1,cuscriptacr1 IP MART KEY; ruger11 O Type here to search ENG 0405 US 02-02-2018
store_name acts as a relation between store and market region tables.

employee_name acts as a relation between employee and position held tables.

job_title between job and position held tables.