Quiz 3_ CIS 101 _ Intro Comp Their Use - El Khoury N

Set up Order [ single order ) Assign seats [ subscription ) Assign chairs Award bonus Debit Account charge credit card Mail packet

questionnn

Sample invoice is given as follows: International Conference on Mathenatical Sciences and Technology (MathTech) Invoice Date Invoice No Name : 20 January 2022 : 0001 : Muhammad Irfan Ali : Presenter Category Accommodation (Y/N) : Y Conference Fee Acconnodation Fee Total Amount Due (RM) : 1290.00 : 990.00 : 300.00 Terms & Conditions Payment is due within 30 days. Please make payment via online banking to Maths USM (RHB: 1234554321) You are encouraged to add on extra features to your program. Proceed to Part 2 only if you have completed Part 1. Part 2: Create Invoice via File Processing a. Modify the program in Part 1 to read in the file provided, File.txt. b. Use array structure in your program. c. Print all 5 receipts continuously to Dutput.txt. amusm.my Sie samms Malaysia

TABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalities

PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002MAR 27/2002APR 02/2002 01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002MAR 10/2002 08 - TETANUS VACCINATION05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001JAN 13/2002 01 - RABIES VACCINATION01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002APR 30/2002 20 - ANNUALCHECK UP12 - EYE WASH The functional dependencies that I note are as follows: Pet ID --> Pet Name, Pet Type, Pet Age, Owner Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column So, Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed. Please help me understand this.

Need perfect answer  Else skipped Perfect explanation got thumbs-up

ID Student Number Surname Name Test 1 Test 2 Test 3 Test 4 Final mark PASS/FAIL 1 217545455 Johaness Wheeler 45% 34% 49% 21% 37 FAIL 2 217452154 David Albertina 45% 34% 49% 4% 33 FAIL 3 217454151 Waldo Gertze 75% 75% 63% 88% 75 PASS 4 217486414 Kalimbo Andreas 51% 56% 90% 90% 72 PASS 5 217454155 Hakweenda Junior 44% 28% 35% 14% 30 FAIL Answer  the following  questions using the table above  Use student 2017 table to create a query that will display Student Number, Surname, Name and Pass/Fail field for all the students whose final result is "PASS". Save the query as "Pass".     Use student 2017 to create a query that will display the student's surname and final mark field for all the students whose final mark is between 0 -  40. Save the query as "Fail"         Use student 2017 to create a query that will display the student number and surname for all the students whose surname consist of letter "O" in it. Save the query as "Surname".

Complete Assignment attached using Codeskulptor3.com

Please answer only only correct with explanation.

Use the given data to classify the record below using the k-NN algorithm for k = 1 to 5. Loan Purpose Checking Repairs Savings Months Customer Employed Months 0 900 25 4 Click the icon to view the table of classified records. D Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. k Distance Classification 1 2 3 4 5 (Round to four decimal places as needed.)

true/false Both professor and assistant can create a new course (use case Create course) (  )

student name : sayem ahmed ID 011211030

#DATE TIME-TEMPERATURE UNIT HUMIDITY%9/28/2010 15:45:14 22.248900 C 44.7219689/28/2010 16:00:07 22.738900 C 50.5399939/28/2010 16:15:07 23.388900 C 49.3393389/28/2010 16:30:07 23.918900 C 47.5392809/28/2010 16:45:08 23.668900 C 40.700378The first line is just a comment, and is there to help a human understand the data that they are seeing; it should be ignored (hint:  any line beginning with '#' ought to be skipped.)   Write a program to read the data from the file and produce the average temperature and average humidity for all the records in the file. This is a very large file - it is the actual temperature and humidity data from our server room.  You would spend hours trying to do this manually, with a calculator, and you likely would make mistakes along the way.  This is where computers are far superior to humans when dealing with boring, repetitive tasks. The output of the program will look like this: Average Temperature (C): NN.NNNNNNNNNNNNNN Average Humidity (%):…

Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…

https://www.bartleby.com/questions-and-answers/in-the-written-exam-held-at-the-end-of-the-driving-license-course-50-questions-from-traffic-40-from-/c0836364-9bad-48ea-990d-a1c9ad89f7be In the written exam held at the end of the driving license course, 50 questions from Traffic, 40 from Engine, 30 questions from First Aid are asked. Passing grade in driver's license exams is 70 out of 100. A student who scores 70 and above in each course becomes successful and becomes eligible to take the driving exam. Calculate the scores according to the number of mistakes entered on the keyboard and write the program c that will show whether the student can take the steering test or not. EXAMPLE: Enter the traffic wrong number: 10 Enter the wrong number of engine: 10 Enter first aid wrong number: 10  ------------------------- Your traffic score: 80.00 Your engine score: 75.00 Your first aid score: 66.66 Sorry, you cannot take the steering test

Correct explanation gets upvote

pls help fast will answer

Search coures eneral » Final Exam, Computer Örganization 110408240, Sep 1 2021 After three logical left shifts to the value 1100100101, the answer will be PAGE

Using KNN algorithm to find the 05 similar movies from the movies below. Movie ID Movie Name IMDB Rating Biography Drama Thriller Comedy Crime Mystery History Label 58 The Imitation Game 8 1 1 1 0 0 0 0 0 8 Ex Machina 7.7 0 1 0 0 0 1 0 0 46 A Beautiful Mind 8.2 1 1 0 0 0 0 0 0 62 Good Will Hunting 8.3 0 1 0 0 0 0 0 0 97 Forrest Gump 8.8 0 1 0 0 0 0 0 0 98 21 6.8 0 1 0 0 1 0 1 0 31 Gifted 7.6 0 1 0 0 0 0 0 0 3 Travelling Salesman 5.9 0 1 0 0 0 1 0 0 51 Avatar 7.9 0 0 0 0 0 0 0 0 47 The Karate Kid 7.2 0 1 0 0 0 0 0 0 50 A Brilliant Young Mind 7.2 0 1 0 0 0 0 0 0 49 A Time To Kill 7.4 0 1 1 0 1 0 0 0 30 Interstellar 8.6 0 1 0 0 0 0 0 0 94 The Wolf of…

OM 455       Section 001       Course Grading Scale Based on Course Average:     Lower Upper Course   Limit Limit Grade   0 59 F   60 69 D   70 79 C   80 89 B   90 100 A           Midterm Final Course Last Name Score Score Average Alt 69 51 60.0 Amini 90 89 89.5 Amoako 82 78 80.0 Apland 43 77 60.0 Bachman 66 44 55.0 Corder 88 96 92.0 Desi 82 74 78.0 Dransman 58 76 67.0 Duffuor 75 89 82.0 Finkel 95 98 96.5 Foster 90 88 89.0 Fuss 74 77 75.5 George 67 90 78.5 Gerson 79 72 75.5 Girling 58 66 62.0 Greer 92 96 94.0 Guerro 67 77 72.0 Hager 64 90 77.0 Heilman 79 85 82.0 Hibbard 94 94 94.0 Hills 62 52 57.0 Hughes 76 92 84.0 Hutchison 83 93 88.0 Jackson 81 95 88.0 Kassner 85 90 87.5 Kelcik 69 84 76.5 Kern 41 75 58.0 Kinner 51 86 68.5 Lair 86 96 91.0 Marsh 88 94 91.0 Martini 65 85 75.0 Mattlin 76 82 79.0 McGough 73 74 73.5 Miller 61 80 70.5 Minnick 58 88 73.0 Minster 66 64 65.0 Mueller 68 91 79.5…

Appendix EMPLOYEE Fnamo Minit Lname Ssn Bdato Addross Ser Salary Super ssn Dno 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 333445555 1955-12-08 638 Voss, Houston, TX John B Smith Franklin Wong 40000 888665555 25000 987654321 999887777 1968-01-10 3321 Castlo, Spring, TX Wallaco 987654321 1941-06-20 201 Borry, Bollaire, TX Alicia Zolaya 4. Jonnifor 43000 888665555 4. Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX Ramosh K Joyce 25000 333445555 Ahmad V Jabbar 987987987 1969-03-20 980 Dalas, Houston, TX M 25000 087654321 4. James Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnamo Dnumber Mgr ssn Mgr start date Dnumbor Dlocation Rosearch 333445555 1988-05-22 Houston Administration 4. 987654321 1995-01-01 Stafford Headquarters 1. 888665555 1981-06-19 5. Bellaire 5. Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789…

List the department IDs for those departments that have less than 5 employees: Employee Did Salarycode Ename Eid Ephone Samer 15 23 2345 70092485 Sarah 13 12 5088 71092246 Ahmad 4 26 7712 03099348 Jalal 15 22 9664 76093148 Elie 8 23 3054 70092729 Fadi 24 2976 03091945 Layal 9 21 4490 71099380 Select one: a. SELECT Did FROM Employee GROUP BY Did HAVING SUM(Eid) < 5; O b. SELECT Did, COUNT(Eid) FROM Employee GROUP BY Did; O c. None of these d. SELECT Did FROM Employee GROUP BY Did HAVING COUNT(Eid) < 5;

111 Correct and detailed answer will be Upvoted else downvoted. Thank you!

Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level

Program language: Python Prompt: Divide the dataset into different three classes (i.e., Iris Setosa, Iris Versicolour, Iris Virginica)  and create histograms for each feature. Include program syntax Data: http://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data

Correct and detailed answer will be Upvoted

Correct explanation get upvote

correct answers only pls! Topic: Binary Fill in the boxes Will give you high rating thank you!!

1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)

Question #24

DEF. RTHR. Below.

DB - Normalization   Question # 1 Patient Medication Form   Patient Number:  P10034 Full name: Elbert McDonald                 Ward Number: Ward 11 Bed Number: B4                                    Ward Name: Orthopaedic   Drug Number Name Description Dosage Method of Admin Unit per Day Start Date Finish Date 10223 10334 10223 Morphine Tetracyclene Morphine Pain Killer Antibiotic Pain Killer 10mg/ml 0.5mg/ml 10mg/ml Oral IV Oral 50 10 10 24/03/04 24/03/04 25/04/05 24/04/05 17/04/04 02/05/06   Examine the Patient Medication Form above: Put the above form into a relation schema Identify the functional dependencies. Describe and illustrate the process of normalization to produce 3NF relations.   Question#2: Given the following Theatre Database form:    No.of seats:500                          Owner: J.Martin         Year Founded: 1890 Owner’s Phone: 2347756         - - - - -   Play Name Play Type No. of performances…