Before you start the project... For this project you will be developing a Microsoft SQL Server database for the following fictitious case study. The case study describes the information needs of an organization, as well as the ways in which the data are currently stored and retrieved. Your database will replace the current system. The JC Data.xlsx Excel spreadsheet (note there are two tabs) represents the current system being used as well as all the historical data. Deliverable Checklist a Database Diagram (.png or pdf) 0 Database Create Script (sql) D Six screenshots (queries + results) as png within a Word file. O Six SQL query scripts (.sql) Project Case Study JC Information Consultants is a software development firm employing about 35 computer professionals. Each programmer is assigned to a programming project, but may be assigned to only one project at a time. Programmers may work on many projects over a period of time. Each project is headed by a project manager. JC Brotherson, the founder and president, oversees all current projects and actively markets the firm's specialties to local businesses and government entities. There are two technical writers and two software librarians. There is one administrative assistant (YK Proffitt) who handles all personnel paperwork (like keeping track of who is working on which project at any time) as well as issues which involve the organization of the company's working space. The information system will assist YK The following reports are required: Project list This is a printed reference sheet used by JC and YK. It includes the project name, the project's color (used to flag the project's paperwork), the beginning date of the project, the projected end of the project, the number of remaining days for the project (relative to the current date). Project Assignments list This is a report to for employees who have been assigned to more than one project. The query lists the project name, the first and last names of project team members, their project begin and end dates as well as their position (role) on the project. "A view must be used for this query