Progress report

Introduction
This report is my first progress report and I will briefly discuss and explain my assignments, task, projects and achievements that I am involved in during my coop period at Rashed Abdul Rahman Al-Rashed & Sons Company at HRIS department from the first to the eighth week.
Here is the list of topics that I will be discussing in this report: 1- SQL Server 2- OFOQ ERP System (Time Management) 3- Project
SQL Server
From the first day of my coop, my supervisor gave me an SQL database and a Microsoft SQL course CD to practice SQL. It took me a week to refresh and to get back on the right path. Moreover, he also gave me a documentation that has all of the information about the joins between the tables, so I can fully understand how to generate meaningful reports to the management. The next two weeks were about maintaining the database and how to perform a periodical database backup as figure 1 illustrates.

Figure [ 1 ] SQL Backup Job
OFOQ Human Resource System (Time Management)
The company have two ways to record the employee’s attendance. First, by using the gates that are near the elevators. Second, by using the finger scanner. Both ways have two distinct servers to record the attendance. I was fortunate enough to take charge of extracting the log files of attendance from both servers and then upload them to the HR system as a daily task Figure2. Sometimes, the employees forget to login in or logout and the system does not know how to fix this conflict, because for every login there have to be a logout. I am able to resolve this conflict because they trained me to use the system for more than two weeks.

Figure 2OFOQ HR System Time Management

Project
The Database Administrator (DBA) proposed the idea of my project, which is about a mobile portal for the company’s archiving system that will allow the