Quiz M01 Take 1
.pdf
keyboard_arrow_up
School
Ivy Tech Community College, Indianapolis *
*We aren’t endorsed by this school
Course
110
Subject
Computer Science
Date
Feb 20, 2024
Type
Pages
9
Uploaded by MagistrateScorpionPerson5065
1/21/24, 2:49 AM
M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349
1/9
M01 Quiz
Due
Jan 22 at 5pm
Points
20
Questions
20
Time Limit
30 Minutes
Allowed Attempts
2
Instructions
Attempt History
Attempt
Time
Score
LATEST
Attempt 1
30 minutes
15.33 out of 20
Score for this attempt: 15.33
out of 20
Submitted Jan 21 at 2:47am
This attempt took 30 minutes.
This assignment takes the format of a quiz over Module 1. This quiz consists of 20 multiple choices,
multiple answer, and true-false questions. There is a 30-minute time limit on this quiz, and you will be
provided two attempts, the highest score will be kept. This quiz is due by the stated due date.
It is suggested that you print the questions, review the chapter, and then come back and enter your
answers.
Take the Quiz Again
0 / 1 pts
Question 1
What is the role of data abstraction in a database?
Provides users access to the data within the database. ou Answered
ou Answered
Provides an extra level of security Hide the complexity of storing data from the user. orrect Answer
orrect Answer
1/21/24, 2:49 AM
M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349
2/9
1 / 1 pts
Question 2
In what decade did the type of data stored in a database evolve.
1980 to 1990 1990 1970 to 1980 2000 Correct!
Correct!
1 / 1 pts
Question 3
The types of database users are:
Sophisticated user Correct!
Correct!
Naïve Correct!
Correct!
Testers Programmers Correct!
Correct!
Auditor 1 / 1 pts
Question 4
What is a domain constraint?
1/21/24, 2:49 AM
M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349
3/9
Domains that specify possible values that can be store in an attribute Correct!
Correct!
The rules that specifies the type of language used to define the data
structure.
Restrictions on the number of rows added to a table. 1 / 1 pts
Question 5
Information processing drives the growth of computers.
True Correct!
Correct!
False 1 / 1 pts
Question 6
A variety of new data-intensive applications and the need for rapid
development lead to NoSQL database.
True Correct!
Correct!
False 1 / 1 pts
Question 7
What does a database design involve?
1/21/24, 2:49 AM
M01 Quiz: B1B-Spring 2024-Introduction to Data Analytics
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401349
4/9
The design of an application module The design of a database schema Correct!
Correct!
The design of an information system The architecture of a database management system 0 / 1 pts
Question 8
What was the first relational database product?
IBM System R orrect Answer
orrect Answer
Ingress DEC rdb Oracle ou Answered
ou Answered
IBM DB2 1 / 1 pts
Question 9
What are the two languages a database system provides?
SQL and TSQL Java and Python DDL and DML Correct!
Correct!
R and CC++
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
Please help me adjust the X-axis on my graphs in Excel spreadsheet.
Range numbers are from 200 to 500 but is graphed 0 to 300.
Link: Kahun Data Day 3.xlsx
Thank you!
arrow_forward
What are some data analytics libraries in python? We use matplotlib in our project - what else exists?
arrow_forward
ce_S1_Mangesh
/ My courses/55 ITSE415_AppDataSci_S1 / Chapter 4- Data Preprocessing / Quiz 2 - 10 June 2021
Quiz navigation
When we try to analyze the result-data of the last 10 semesters for the subject 'Programming-1' and if you are asked
to find what will be the final score of any new student based on the value of his Quiz 2 marks, then what type of
analysis is this?
of
Finish attempt-
O a. Prescriptive Analysis
Time left 0:17:27
tion
O b. None of these
Oc. Predictive Analysis
O d. Descriptive Analysis
Next page
Jump to..
pter 4- Presentation
arrow_forward
COVID-19 TRACKER One Of Your Uncle Who's Working Under Department Of Health Learned That You've Taking Up Programming Class. That's Why You've Been Asked If It Would Be Possible For You To Replicate Their Current COVID Tracker. This Is His Small Step To Check Whether You Can Help Him On Creating An Automated Data Analytics. Develop A Program That WillCOVID-19 TRACKER
One of your uncle who's working under Department of Health learned that you've taking up programming class. That's why you've been asked if it would be possible for you to replicate their current COVID tracker. This is his small step to check whether you can help him on creating an automated data analytics.
Develop a program that will replicate the COVID19 Tracker by DOH
You are provided with the official August 4 Data from DOH in csv format (csv is discussed on the next subsection) On the said spreadsheet, Your program should be able to do the ff analytics:
Total Number of Cases: (a) Confirmed, (b) Active, (c) Recovered,…
arrow_forward
Please discuss your feelings about data transformation. Was this the first time that you had heard of it? What do you think? Does this affect your feeling about the statistics that you hear every day? One thing that I'm hoping to read from you is if you are now seeing statistics in a different light. These last couple of chapters bring it all together. You've learned so much these past 13 weeks---now it's time to be able to talk about it.
arrow_forward
https://www.bartleby.com/questions-and-answers/question-no.-4-4-consider-following-tables.-student-regno-sname-scity-scgpa-sage-course-ccode-cname-/fe8fab46-8c8a-4438-be50-f6d170f07bae
arrow_forward
Alert dont submit aI generated answer.
arrow_forward
Urban data design is a company which designs digital products and concepts that make neighborhoods more sustainable and healthier place to live and do business in. This project focuses on a creation of a new app for Urban Data Design for one of their business problems. The app will make it easier for organizers to find the best suited open spaces according to their requirements for a potential event. Make it easier for everyday citizens to find and participate in interesting events happening in open spaces around them.
The purpose is to provide a platform for people in the community to get information regarding open spaces located in their area.
The people will be able to organize events in these open spaces and list them on the app.
People can get information regarding events which are happening in their areas in open spaces.
Provide the community to participate in communal activities to build strong ties and belonging to its community.
These events can promote physical activities…
arrow_forward
As a university instructor, charts are very useful to show statistical analysis of test scores to students. Students are always interested in how they scored compared to the whole class or where their score landed in the overall scheme of things. Which type of statistics would be most useful for comparisons? Which type of chart would be best to show the comparison of grades? How do charts help protect the privacy of individual grades?
arrow_forward
Scaling must be automatically setup.
arrow_forward
explain the erd diagram. ( dont use ai tool)
arrow_forward
Which of the following Python methods is used to perform chi-square goodness of fit tests? Select one.
f_oneway from scipy.stats submodule
tukeyhsd from scipy.stats submodule
chisquare from scipy.stats submodule
anova_lm from scipy.stats submodule
arrow_forward
Question 11 mah .Add. (1)/(9b)+(5)/(6b) Simplify your answer as much as pos
Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
arrow_forward
Customer_ID
Customer_Name
Order_ID
Order_Date
Product_Name
Quantity
101
Alice
1
2023-09-01
Laptop
2
101
Alice
1
2023-09-01
Mouse
1
102
Bob
2
2023-09-02
Monitor
1
102
Bob
2
2023-09-02
Keyboard
1
103
Carol
3
2023-09-03
Laptop
1
103
Carol
3
2023-09-03
Speaker
2
Create a 3nf model
arrow_forward
O CS10-BL B21 3Q2122
ASSESSMENTS
Matlab Activity 2-3
Solving Equations
My Solutions >
Solve the following Equations using MATLAB. Save the numeric answers on the given variable.
1. Solve +5x - 6=0, save the answer as Rootl.
2. Solve cos'x- 3sinx - 2 = 0, the answer as Roor2.
3. Solve exp(2 * x) - 5. exp(x) = 10, the answer as Root3.
4. Solve In(x+ 1) – Inx- 1) = 0.25, the answer as Root4.
Script e
H Save
C Reset
I MATLAB Documentation
Run Script
arrow_forward
Correlations are distorted if the data is standardized.
True
False
arrow_forward
Consider the following two tables:
Table1: Products
productName
Dell Laptop
Apple mobile
Samsung Mobile
productID
unitPrice
entryDate
expiryDate
P1
350
16-10-2016
30-10-2016
P2
420
17-02-2018
02-03-2018
P3
330
20-08-2020
30-08-2020
Р4
HP Printer
80
21-09-2019
05-10-2019
P5
Canon Printer
150
15-05-2020
20-06-2020
Table2: Orders
orderID
Quantity
Price
productID
1
10
3300
P3
2
1800
P1
3
20
1600
Р4
4
20
3000
P5
5
9
1100
P7
8
2250
P10
Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
arrow_forward
For interval data, what correlation coefficient would you use?
arrow_forward
Hire
Highest Degree
Needs Work Visa
Work Experience
Favorite Language
TRUE
yes .
Bachelors
Mobile Dev
Objective-C
FALSE
yes
Masters
Web Dev
Java -
TRUE
yes
Masters
Mobile Dev
Java
TRUE
yes
PhD
Mobile Dev
Objective-C
no
PhD
Objective-C
TRUE
Web Dev
V TRUE
V no
Bachelors
UX Design
Objective-C
Bachelors
Mobile Dev
Java
FALSE
yes
PhD
FALSE
/ no
Web Dev
Objective-C
UX Design
FALSE
yes
Bachelors
Java
UX Design
J TRUE
V no
Masters
Objective-C
UX Design
yes
Masters
Java
FALSE
PhD
Mobile Dev
/ Java
FALSE
по
Masters
Mobile Dev
Java •
TRUE
yes,
Bachelors
Web Dev
Objective-C
FALSE
по
Predict the class of new example given below using Naïve Bayes Classification algorithm:
Highest Degree
Work Experience
Favorite Language
Needs Work Visa
Hire
Masters
UX Design
Java
TRUE
arrow_forward
Patient
P_Id
P_Name
Gender
Age
1
Aqib
Male
25
2
Saima
Female
36
3
Fatima
Female
29
4
Nouman
Male
31
5
Muneeb
Male
40
6
Tariq
Male
38
7
Ikram
Male
26
8
Sadia
Female
27
doctor
D_Id
D_Fname
D_Lname
Salary
City
1
Laiba
Hafeez
50000
Rwp
2
Sameer
Khan
80000
Isb
3
Talib
Ali
62000
Isb
4
Saleem
Iqbal
77000
Multan
5
Tania
Abbas
85000
Lahore
6
Huda
Ahmad
68000
Rwp
Write SQL queries for the following.
Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator.
Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator.
Display details of those doctors who neither…
arrow_forward
CUSTOMER
CID CNAME CITY
Smith
London
Jones
Paris
Clark
London
Adams Athens
1.
1 C1
2 C2
3 C4
4 C5
RENT
RDATE
1 C5
F2
02-OCT-14
2 C5
F3
04-SEP-14
3 C5
F5
16-APR-17
4 C1
F5
16-APR-17
5 C1
F2
02-OCT-14
6 C1
F3
04-SEP-14
7 C2
F2
01-APR-14
8 C4 F2 01-JAN-14
CID
FID
Create three tables
a. Customer
b. Rent
c. Film
2. Define appropriate data type and data size
3. Define column constraints
FILM
FID
1 F2
2 F3
3 F4
4 F5
5 F7
FNAME
The Others
Senseless
Dragon Heart
007
Sweetheart
PRICE TYPE
1.44 HORROR
5.99 COMEDY
6 DRAMA
5 ACTION
5 COMEDY
4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints
a. Primary key
b. Foreign key
E.g.) CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON
DELETE CASCADE
c. The price of a film ranges from 0.50 to 19.99
d. A film can only have the type of Action, Horror, Comedy, Drama, and
Education
arrow_forward
ed1 x
emp x
A 7 Filter
EMPNO
ENAME
DNAME
JOB
HIREDATE
LOC
SALARY
8876
adams
research
clerk
2017-07-23
Johor
5000
8499
allen
sales
salesman 2018-01-23
KL
3400
8698
blake
sales
manager 2016-03-11
KL
10000
8782
ali
accounting
manager 2015-06-25
Penang
11000
8902
ford
research
analyst
2016-02-03
Johor
8700
8900
james
sales
clerk
2017-12-13
KL
3500
8566
jones
research
manager 2015-04-02
Johor
9000
8839
king
accounting
president 2019-11-17
Penang
NA
8654
martin
sales
salesman 2012-06-17
KL
3250
8934
miller
accounting
clerk
2012-01-23
Penang
3000
8788
scott
research
analyst
2017-04-19
Johor
7500
8369
smith
research
clerk
2016-12-17
Johor
5600
8844
turner
sales
salesman 2018-09-08
KL
3000
8521
andrew
sales
salesman 2018-02-22
KL
3200
Which of the following can be used to return the maximum salary (SALARY) for each location (LOC)
Select one:
O emp %>% group_by(LOC) %>% summarise(max_sal=max(emp$SALARY, na.m = T))
O emp %>% fiter(LOC="Penang') %>% group_by(LOC) %>% summarise(max_sal=max(SALARY,…
arrow_forward
Consider the following two tables:
Table1: Products
productID
productName
unitPrice
entryDate
expiryDate
P1
Dell Laptop
350
16-10-2016
30-10-2016
P2
Apple mobile
420
17-02-2018
02-03-2018
P3
Samsung Mobile
330
20-08-2020
30-08-2020
P4
HP Printer
80
21-09-2019
05-10-2019
P5
Canon Printer
150
15-05-2020
20-06-2020
Table2: Orders
orderID
Quantity
Price
productID
1
10
3300
P3
2
5
1800
P1
3
20
1600
P4
4
20
3000
P5
5
9
1100
P7
6
8
2250
P10
Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
INNER JOIN Orders AS o
ON p. productID = o. productID;
2. SELECT p. productName, p. unitPrice, p.…
arrow_forward
Alert dont submit AI generated answer.
arrow_forward
Discuss how three other types of businesses can make use of data analytics to provide a more targeted service for South Africans.
arrow_forward
QUESTION 5
Consider the following two tables:
Table1: Products
productID
productName
unitPrice
entryDate
expiryDate
P1
Dell Laptop
350
16-10-2016
30-10-2016
P2
Apple mobile
420
17-02-2018
02-03-2018
P3
Samsung Mobile
330
20-08-2020
30-08-2020
P4
HP Printer
80
21-09-2019
05-10-2019
P5
Canon Printer
150
15-05-2020
20-06-2020
Table2: Orders
orderID
Quantity
Price
productID
1
10
3300
P3
2
5
1800
P1
3
20
1600
P4
4
20
3000
P5
5
9
1100
P7
6
8
2250
P10
Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
INNER JOIN Orders AS o
ON p. productID = o. productID;
2. SELECT p. productName, p.…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Related Questions
- Please help me adjust the X-axis on my graphs in Excel spreadsheet. Range numbers are from 200 to 500 but is graphed 0 to 300. Link: Kahun Data Day 3.xlsx Thank you!arrow_forwardWhat are some data analytics libraries in python? We use matplotlib in our project - what else exists?arrow_forwardce_S1_Mangesh / My courses/55 ITSE415_AppDataSci_S1 / Chapter 4- Data Preprocessing / Quiz 2 - 10 June 2021 Quiz navigation When we try to analyze the result-data of the last 10 semesters for the subject 'Programming-1' and if you are asked to find what will be the final score of any new student based on the value of his Quiz 2 marks, then what type of analysis is this? of Finish attempt- O a. Prescriptive Analysis Time left 0:17:27 tion O b. None of these Oc. Predictive Analysis O d. Descriptive Analysis Next page Jump to.. pter 4- Presentationarrow_forward
- COVID-19 TRACKER One Of Your Uncle Who's Working Under Department Of Health Learned That You've Taking Up Programming Class. That's Why You've Been Asked If It Would Be Possible For You To Replicate Their Current COVID Tracker. This Is His Small Step To Check Whether You Can Help Him On Creating An Automated Data Analytics. Develop A Program That WillCOVID-19 TRACKER One of your uncle who's working under Department of Health learned that you've taking up programming class. That's why you've been asked if it would be possible for you to replicate their current COVID tracker. This is his small step to check whether you can help him on creating an automated data analytics. Develop a program that will replicate the COVID19 Tracker by DOH You are provided with the official August 4 Data from DOH in csv format (csv is discussed on the next subsection) On the said spreadsheet, Your program should be able to do the ff analytics: Total Number of Cases: (a) Confirmed, (b) Active, (c) Recovered,…arrow_forwardPlease discuss your feelings about data transformation. Was this the first time that you had heard of it? What do you think? Does this affect your feeling about the statistics that you hear every day? One thing that I'm hoping to read from you is if you are now seeing statistics in a different light. These last couple of chapters bring it all together. You've learned so much these past 13 weeks---now it's time to be able to talk about it.arrow_forwardhttps://www.bartleby.com/questions-and-answers/question-no.-4-4-consider-following-tables.-student-regno-sname-scity-scgpa-sage-course-ccode-cname-/fe8fab46-8c8a-4438-be50-f6d170f07baearrow_forward
- Alert dont submit aI generated answer.arrow_forwardUrban data design is a company which designs digital products and concepts that make neighborhoods more sustainable and healthier place to live and do business in. This project focuses on a creation of a new app for Urban Data Design for one of their business problems. The app will make it easier for organizers to find the best suited open spaces according to their requirements for a potential event. Make it easier for everyday citizens to find and participate in interesting events happening in open spaces around them. The purpose is to provide a platform for people in the community to get information regarding open spaces located in their area. The people will be able to organize events in these open spaces and list them on the app. People can get information regarding events which are happening in their areas in open spaces. Provide the community to participate in communal activities to build strong ties and belonging to its community. These events can promote physical activities…arrow_forwardAs a university instructor, charts are very useful to show statistical analysis of test scores to students. Students are always interested in how they scored compared to the whole class or where their score landed in the overall scheme of things. Which type of statistics would be most useful for comparisons? Which type of chart would be best to show the comparison of grades? How do charts help protect the privacy of individual grades?arrow_forward
- Scaling must be automatically setup.arrow_forwardexplain the erd diagram. ( dont use ai tool)arrow_forwardWhich of the following Python methods is used to perform chi-square goodness of fit tests? Select one. f_oneway from scipy.stats submodule tukeyhsd from scipy.stats submodule chisquare from scipy.stats submodule anova_lm from scipy.stats submodulearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning