cpage

T-SQL Using T-SQL (or ANSI/ISO SQL if you don't use T-SQL,) select all employees who work in the "Engineering" department and have a position of "Software Engineer" from the following schema. Employee Name varchar(50) EmailAddress varchar(250) Birthdate datetime Startdate datetime Enddate datetime PositionID int DepartmentID int Department DepartmentID int Name varchar(50) FoundingDate datetime Position PositionID int Name varchar(50) CreationDate datetime

Wanted to know if someone could help me solve this issue in PHP... C# (or another language used in web applications such as PHP) Using C# (or another language) and this provided Employee class: /// <summary> /// The object responsible for containing all information about an Employee /// </summary> public class Employee { private string name; private string emailAddress; private DateTime birthdate; private DateTime startdate; private DateTime enddate; private int positionid; private int departmentid; /// <summary> /// Instantiating an Employee object when we know all relevant information /// </summary> /// <param name="name">Name of the employee</param> /// <param name="emailAddress">Employee's e-mail address</param> /// <param name="birthDate">Date of birth</param> /// <param name="startDate">The day the employee started with the company</param> /// <param name="endDate">null if they are still with the company</param> public Employee(string name, string emailAddress, DateTime birthDate, DateTime startDate, DateTime endDate) { this.name = name; this.birthdate = birthDate; this.startdate = startDate; this.enddate = endDate; this.emailAddress = emailAddress; } } Write a static function which returns a list of Employee objects. Populate this list from an Employee table which exists on a database and server of your choosing. Assume an arbitrary connection string and the following schema: Employee Name varchar(50) EmailAddress varchar(250) Birthdate datetime Startdate datetime Enddate datetime