Suppose you are the manager of social media policy for an organization with 1,000 employees in seven 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.

c. Fill your database with the sample data in the Word document Ch08Ex01_E7e.docx. EmployeeID is a unique identifier; a null value for EndDate means the blog is still active. Do not retype this data; import it instead. You can either import it several times, each time to a different table, or you can import it once and use queries to fill the tables.

d. Create a report that is suitable for the CEO’s needs.

Justify the content and structure of your report.