Suppose you are the manager of social media policy for an organization with 1,000 employees in sever

Suppose you are the manager of social media policy for an organization with 1,000 employees in sever different offices throughout North America. Further suppose that the CEO has requested a report showing a list of all of the employees’ blogs, the employees’ job titles and departments, and the purpose and URL of each blog. She doesn’t want to control employees; she just wants to know where they are.

a) Explain the conditions under which using a spreadsheet to track this data would be appropriate.

b) Suppose employees can have more than one blog but that a blog is only supported by a single employee. Further suppose you decide that you need to track the dates on which a blog was first created and the date of the last posting if the blog is no longer active. Design a database for these requirements.

1. Fill your database with the sample data provided below. Employee ID is a unique identifier; a null vale for end data means the blog is still active.

EmployeeID

EmployeeName

JobTitle

Department

BlogPurpose

URL

StartDate

EndDate

100

Maple

Marketing Analyst

Marketing

Industry Trend Reporting

Blog1.OurCompany.com

10/11/2013

7/15/2015

200

Wu

Senior Engineer

Engineering

New Technology

Blog7.OurCompany.com

5/19/2014

1/17/2016

300

Seward

Customer Support Rep

Customer Support

FAQ

Blog19.OurCompany.com

7/18/2015

400

Jackson

Customer Support Rep

Customer Support

Advanced FAQ

FAQBlog.OurCompany.com

3/15/2016

100

Maple

Marketing Analyst

Marketing

Innovative Product Use

Blog14.OurCompany.com

12/17/2015

200

Wu

Senior Engineer

Engineering

Product Redesign

WuBlog9.OurCompany.com

2/27/2015

500

Ackroyd

Product Manager

Marketing

Product Launch

NewProduct.OurCompany.com

2/27/2015

7/15/2016

100

Maple

Marketing Analyst

Marketing

Product Launch

NewProduct2.OurCompany.com

2/15/2015

3/31/2016

100

Maple

Marketing Analyst

Marketing

Customer Stories

Blog17.OurCompany.com

5/15/2016

400

Jackson

Customer Support Rep

Customer Support

Technology Trends

JBlog14.OurCompany.com

7/19/2015

2/15/2017

2. Create the relationship between entities.

3. Create a query that shows all active blogs.

4. Create a query that shows non-active blogs

5. Create a report that is suitable for the CEO needs. Justify the content and the structure of your report.

** Must use Microsoft Access!