Create the above database using your existing SQL skills. You will need at least eight opinions about

waterskis. At least three posts should be replies.

At least one of the posts should be written by somebody called user30356745.

Invent or discover your own data. Cite data sources appropriately in your report, or alternatively include a

source field in your database.

Submit your SQL file as part of your assignment.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

· Overview

· Objectives

· The General Approach to executing the project; if your company employs a formal project management methodology, what components will you include and which will you exclude… and why? if your company employs a formal project life cycle, what components will you include and which will you exclude… and why?

· Contractual aspects

· Identify your sponsor and stakeholders, explaining when and how you will communicate with them

· Identify the high-level scope of the project and what problems and challenges need to be addressed as part of the project

· Explain what quality means in the context of this project and how you will ensure that quality; explain your evaluation methods

· Discuss theresources you will need to complete the project, remembering that resources are not just people – they can be equipment, office space, special software packages, etc.

· Discuss how you plan to manage issues and requested changes to the project’s scope

· If your project will need to engage vendors, explain your process for vendor selection and management

· The Plan for Logistic Support and Administration

· Discuss any training requirements

· Based on Past Experience and documented ‘Lessons Learned’, what problems do you foresee arising and how do you plan to deal with them if they do arise?

Project Sub-Plans

In many cases a project plan includes a number of sub-plans that address key components of project activity. For your project, you’ll need to draft two sub-plans and include them as appendixes:

Risk Plan

The purpose of the risk plan is to identify the key risk that can threaten your project and present your approach to addressing these risks. For this assignment you should identify 5-10 risks and include the following for each:

· what the risk is

· how likely it is to occur

· what would be the severity of consequences if it did occur

· how the project team will monitor for the risk

· the mitigation plan and its cost if the risk were to become a reality

Communication Plan

The project communication sub-plan is a description of the routine and emergency communication procedures that will be used during the project. You should include the type and frequency of all the following that apply:

· full project team meetings

· project technical team meetings with team leads

· status checks

· updates of project documentation

· updates to management and/or executives

· reports from project technical leads to the project manager

Also include how emergencies are to be communicated both up and down the project hierarchy.

Project Budget

Include as an appendix your project budget. The budget should be an Excel spreadsheet, where you will document all of the costs associated with your project – people costs, vendor costs, costs of supplies, etc, as well as 25% of the total mitigation costs of your risks which should be noted as a “contingency fund” Provide some detail as to how you came up with your figures, but for the purposes of this course, not too much detail. One page should suffice unless you feel you need more space. Be clear that a four-line budget encompassing the items mentioned above in this paragraph is NOT sufficient.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

The principle tool that most managers now use to increase the reliability of their product offering is a. the TQM philosophy b. the Six Sigma methodology c. the Deming Principle d. Feigenbaum and Juran's system of quality

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

A physician office (private practice) approached you in an effort to convert their paperwork process into a health information database. The physician provided a copy of the paperwork used in the office to collect patient information. The physician also explained the need to secure patient information according to HIPPA rules and regulations. Additional information will be provided upon request.

The physician would like to add to patient records results from labs and imaging. In addition, the physician would like to link with a list of pharmacies in the area and send patient prescription electronically. As a database expert you will be developing patient database and all required tables using relational database approach.

Requirement:

1. Analyze the provided forms below identifying the entities that should be tracked in the system.
2. Identify the fields (attributes) associated with each entity, listing possible candidate keys (determinants). Note: you don’t have to list all fields in the form just select the most important 10 fields.
3. Based on your analysis and the given forms identify all possible functional dependencies (remember that those functional dependencies will not only assist in creating the proper tables but also will assist in understanding relationships between tables).
4. Select a primary key for each entity. If none of the candidate keys is numeric and unique create a surrogate key that suites the entity.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"