Widget Sales Company and Project Management

Widget Sales Company Project

Project Manager

The project manager oversees the scheduling of tasks and their execution within the stipulated timelines to remain within the budgetary limitations. The activities are scheduled procedurally according to the process of developing a website. Activities that do not have dependencies will be executed simultaneously, while those with a dependency will be executed independently. The table below shows the different project activities schedules.

Description

Start Date

End Date

Dependencies

Project Duration

Requirement’s Analysis

None

Planning Meetings

Project Requirements

Sitemap and Wireframe Creation

Project Requirements

Defining Database Tables

Sitemap and Wireframe

Web Architectural Design

Database tables defined

Design of the User and graphical Interface

Website Architectural Design

Coding

Project functional Requirements

Testing

Created Website

Website Hosting and Testing

Created Website

Launching

Created Website

Database Analyst

The data scientist will develop the database and define the different variables as well as their restrictions. The data types will be strings, Boolean, dates, integers, floating-point numbers, or arrays (Ma et al., 2016). The variable name, the data type, and restrictions of data captured as follows.

Table Name

Variable

DataType

Restrictions

Employee

EmpName

String

None

Employee

ExpensesAllowed

Boolean

Only Yes or No values

Expenses

HotelArriveDate

Date

Valid date

Expenses

HotelDepartDate

Date

Valid date, greater than arrival date

Expenses

RoundTripAirfare

Integer

Validate Int, Less than max

Expenses

Parking Fees

Integer

Validate Integer, Less than max

Expenses

TaxiFees

Integer

Validate Integer, Less than max

Expenses

SeminaRegistrationFees

Integer

Validate Integer, Less than max

Expenses

HotelExpenses

Integer

Validate Integer, Less than max

Expenses

Breakfast

Floating Point Number

Validate Float, Less than max and departure date

Expenses

Lunch

Floating Point Number

Validate Float, Less than max and date of departure

Expenses

Dinner

Floating Point Number

Validate Float, Less than max

Expenses

ParkingDays

Integer

Valid date, Less than the departure date

Total Expense

Sum

Array

None

Developer

The website will have 5 pages for different staff expenditure. The home page will have the name of the employee’s details and the business trips they have been on. The second page will have hotel inventory and the time for departure and arrival from the trip, including the date and time of check-in and check-out. The second page will include daily expenses. The third page will be on the expenses incurred in a day, such as dining, transport, and seminar registration fee. Page four will be highlighting reports of an employee’s expenditure while on a business trip. Page five will an about page that that highlights the Widget Sales Company. The project will require the use of function and parameters to calculate the daily allowable expenditure and calculate the sum of an employee’s total expenditure on travel (Bassi, 2007). The functions and parameters used in the project will be as follows:

def hotel(days):

· Calculates the maximin allowance for the hotel expense using MAX_DAILY_FEE * days

· Gets the hotel fee from the user

· Adds the hotel fee to total expenses

· Determines if the hotel fee above the amount allowed

· Returns the allowable hotel expense

def taxi(days):

· Calculates the maximin allowance for the taxi fee using MAX_DAILY_FEE * days

· Gets the taxi fee from the user

· Adds the taxi fee to total expenses

· Determines if the taxi fees excess of the amount allowed