Quiz 3_ CIS 101 _ Intro Comp Their Use - El Khoury N
.pdf
keyboard_arrow_up
School
Los Angeles Valley College *
*We aren’t endorsed by this school
Course
101
Subject
Computer Science
Date
May 10, 2024
Type
Pages
19
Uploaded by ProfSalmonMaster853 on coursehero.com
11/5/23, 1:02 AM
Quiz 3: CIS 101 : Intro Comp Their Use - El Khoury N. - FALL 2023 - SECTION# 16627
https://ilearn.laccd.edu/courses/248689/quizzes/1934633
1/19
Quiz 3
Due
Nov 5 at 11:59pm
Points
100
Questions
50
Time Limit
90 Minutes
Instructions
Notes and Tips
This task should take about 90 minutes of your time.
This activity supports learning objectives of all previous weeks materials.
This task is due on Sunday midnight 11:59pm.
Review all previous weeks materials.
This assignment earns 100 points.
Quiz Description
Quiz 3 covers chapters 6, 7, and 8. You are allowed to enter this quiz, one time and
you have 90 minutes to answer 50 questions (Multiple choice and T/F) and complete
the quiz. You have to complete it in one sitting. Yes you can use the book but you
MUST work alone
. When you complete this Quiz, click on "Submit". This auto-graded
quiz will assess your understanding of week 4, 5, and 6 materials and measure your
mastery of the objectives stated in this module. The quiz is worth a total of 100
points
. To prepare for the quiz, please review the content of week 7, 8, and 9 materials
chapter 6, 7, and 8 resources.
11/5/23, 1:02 AM
Quiz 3: CIS 101 : Intro Comp Their Use - El Khoury N. - FALL 2023 - SECTION# 16627
https://ilearn.laccd.edu/courses/248689/quizzes/1934633
2/19
Attempt History
Attempt
Time
Score
LATEST
Attempt 1
33 minutes
98 out of 100
Score for this quiz: 98
out of 100
Submitted Nov 5 at 1:01am
This attempt took 33 minutes.
This activity will assess your comprehension of learning objectives of Chapters 6, 7,
and 8.
Select the best answer for each question below. When you are finished, click on "Submit"
button at the bottom of the page.
Good Luck!..
Quiz Guidelines:
1. Read and answer questions carefully
. The quizzes are graded by Canvas. You must
answer questions correctly and in correct format
.
2. Answer to questions will be available after the deadline. Please be patient and wait to see
the correct answers.
3. No make up
.
2 / 2 pts
Question 1
The arrangement of keys on a keyboard, QWERTY reflects the keyboard
layout by _______.
taking the letters of the first six alphabetic characters found on the top row of
keys
Correct!
Correct!
11/5/23, 1:02 AM
Quiz 3: CIS 101 : Intro Comp Their Use - El Khoury N. - FALL 2023 - SECTION# 16627
https://ilearn.laccd.edu/courses/248689/quizzes/1934633
3/19
representing the phonetics of the alphabets most closely associated with the
keyboard
using the alphabetic characters most frequently used on the keyboard using the letters of the alphabetic characters that are closest to access while
typing
2 / 2 pts
Question 2
OMR, OCR, and MICR are all types of _______.
bar code readers character and mark recognition devices Correct!
Correct!
magnetic card readers Radio Frequency Card Readers 2 / 2 pts
Question 3
The study of human factors related to things people use.
Headgear Ergonomics Correct!
Correct!
Technical study RSI
11/5/23, 1:02 AM
Quiz 3: CIS 101 : Intro Comp Their Use - El Khoury N. - FALL 2023 - SECTION# 16627
https://ilearn.laccd.edu/courses/248689/quizzes/1934633
4/19
2 / 2 pts
Question 4
A dedicated, mobile device for storing and displaying e-books and other
electronic media including electronic newspapers and magazines.
Flat panel monitor E-book reader Correct!
Correct!
Interactive whiteboard HDTV 2 / 2 pts
Question 5
A keyboard key, like Caps Lock, that turns a feature on or off is called a
_______ key.
combination toggle Correct!
Correct!
power function 2 / 2 pts
Question 6
This indicates the monitor's ability to display colors by comparing the light
intensity of the brightest white to the darkest black.
11/5/23, 1:02 AM
Quiz 3: CIS 101 : Intro Comp Their Use - El Khoury N. - FALL 2023 - SECTION# 16627
https://ilearn.laccd.edu/courses/248689/quizzes/1934633
5/19
Active display area Resolution Contrast ratio Correct!
Correct!
Dot Pitch 2 / 2 pts
Question 7
The series of dots that form the image on a monitor are called _______.
bits picas bytes pixels Correct!
Correct!
2 / 2 pts
Question 8
Specialized devices with a large display connected to a computer projector
and are widely used in classrooms and corporate boardrooms.
Digital or interactive whiteboards Correct!
Correct!
HDTV Scanners E-books
11/5/23, 1:02 AM
Quiz 3: CIS 101 : Intro Comp Their Use - El Khoury N. - FALL 2023 - SECTION# 16627
https://ilearn.laccd.edu/courses/248689/quizzes/1934633
6/19
2 / 2 pts
Question 9
This reading device is used in banks to read the numbers on the bottom of
checks and deposit slips.
OMR UPC MICR Correct!
Correct!
OCR 2 / 2 pts
Question 10
Digital or interactive whiteboards display a computer's desktop and can be
controlled using a special pen or a finger.
True Correct!
Correct!
False 2 / 2 pts
Question 11
The most widely used input devices are monitors, printers, and keyboards.
True False Correct!
Correct!
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Set up
Order
[ single order )
Assign
seats
[ subscription )
Assign
chairs
Award bonus
Debit
Account
charge
credit card
Mail
packet
arrow_forward
questionnn
arrow_forward
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
arrow_forward
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
arrow_forward
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.
arrow_forward
Need perfect answer
Else skipped
Perfect explanation got thumbs-up
arrow_forward
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".
arrow_forward
Complete Assignment attached using Codeskulptor3.com
arrow_forward
Please answer only only correct with explanation.
arrow_forward
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.)
arrow_forward
true/false
Both professor and assistant can create a new course (use case Create course) ( )
arrow_forward
student name : sayem ahmed ID 011211030
arrow_forward
#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 (%):…
arrow_forward
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…
arrow_forward
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
arrow_forward
Correct explanation gets upvote
arrow_forward
pls help fast will answer
arrow_forward
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
arrow_forward
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…
arrow_forward
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…
arrow_forward
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…
arrow_forward
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;
arrow_forward
111
Correct and detailed answer will be Upvoted else downvoted. Thank you!
arrow_forward
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
arrow_forward
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
arrow_forward
Correct and detailed answer will be Upvoted
arrow_forward
Correct explanation get upvote
arrow_forward
correct answers only pls!
Topic: Binary
Fill in the boxes
Will give you high rating thank you!!
arrow_forward
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)
arrow_forward
Question #24
arrow_forward
DEF. RTHR. Below.
arrow_forward
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…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Related Questions
- Set up Order [ single order ) Assign seats [ subscription ) Assign chairs Award bonus Debit Account charge credit card Mail packetarrow_forwardquestionnnarrow_forwardSample 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 Malaysiaarrow_forward
- 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 cardinalitiesarrow_forwardPET 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.arrow_forwardNeed perfect answer Else skipped Perfect explanation got thumbs-uparrow_forward
- 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".arrow_forwardComplete Assignment attached using Codeskulptor3.comarrow_forwardPlease answer only only correct with explanation.arrow_forward
- 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.)arrow_forwardtrue/false Both professor and assistant can create a new course (use case Create course) ( )arrow_forwardstudent name : sayem ahmed ID 011211030arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education