Carmen Quiz 3 - Chapter 3 - Spreadsheet Design_ AU23 CSE 2111 - Spreadsheets & DBs (7288)
.pdf
keyboard_arrow_up
School
Ohio State University *
*We aren’t endorsed by this school
Course
2111
Subject
Computer Science
Date
Feb 20, 2024
Type
Pages
5
Uploaded by CaptainFlyPerson872 on coursehero.com
2024/1/12 18:48
Carmen Quiz 3 - Chapter 3 - Spreadsheet Design: AU23 CSE 2111 - Spreadsheets & DBs (7288)
https://osu.instructure.com/courses/151434/quizzes/940001
1/5
Carmen Quiz 3 - Chapter 3 - Spreadsheet Design
Due
Sep 1, 2023 at 11:59pm
Points
20
Questions
10
Available
Aug 28, 2023 at 12am - Sep 1, 2023 at 11:59pm
Time Limit
15 Minutes
Instructions
This quiz was locked Sep 1, 2023 at 11:59pm.
Attempt History
Attempt
Time
Score
LATEST
Attempt 1
13 minutes
20 out of 20
Correct answers are no longer available.
Score for this quiz: 20
out of 20
Submitted Sep 1, 2023 at 9:55pm
This attempt took 13 minutes.
Please select the appropriate answer to each True/False or Multiple Choice question.
There are 10 questions total.
Questions will be shown one at a time.
You have one
attempt at taking this quiz.
The quiz is timed at 15 minutes
.
Correct responses will be available after the due date for the quiz.
Materials for this quiz will be taken from the Course Notes Chapter 3 and all lecture materials covered
to-date.
IMPORTANT! Make sure you read the Course Notes PRIOR
to taking this quiz. You will NOT
have
enough time to read the Course Notes as you progress through the quiz. It is expected that you read
the Course Notes PRIOR
to taking this quiz.
No credit will be given for late submissions. No late submissions or makeups will be allowed. The
lowest quiz grade will be dropped. Therefore, if you miss a quiz, this will be the one that is dropped.
2 / 2 pts
Question 1
Where are the worksheet tabs located on the Excel screen?
2024/1/12 18:48
Carmen Quiz 3 - Chapter 3 - Spreadsheet Design: AU23 CSE 2111 - Spreadsheets & DBs (7288)
https://osu.instructure.com/courses/151434/quizzes/940001
2/5
None of the listed answers are true. In the middle of the screen. At the top of the screen. At the bottom of the screen. 2 / 2 pts
Question 2
How do you reference a cell from a different worksheet, other than the
one you are currently working on, if the desired cell is on a sheet named
'Other Sheet' in row 5 and column H?
='Other Sheet'5H ='Other Sheet'&H5 =OtherSheet!H5 ='Other Sheet'!H5 2 / 2 pts
Question 3
Only being able to adjust or change values in cells that do not contain
formulas is a limitation of __________ .
transposing 3-D cell referencing using multiple worksheets input/output analysis
2024/1/12 18:48
Carmen Quiz 3 - Chapter 3 - Spreadsheet Design: AU23 CSE 2111 - Spreadsheets & DBs (7288)
https://osu.instructure.com/courses/151434/quizzes/940001
3/5
goal-seeking 2 / 2 pts
Question 4
A 3-D formula in Excel allows you to simultaneously select multiple
adjacent worksheets.
True False 2 / 2 pts
Question 5
It is a good idea to put input values and output values into separate
sheets when solving a complex problem if it improves readability and
usability.
True False 2 / 2 pts
Question 6
Data (variables) should never appear more than once in a spreadsheet.
True False
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
c)
Given the following tables:
Table : TRUCK
Truck Num Base_Code
501
Туре_Сode
1
Truck Miles
5676.89
12232.67
9886.68
23445.76
454.98
Truck SerialNum
AA-322-1222-W11
AV-678-4545-023
FR-456-1123-R45
AD-213-7654-WQ
XV-987-1234-SQ
1001
1002
502
501
501
502
1.
1003
1004
1005
2
13
Table: BASE
Base Code
501
502
503
Base City
Jasin
Shah Alam
Kuala Kangsar Perak
Base State Base_Postcode Base_Manager
77000
40000
33000
Malacca
Selangor
Fattah Aziz
Michael Faraday
Benjamin
Table: TYPE
Туре Сode Tyуре Description
1
2.
Single box, double-axie
Single box, single axie
Tandem trailer, single axie
3.
Describe the type(s) of relationship(s) between TRUCK and BASE relations.
Identify the entity integrity (if any) for each table. Answer YES or NO, and then
explain your answer.
il)
Draw the ER Diagram that corresponds to the above tables. Include all the
appropriate connectivity and cardinalities of the relationships.
arrow_forward
(b) Figure 1, shows an ARM assembly program, which finds the most positive and
negative values in a list of 16-bit (half-word) value in data memory (TABLE).
The values are in two's complement representations. By examining the program,
answer the following questions:
(i) Find the errors in the program and make necessary corrections. Do not
insert any additional line in the program.
(ii) How many bytes does 'TABLE' occupy?
(iii) What are the values loaded in the register R2 and R4?
(iv) Determine the values of the flags N, Z, C and V.
(v) Modify the program such that the numbers in 'TABLE' are represented in
'word' length.
arrow_forward
Table name: EMPLOYEE
EMP_NUM EMP_LNAME
215 Smith
216 Romero
217 Randall
218 Aarden
Table name: EMP_EDUC
EMP_NUM EDU_CODE EE YEAR
2002
1991
1994
1989
2004
2002
1985
1992
2000
1990
2000
2005
1984
1995
215 84
215 HS
215 JC
216 B4
216 CDP
216 CNP
216 HS
217 HS
217 JC
218 B4
218 CDP
218 CNP
218 HS
218 M2
Table name: EDUCATION
EDU_CODE
EDU_DESCRIPTION
34
CDP
CNP
CPA
DR
HS
JC
M2
Bachelor's degree
Certified data Processing
Certified Network Professional
Certified Public Accountant
Earned Doctorate degree
Highschool diploma
Junior College degree
Master's degree
arrow_forward
Making a DataFrame
Create a dataframe pd that contains 5 rows and 4 columns, similar to the one given
below:
Col1 Col2 Col3 Col4
7
5
707
60
4
1
2
3
5
4
5
5 8
6
7
Note:
7
78
78
18
88
- Print only the first two rows of the dataframe.
- Print the second column.
- Change the name of the third column from "Col3" to "XYZ".
- Add a new column to the dataframe and name it "Sum".
- Sum the entries of each row and add the result in the column "Sum".
Please provide PYTHON (ANACONDA) code for above task.
arrow_forward
: STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects. Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network. They are going to have two divisions in two different office sites in the same building, (two story office building)
Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development. Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication.
Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well.
All employees in the…
arrow_forward
https://www.bartleby.com/questions-and-answers/jobs-burst-time-arrival-time-j1-17-j2-1-j3-30-15-j4-15-17-j5-20-30-1.-which-job-is-executed-first-2./667de578-d666-4b96-ba55-6ab93be41458
arrow_forward
Create the following table in MySql and share the code
arrow_forward
For the following, write the citation in IEEE format:
author = { Silvio Labbate },
Title = {Italy and the development of European energy policy: from the dawn of the integration process to the 1973 oil crisis},
Journal = {European Review of History: Revue européenne d'histoire},
Volume = {20}, number = {1}, pages = {67-93}, year = {2013},
author="Heinberg, Richard",
Title="The Energy Wildcard: Possible Energy Constraints to Further Urbanization",
Book Title="State of the World: Can a City Be Sustainable?", year="2016",
Publisher="Island Press/Center for Resource Economics",
Address="Washington, DC", pages="65--73",
Title of Web Page : Microwave signals turned into electrical power
Year, Month, Day: 2013, November, 11th
Authors name: BBC News
Available URL: http://www.bbc.co.uk/news/technology-24897584
arrow_forward
Code for the following:
Web application is written using the MVC (Model, View, Controller) architecture
Web application is written using object-oriented PHP programming, including classes for:
Database Connection & Information
Products table model
Products table DB
Products table controller
Categories table model
Categories table DB
Categories table controller
Web application includes 3 user interface pages:
Index/landing/navigation page
Title: "Your Name Wk 3 GP"
Page Header: Your Name Product Information
Includes navigation links to all other pages
Filename index.php
Database Connection Status page
Title: "Your Name Wk 3 GP"
Page Header: Your Name Database Status
Includes:
Text display of the database name
Text display of the database user ID
Text display of the database password
Text display of the status of the connection (successful or unsuccessful)
Navigation link to the home page
Filename db_conn_status.php
Products page (and Product Add/Update page)
Title: "Your Name Wk 3…
arrow_forward
Choose the best answer from following answers:C(x): x is taking CSE 105. M(x):x is a CSE major. ∀×(M(x)^C(x)) in English is a) Every student is a CSE major and they all are taking CSE 105b) Every CSE student is taking CSE 105c) None of the above
arrow_forward
Location
Invoice Submitted by the Vendor
Invoice on Record
Invoice Amount
Remarks
Tax
Manila
010001
010001
18,086.00
Makati
000502
000502
28,000.00
Makati
000703
003703
16,216.00
Caloocan
004004
004004
2,000.00
Mandaluyong
008005
008005
8,216.00
Makati
006006
006006
8,764.00
Quezon City
003007
003007
8,764.00
Quezon City
007008
004008
8,764.00
Mandaluyong
001009
001009
8,764.00
Manila
008010
008010
8,790.00
Caloocan
004012
005011
45,000.00
Caloocan
002011
008017
30,000.00
Quezon City
008017
005311
5,000.00
Quezon City
005311
008017
15,000.00
Manila
001015
002011
25,000.00
Summary:
Total Invoice Amount for Manila
Total Invoice Amount for Quezon City and “Not Found”
Total…
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
SQL 2019 Answer choices (a, b, c, d, and e) indicate whether a certain data type supports the UTF-8 encoding or not.
arrow_forward
Describe Process Specification and techniques for the following diagram.
Please follow the same format as attached in this pdf: https://drive.google.com/file/d/1vnE5KJi3K1T74hU1uDuqdFfsd90oX11h/view?usp=sharing
There is same question with correct format: https://www.bartleby.com/questions-and-answers/describe-process-specification-and-techniques-for-the-following-diagram.-please-follow-the-same-form/01069b75-4a39-44f7-909a-ac99df19570c
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
Consider the following Unix Shell dialogue:
s echo (mdir C214; cd c214;pwd) >Ceng214
$ cat Ceng214
#Box 1
Ab bb b Ceng214
#Box2
-r-xr--r-1 bilgen 21 Jun 29, 2021 10:38 Ceng214
$ (a=aaa; b=bbb; export a; echo Sb)
#Box3
$ echo $a $b
#Box4
s Ceng214
#Box5
$ pwd
#Box6
Mark all the correct statements about the contents of the empty boxes, below:
O Box4 contains: $a
O Box3 contains: $b
O Box4 contains: $b
O Box1 contains: $
O Box6 contains: pwd
O Box5 contains: Ceng214
O Box6 contains: Ceng214
O Box3 contains: echo $b
O Box1 contains: C214
O Box6 contains: Bilgen
O Box1 contains: mdir C214;cd C214;pwd
O Box2 contains: $ls -I Ceng214
O Box2 contains:
Schmod u+x,u-w Ceng214 (... OR $chmod 544 Ceng214)
Sls - Ceng214
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
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
DBS-14.5:
BUSES
number(11)
BUS NO
BUS_NAME varchar2(20) t
TYPE
SCHEDULE
varchar2(20)t
varchar2(3)
date d
varchar2(20) t
DESTINATION varchar2(20) t
number(11)
number(11)
SCHEDULE_ID
TRAVEL DATE
SOURCE
TOTAL_SEATS number(11)
AVAIL_SEATS number(11)
BUS NO
O BUS_NO
DURATION
PAYMENTS
DISCOUNTS
PAYMENT_ID varchar2(3)t
P TICKET ID
varchar2(3)
DISCOUNT_ID
TICKET ID
varchar2(3)
number(11)
O DISCOUNT_ID varchar2(3)
DISCOUNT_AMOUNT number(11)
O BD_ID
TICKETS
DISCOUNT ID
varchar2(3)
OSCHEDULE ID varchar2(3)
number(11)
number(11)O
number(11)
TICKET ID
HEDULE ID
FARE
USER ID
OUSER ID
NO SEATS
USERS
PUSER ID number(11)
varchar2(20) e
ADDRESS varchar2(100) t
number(11)
EMAILID varchar2(30) e
P primary key - not null
e formign key
NAME
PHNO
# data type - zurber
a| data type - date
It| data type - varchar2
CANCELLATION
CANCELLATION_ID varchar2(3)
varchar2(3)
number(11)o
TICKET ID
BOOKINGDETAILS
TICKET ID
O BD ID
ED ID
BD ID number(11)
ACC_NO number(11)
NAME varchar2(10)t
PUSER ID number(11)
USER_ID…
arrow_forward
Internet keyword searches are different from database keyword searches. The two are quite different from one another. What are the primary similarities and differences between the two in terms of the way queries are phrased and the information that is returned, and what are the advantages of each?
arrow_forward
Program language: Python
Prompt: Create histograms for each feature in a similar way for each of the different classes present in the data.
Data: http://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data
arrow_forward
Sub quiz6_1()
For i = 4 To -1 Step -3
For J = -1 To 1
soln = i * J
Next J
Next i
Cells(2, 2)
= soln
Cells(3, 2) = i * J
%3D
End Sub
For the following section of code, determine what will be written into the spreadsheet in cell B3=
arrow_forward
BASE SAS PROGRAMMING
Question 12:- When a SAS data set is created from a spreadsheet, the spreadsheet column headings are always stored as which of the following?
a) variable names
b) labels
c) formats
d) descriptor
Question 13:- In SAS, one can test single or joint hypothesis after successful completion of
a) Data portion
b) First observation
c) Descriptor portion
d) PDV
Question 14:- The following SAS program is submitted: data work.products; Product_Number = 5461; Item = `1001`; Item_Reference = Item`/`Product_Number; run; Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
a) 1111/1502
b) 1001/ 5461
c) (missing numeric value)
d) The value can not be…
arrow_forward
Set up
Order
[ single order )
Assign
seats
[ subscription )
Assign
chairs
Award bonus
Debit
Account
charge
credit card
Mail
packet
arrow_forward
pls quickly answer
arrow_forward
Q1: STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects. Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network. They are going to have two divisions in two different office sites in the same building, (two story office building)
Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development. Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication.
Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well.
All employees in the…
arrow_forward
Q1: STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects. Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network. They are going to have two divisions in two different office sites in the same building, (two story office building)
Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development. Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication.
Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well.
All employees in the…
arrow_forward
Mahmood AlI Ghasani
University of Technology and Applied Sciences Ibri
oard / Courses / AY_2020_2021 / Semester 2 / Information Technology / 54_ITDB101_DB_S2/ Final Examination
nal Examination 13 April 2021 8:30 to 10:45 AM
Course search
There is a Hostel Booking Software in one of the hostels in Ibri. There you can book a suitable hostel
room for yourself if you log in as a student. What type of user are you in this scenario?
estion 3
st yet
Swered
larked out of
O a. Application Programmer
00
Flag question
Ob. Database Designer
Oc. Database Administrator
d. End User
Previous page
Next page
TATMOLie
ENG d
arrow_forward
4G*
VodaCom-SA
A 100% O
9:38
SU6_I_DO_CH9
CMPG 122
User Interface Programming
I_Do: Week 12
Chapter 9: Classes and Multiform Projects
- Dorm and Meal Plan Calculator (Nr 6, Page 622)
A university has the following dormitories:
E Allen Hall
E Pike Hall
E Farthing Hall
E University Suites
$1,500 per semester
$1,600 per semester
$1,800 per semester
$2,500 per semester
The university also offers the following meal plans:
o 7 meals per week
A 14 meals per week
A Unlimited meals
$ 600 per semester
$1,200 per semester
$1,700 per semester
Create an application with two forms. The main form should allow the user to select a dormitory
and a meal plan. The application should show the total charges on the second form.
See example below:
E Program9_6
Meal Plan:
Domitory:
Allan Hall
Pike Hall
Farthing Hall
University Suites
7 meals per week
14 meals per week
Unlimited meals
Domitory: $1,600.00 per semester
Meal Plan: $600.00 per semester
Total: $2,200.00
Display
Form I
Form 2
arrow_forward
For Online learning
CE
VKC293AA
VKC293AA
SEC KOREA 728
SEC KOREA 728
U1
9-SYOO1913WX
KM44C16100AS-6
SEC/KOREA 20
C3
MemoryMasters
128MB FPM NON PARITY SIMM
SEC KOREA 728
R5
WARRANTY VOID IF REMOVED
KM44C16100AS 6
VKC293AA
KM44C16100AS-6
SEC KOREA 728
KM44C16100AS-6
SEC KOREA 728
Figure I RAM module - A
Part A:
refer to Figure 1, answer the following questions.
1. What is the type of RAM installed in the system? And What is the name of the manufacturer?
2. What is the capacity of the RAM?
3. How many pins does this RAM module have (count them)? What type is it, DIMM or SIMM?
4. What is the reason for the notch on the RAM module?
ASSY IN U.S.A, R3
C1 R1DBD BR4
HU7
6
arrow_forward
What is a User-defined data type (UDt)?
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
- c) Given the following tables: Table : TRUCK Truck Num Base_Code 501 Туре_Сode 1 Truck Miles 5676.89 12232.67 9886.68 23445.76 454.98 Truck SerialNum AA-322-1222-W11 AV-678-4545-023 FR-456-1123-R45 AD-213-7654-WQ XV-987-1234-SQ 1001 1002 502 501 501 502 1. 1003 1004 1005 2 13 Table: BASE Base Code 501 502 503 Base City Jasin Shah Alam Kuala Kangsar Perak Base State Base_Postcode Base_Manager 77000 40000 33000 Malacca Selangor Fattah Aziz Michael Faraday Benjamin Table: TYPE Туре Сode Tyуре Description 1 2. Single box, double-axie Single box, single axie Tandem trailer, single axie 3. Describe the type(s) of relationship(s) between TRUCK and BASE relations. Identify the entity integrity (if any) for each table. Answer YES or NO, and then explain your answer. il) Draw the ER Diagram that corresponds to the above tables. Include all the appropriate connectivity and cardinalities of the relationships.arrow_forward(b) Figure 1, shows an ARM assembly program, which finds the most positive and negative values in a list of 16-bit (half-word) value in data memory (TABLE). The values are in two's complement representations. By examining the program, answer the following questions: (i) Find the errors in the program and make necessary corrections. Do not insert any additional line in the program. (ii) How many bytes does 'TABLE' occupy? (iii) What are the values loaded in the register R2 and R4? (iv) Determine the values of the flags N, Z, C and V. (v) Modify the program such that the numbers in 'TABLE' are represented in 'word' length.arrow_forwardTable name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degreearrow_forward
- Making a DataFrame Create a dataframe pd that contains 5 rows and 4 columns, similar to the one given below: Col1 Col2 Col3 Col4 7 5 707 60 4 1 2 3 5 4 5 5 8 6 7 Note: 7 78 78 18 88 - Print only the first two rows of the dataframe. - Print the second column. - Change the name of the third column from "Col3" to "XYZ". - Add a new column to the dataframe and name it "Sum". - Sum the entries of each row and add the result in the column "Sum". Please provide PYTHON (ANACONDA) code for above task.arrow_forward: STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects. Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network. They are going to have two divisions in two different office sites in the same building, (two story office building) Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development. Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication. Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well. All employees in the…arrow_forwardhttps://www.bartleby.com/questions-and-answers/jobs-burst-time-arrival-time-j1-17-j2-1-j3-30-15-j4-15-17-j5-20-30-1.-which-job-is-executed-first-2./667de578-d666-4b96-ba55-6ab93be41458arrow_forward
- Create the following table in MySql and share the codearrow_forwardFor the following, write the citation in IEEE format: author = { Silvio Labbate }, Title = {Italy and the development of European energy policy: from the dawn of the integration process to the 1973 oil crisis}, Journal = {European Review of History: Revue européenne d'histoire}, Volume = {20}, number = {1}, pages = {67-93}, year = {2013}, author="Heinberg, Richard", Title="The Energy Wildcard: Possible Energy Constraints to Further Urbanization", Book Title="State of the World: Can a City Be Sustainable?", year="2016", Publisher="Island Press/Center for Resource Economics", Address="Washington, DC", pages="65--73", Title of Web Page : Microwave signals turned into electrical power Year, Month, Day: 2013, November, 11th Authors name: BBC News Available URL: http://www.bbc.co.uk/news/technology-24897584arrow_forwardCode for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…arrow_forward
- Choose the best answer from following answers:C(x): x is taking CSE 105. M(x):x is a CSE major. ∀×(M(x)^C(x)) in English is a) Every student is a CSE major and they all are taking CSE 105b) Every CSE student is taking CSE 105c) None of the abovearrow_forwardLocation Invoice Submitted by the Vendor Invoice on Record Invoice Amount Remarks Tax Manila 010001 010001 18,086.00 Makati 000502 000502 28,000.00 Makati 000703 003703 16,216.00 Caloocan 004004 004004 2,000.00 Mandaluyong 008005 008005 8,216.00 Makati 006006 006006 8,764.00 Quezon City 003007 003007 8,764.00 Quezon City 007008 004008 8,764.00 Mandaluyong 001009 001009 8,764.00 Manila 008010 008010 8,790.00 Caloocan 004012 005011 45,000.00 Caloocan 002011 008017 30,000.00 Quezon City 008017 005311 5,000.00 Quezon City 005311 008017 15,000.00 Manila 001015 002011 25,000.00 Summary: Total Invoice Amount for Manila Total Invoice Amount for Quezon City and “Not Found” Total…arrow_forward1. 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
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