I need help understanding exactly what this project is asking me to do. From what I understand, I am adding on to the database that I created in a previous project. I need to create statements that create the desired tables and then creating views for specified people.

 

CSIS 375FINALPROJECTINSTRUCTIONSInstructions:General Background Information:CMS Systems, Inc. is a company that provides information systems consulting services tocompanies in the telecom industry in the United States and the United Kingdom. Due to itssuccess, CMS is hoping to expand its operations into other parts of Europe. Despite its large size,CMS currently uses a manual/spreadsheet-based process for maintaining employee hoursworked, employee benefits, employee payroll, project management, and customer billing. It alsouses a file based system to manage its legal documents and other client information.Management has now decided to implement a company-wide application that will keep track ofall of its employee, project, and client information. Employee information will include suchitems as employee name, address, hire date, and salary. It will also keep track of employee hoursspent working on various projects, employee benefits, employee payroll, and produce invoicesfor clients based on hours worked by employees. Client information will include such items asclient name, legal location (i.e., country), billing address, office locations, client contactinformation , and contracts associated with each client. Project information will also have to bemaintained, which will keep track of employee assignments to projects.Employee ManagementCMS currently employs 1,500 individuals (900 in the US and 600 in the UK) who serve assystems analysts, developers, managers, testers, maintenance engineers, accountants, lawyers,sales representatives, and office staff.The new system will enable the Human Resources department to maintain all employeeinformation such as name, address, hire date, termination date, emergency contact information,marital status, tax withholding information, 401 K participation, insurance participation, othertax-related deductions, and salary/wage rates.Only members of the Human Resources department will be allowed to edit employeeinformation.Recording Hours WorkedAll CMS employees must keep a record of the time they spend working for each client on aweekly basis. Because employees can work for more than one client and perform differentfunctions for each client, CMS utilizes “project management” to keep track of employeeassignments to client contracts. Employees can be assigned to work on more than one project at agiven time. In fact, it is not unusual for an employee to spend time on two or more differentprojects within the same day.Page 1 of 6

Attachments:

• 1495614174-Final_Project_Instructions1-1.docx