Design a simple protocol document
Course:- Database Management System
Reference No.:- EM132138154

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Database Management System

Assignment -

Scenario: Setup a Mock Phase 3 Clinical Trial for evaluating the efficacy of a Blood Pressure/Weight Loss/ or Muscle Strength Enhancement supplement. Assume that the testing takes place at a physician's office with a nurse taking down the details. Bonus marks of 5 points will be given for students coming up with a Sample Size calculation as to the number of patients/subjects required for a specific effect size.

Part 1: Design a Case Report Form for the above scenario to include demographic and pertinent clinical information. Do include at least two types of data: from physical measurements and from a survey questionnaire. You can use Microsoft Excel or MS Word or any Form Designer software (such as Adobe Acrobat) and submit the document.

Part 2: Design a simple Protocol Document (no more than 5 pages) with a PI and Co-PI and a data management plan based on an existing clinical trial protocol but do cite the source. Submit the Protocol as a MS Word Document. Include a SOP for at least one type of data measurement from the patient/subject.

Part 3: Design and implement a relational database using Microsoft Access or MySQL. Submit the Relationship Diagram and the images of the forms used to capture data from the Case Report Forms in part 1. If you are using Microsoft Access you can also submit the .mdb or .mdbx file instead of the relationship diagram and images.

Part 4: Delineate the project details for the Scenario listed above with the stakeholders, task plan using a WBS and a Gantt Chart for the time duration indicated for the entire project up to submission to the Statistical Analysis Group. You can use and submit a MS Excel Worksheet for both the WBS and the Gantt Chart you have compiled.

Part 5: List the GCP guidelines applicable to the clinical trial you have designed and submit it as a MS Word document.

Part 6: Using the checklist provided in the CONSORT Website: select and compose at least three elements (from the checklist) of relevance to your trial and with some mock results (if needed). Submit the document as a MS Word file.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
In short, there is a need for a more convenient database system. The machine on which the database is currently running is powerful enough to host the database server. The d
Design a clean and normalized database that handles books for a library application. You need to consider the following rules before you design the database: Analyze and ide
Create a form or forms that will allow users to maintain the tables, so that they can add or edit existing records. Create a report that lists all accounts, include any other
Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done.  Explain the three factors that influence the cost of a query
Explain Business Intelligence in three to four paragraphs. Focus upon what it is, its architecture and purpose - Discuss business analytics and data mining tools including the
Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-
Analyze how the verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is
Draw a fully-labeled ERD that includes entities, labeled relationships (indicate whether each relationship is mandatory or optional), primary keys, foreign keys, and cardina