Scenario: You have been tasked to create a database for a company that specializes in experimental drug studies for phar

[answerhappygod]

Scenario: You have been tasked to create adatabase for a company that specializes in experimental drugstudies for pharmaceutical companies. These drug studies help toget the drugs FDA approved for going to market. The studies aredouble blind meaning the patient and the doctor both do not knowwhether the patient is on active or placebo drug.
The front-end information will be gathered by phone, app or website and passed to your database. You only have to handle the dataand record it in the proper tables.
Your database will handle 2 studies being conductedsimultaneously for the same pharmaceutical company, AcmePharmaceuticals. The study identifiers will be 12345 and 54321.Study 12345 will use a random pick list for assigning treatment topatients. This means the random codes will be distributed by goingdown the list in sequential order. Study 54321 will use a randomgenerator to assign treatment but each treatment, active andplacebo, cannot outnumber the other by more than 2 patients. IE ifthere are 6 patients on active and 4 on placebo the next patientmust be put on placebo so the numbers are 6 and 5. If the randomgenerator picks active in this case the numbers would go to 7 and 4which is more than 2.
Each study will have 3 sites in which patients can be enrolled.The site data collected will be Site Number (3-digit pre-assignedcode), Name (Doctor or Hospital name), Address, City, State, Zip,phone number
The following information must be stored for both studies. Forpatients, the Patient Number (this will be a 6-digit number in thesite number-sequential format, IE first patient from site 251 willbe 251001, 2nd will be 251002, etc.), DOB, Gender,Weight will be collected.
The visits for both studies will be as follows: The Doctor willperform testing on the patient (Screening). When the test resultsare returned, if they are positive the patient can continue in thestudy (Randomization), or if test results are negative they will beremoved from the study (Withdrawal).
Now that you have all of the tables and data you need, here arethe instructions for the rest of the project.
DECLARE @intPatientID AS INTEGER =0;
EXECUTE uspAddPatient @intPatientIDOUTPUT, 111001, 2, '1/1/1962', 2, 205
Here are some hints that will hopefully help you create thisdatabase.
DECLARE @StudyID as INT
Begin
DECLARE StudyCursor CURSOR LOCAL FOR
SELECT StudyID FROM V_PATIENT_STUDY
WHERE PatientID =@intPatientID
OPEN StudyCursor
FETCH FROM StudyCursor
INTO @StudyID
End