f22-final

A key attribute:  Group of Choice:    A. identifies a column B. can only be one column C. uniquely identifies a row

write access model Only Leena can access her laptop. The website can be accessed only during work time The file is a read-only file. Only course instructors can access students' data.

Question 56

EXPERIMENTAL PROCEDURE   Patients visit the hospital and their visit history is maintained by the hospital staff. Different physicians may be available on different dates. They diagnose and treat the patients of all categories. Some of treatments are free while others are to be paid by the patients. Sample data of the case is shown in the following chart.   Patient History Report PatientID Name Address Visit Date Physician Diagnosis Treatment P-100809 A City: X 12-02-2007 20-02-2007 29-02-2007 15-03-2007 Dr. Z Dr. F Dr. R Dr. L Chest Infection Cold Hepatitis-A Eyes Infection Free Free Paid Paid P-200145 N City: Y 10-01-2007 15-02-2007 25-03-2007 Dr. L Dr. K Dr. A Bone Fracture Cough Flu Paid Free Free     Task 1                     Draw a dependency diagram and transform the above data to first normal form by eliminating repeating groups such that each row in the relation is atomic. Be sure to create an appropriate name for the…

Use Mysql code The database has three tables for tracking horse-riding lessons:   Horse with columns: ID - primary key RegisteredName Breed Height BirthDate     Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress     LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key   Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.

Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.

Question: True or False 1) the data in an excel table can be sorted into both, ascending and descending order. reqiured: please answer this question by giving the correct answer by stating whether this statement is true or false

Alreej College Computer Application Student Name Student_ID Math En Ahmed Omar Huda 20f20 45 10 35 20f21 50 45 45 Muhmmed 20f22 20f23 20f24 20f25 46 20 50 Amira 50 35 50 Huda Ahemd 20 50 33 Noora Ali 33 45 46 Figure-1 1) Prepare and format your MS-Excel Document as shown above. 2) The total number of student marks for each Module during the semester needs to be calculated. Explain how you will do it. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations. 3) Explain how you will calculate the Average for each students. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations.

Course Title: Data Structure and Algorithms Question  A table stores the data for all the members of an exotic resort. Members are identified by these numbers 1,5,30,70,80,20,15,100,40,25,7,3,8,33,22.   All members are to be invited in a meeting to review the membership policies. What will be the fastest way to call all the members? Write algorithm to justify your answer.