ECE668 Quiz4(Includes calculation)
.docx
School
Florida Polytechnic University *
*We aren’t endorsed by this school
Course
5741
Subject
Computer Science
Date
Feb 20, 2024
Type
docx
Pages
22
Uploaded by abonyamin1
@ N TF .l 69%@ E&C-ENG568_E&C- ENG668_144587_FA22- Computer Architectulre Fall 2022 | Moodle home / My courses / Unit3 / Quiz4 Started on State Completed on Time taken Points Grade Question 1 Correct 10.00 points out of 10.00 " Flag question Monday, October 17, 2022, 7:42 PM Finished Monday, October 17, 2022, 8:32 PM 49 mins 52 secs 70.00/100.00 7.00 out of 10.00 (70%) Which of the following statements are false for a 5 stage MIPS pipeline with stages: IF, ID, EX, MEM and WB?
Question 1 Correct 10.00 points out of 10.00 " Flag question Which of the following statements are false for a 5 stage MIPS pipeline with stages: IF, ID, EX, MEM and WB? Select one or more: a. Store operations are only 4 active (doing something useful) during the IF, ID, EX and WB stages b. ALU operations are only active (doing something useful) during the IF, ID, EX and WB stages. c. Load operations are only g active (doing something useful) during the IF, ID, EX and WB stages. d. Branch operations areonly v active (doing something useful) during the IF, ID, EX and WB stages. Your answer is correct. ALU operations do not require the memory access step (MEM) that Loads and Stores do. Load operations are active during all 5 stages. Store operations do not require the write-back step (WB) that Loads and ALU operations do. They do not move data into the register file.
acuve (going sometning useful) during the IF, ID, EX and WB stages b. ALU operations are only active (doing something useful) during the IF, ID, EX and WB stages. c. Load operations are only b active (doing something useful) during the IF, ID, EX and WB stages. d. Branch operations areonly v active (doing something useful) during the IF, ID, EX and WB stages. Your answer is correct. ALU operations do not require the memory access step (MEM) that Loads and Stores do. Load operations are active during all 5 stages. Store operations do not require the write-back step (WB) that Loads and ALU operations do. They do not move data into the register file. 'Storing' of data is done in the MEM step. Stores are also active in the EX stage, as are Loads; the calculation of which memory address to go to is done here. This calculation is needed because of the use of relative addressing. Also, Branch operations do not require the memory access step (MEM) or the write-back step (WB). After the EX stage, the branch condition is known and the target has been calculated, nothing further is required for branch instructions. The correct answers are: Store operations are only active (doing something useful) during the IF, ID, EX and WB stages, Load operations are only active (doing something useful) during the IF, ID, EX and WB stages., Branch operations are only active (doing something useful) during the IF, ID, EX and WB stages.
Question 2 Correct 10.00 points out of 10.00 ¥ Flag question Suppose a program that executes 500 instructions is run using a 7-stage pipeline. In running the program, 142 stall cycles are inserted due to data dependencies. Assuming that the clock period of unpipelined processor is 10% less than the pipelined processor, calculate the Speedup due to pipelining. Round your answer to two decimal places. Answer: 491 v We first calculate the Pipeline.Stall.CPI = 142/ 500. Next, Speedup = (Pipeline.Depth / (1+Pipeline.Stall.CP1))* (CycleTimeynpipelined / CycleTimepipelined) = (7/ (1 +142/500) * 0.900 The correct answer is: 4.91
Question 3 Incorrect 0.00 points out of 10.00 ¥ Remove flag Suppose you have two programs to execute. Program 1 consists of 28% (Load + Store) instructions, Program 2 consists of only 3% (Load + store) instructions. You have two Machine choices for each program. Machine 1 contains a 2GHz, 20 stage pipeline with a dual ported memory and Machine 2 contains a 2.15GHz, 20 stage pipeline, but has a single ported memory. Assume that the clock rates above are for the pipelined case and that the clock rate for the unpipelined case is 2.8GHz for both machines. Which machine is the best choice for each program?
Assume that the clock rates above are for the pipelined case and that the clock rate for the unpipelined case is 2.8GHz for both machines. Which machine is the best choice for each program? (Hint: Calculate the speedup for each machine with Program 1 and 2 and compare). Select one: a. The best machine for Program 1 is Machine 2 and the best machine for Program 2 is also Machine 2. b. The best machine for Program 1 is Machine 1 and the best machine for Program 2 is Machine 2. c. The best machine for Program 1 is Machine 1 and the best machine for Program 2 is also Machine 1. d. The best machine for Program % 1 is Machine 2 and the best machine for Program 2 is Machine 1. Your answer is incorrect. First calculate the speedup for each machine N L Il S A SN I gn S
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
1- Each Student Creates the F1 & F2 Equation With Their Own Number
For example: Student Number: 249176126876
FI=2X^5+4X^4+9X^3+1X^2+7X^1+6X^0
F2 =1X^5+2X^4+6X^3+8X^2+7X^1+6X^0
For two equations:
1. Perform addition and the result (T) is variable.
2. Subtract and the result (C) is variable.
3. If: X = linspace (-5, 5, 100), plot the relationship between X and T.
4. Do the multiplication and the result (V) is a variable.
5. Divide and the result (A, B) is variable.
6. Introduce (T/F1) as a transfer function in MATLAB.
2- Program the desired operation using MATLAB commands for the given transfer function.
write as:
H1/H2=2X^5+9X^3+6/X^6+2X^4+8X^2+7X
For X=linspace (1, 5, 10), if H1>H2,
Draw the relationship between X and H1
or?
Draw the relationship between X and H2
Note: Student number to be used in the solution; 207106106015
To be solved using the Matlap program
arrow_forward
Correct and detailed answer will be Upvoted else downvoted. Thank you!
arrow_forward
-center/sel-activity/11589?backpage=main&assignmentId=23921320
SI Scientific...
The Zombie Apocalypse has finally happened!
You have time to grab only five of the following
items to help you survive. After choosing your items,
get objective rankings from your teacher.
cell phone
grandfather's toolbox
• First aid kit
o box of matches
box of non-perishable food.
swiss army knife you got for your loth birthday
1
2
Dashboard
3
4
5
Your Top 5
Amazing!
0-5
Your objective
decision-making skills
will help you survive the
Zombie Apocalypse!
Add up the numbers in the last column to get your Survival Score
Solid
6-15
For the most part,
you showed objectivity
under pressure.
You've got a good
chance of survival.
MA
$200 in cash
4 gallons of water
quilt your grandma made
photo of your family
• LED flashlight
baseball bat you hit your first homerun with
Objective Ranking
CK
Fair
16-25
You may want to brush
up on your LOGIC
strategies in order
to survive a Zombie
Apocalypse.
DELL
Difference
Good Luck…
arrow_forward
Estem.org/courses/64525/assignments/9460783?module_item_id=18078917
The following information can help you get started:
• Invitation Details: it boils down to when and where
o When: Time and date
• Where: Address
• Invitee List: Name and email
• Name: First Name, or First Name and Last Name
Email: Email address
. Other considerations:
After you complete your invitation, answer the following questions:
1. What type of data are time, date, and place? How are they different from the other data types on the
invite and guest list?
F4
A
Additional information worth including: dress code, directions, gifting, how to contact you.
. How will you know who is showing up? RSVP?
. Is there a theme to your invitation/design?
x
F5
%
F6
F7
DELL
F8
F9
ROMNA
F10
F11
PrtScr
arrow_forward
Determine the primary keys. This step is done normallywhile creating ER/EER.
arrow_forward
Task 4:
The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
arrow_forward
- Blackboard Learn
=view&content id3_68980 1&course id3 2576 1#
44 / 71
90%
Table 2.2: Data for the Customers table.
Customer ID
Job Description
Job Status
Completion Data
555-3451
555-6639
555-7877
555-2258
555-9111
555-8890
IMS
Jacob's Motor Sales
Kelth's Sports Cars, Inc.
Randy's Od Makes
Trevor's Rolling Wheels
Jacob Danlels
Kelth Moorehouse
Randy Petersen
Trevor Craig
Jack Johnson
Nick Stone
KSI
ROM
TRW
Jack's Timeless Classics
Nick's Quick Rides
ITC
NQR
Assignment :
You have been asked to create a small information system to administer the records of a small educational
institution using MS Access. The following details need to be stored: students' surname, first name, date of
birth, the date they enrolled in the institution, papers available for study, including the paper code and paper
title, the enrolments of students in particular papers, including date of enrolment, mark gained, and fee
charged.
Create a database with the appropriate number of tables to store the above data…
arrow_forward
SUPPLIER
PRODUCT
ProductCode
ProductnName
unitPrice
SupCode
supCode
(Number, 3)
SupName
(text, 20)
АВC LLC
(Number, 10)
[Char(10)]
(>0)
1111111
Calculator
10
111
111
2222222
Notebook
2.5
777
222
ХҮX LLC
3333333
Book-AI
20
222
3333
PQR LLC
4444444
Pen
-2.0
222
222
AXL LLC
5555555
Pencil
.500
111
Eraser
.500
222
arrow_forward
Python please
starter code:
# Web App to Get Stock Market Data from AlphaVantage Serviceimport requests#Function that gets stock info from API# Returns results in list of two strings# DO NOT EDIT THIS FUNCTION EXCEPT TO INSERT YOUR API KEY WHERE INDICATEDdef getStock(symbol):baseURL = "https://www.alphavantage.co/query?function=GLOBAL_QUOTE&datatype=csv"keyPart = "&apikey=" + "REPLACE WITH YOUR API KEY" #Add API keysymbolPart = "&symbol=" + symbolstockResponse = requests.get(baseURL+keyPart+symbolPart)return stockResponse.text #Return only text part of response#Function that computes and displays resultsdef main():# Add code that meets the program specifications (see instructions in Canvas)#Code that starts the appmain()
arrow_forward
Instagram
You
All Media
12/24/21, 4:18 PM
Your company is developing a ticketing system for a new
amusement park called Onigiri Land. The Onigiri Land tickets are
categorised by age group category shown in Table 1 below. Those
with privilege card (OLSP) has different tickets price as shown in
Table 2
Table 1: Onigiri Land Age Category
Category
Age Group
Babies
0 to 3
Child
4 to 12 years old
Teen
13 to 20 years old
Adult
21 to 59 years old
Senior Citizen
60 years old and above
82F
arrow_forward
Order Number: 5678
Customer Number: 9123
Customer Name: Thomas
Customer Address: 51 Samora Machel Street
City- Country: Durban, South Africa
ProductNo
A 123
B 234
C 345
Description
A4 Paper
Order Form
Toner
Staples
Normal Form
Quantity
100
200
1000
Date: 25/12/2020
Unit Price
R1.00
R150.00
R5.00
1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data
above.
Example:
Below is an example of the table information converted to zero normal form, read
chapter five in your module guide and convert the table to first, second and third normal
form.
The format of your answer must be as depicted below:
• ORDER( order number, customer number, name, address, order date(product number,
description, quantity, unit price))
arrow_forward
Can you please put this in ERD for me
arrow_forward
PK
Cus CODE
PK
INV NUMBER
PK,FK1 INV NUMBER
LINE NUMBER
HEDenerates
contains
PK
CUS LNAME
CUs FNAME
CUs INITIAL
CUS AREACODE
CUS PHONE
CUS BALANCE
FK1 CUS CODE
INV DATE
P CODE
LINE UNITS
LINE PRICE
FK2
is found in
VENDOR
PRODUCT
PK V CODE
PK
P CODE
V NAME
v CONTACT
V AREACODE
V PHONE
V_STATE
V ORDER
P DESCRIPT
P INDATE
P_QOH
P MIN
P PRICE
DISCOUNT
FK1 V CODE
upplies
Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those
vendors with no matching products.
Y CODE- PRODUCTY CODE
arrow_forward
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.
arrow_forward
Lab 8-1: KimTay Pet Supplies
Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I_INVOICE_NUM. Place these values in the variables I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE respectively. When the procedure is called it should output the contents of I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE.
IN SQL CODE.
CUSTOMER
CUST_ID
FIRST_NAME
LAST_NAME
ADDRESS
CITY
STATE
POSTAL
EMAIL
BALANCE
CREDIT_LIMIT
REP_ID
125
Joey
Smith
17 Fourth St
Cody
WY
82414
jsmith17@example.com
80.68
500.00
05
182
Billy
Rufton
21 Simple Cir
Garland
WY
82435
billyruff@example.com
43.13
750.00
10
227
Sandra
Pincher
53 Verde Ln
Powell
WY
82440
spinch2@example.com
156.38
500.00
15
294
Samantha
Smith
14 Rock Ln
Ralston
WY
82440
ssmith5@example.com
58.60
500.00
10
314
Tom
Rascal
1 Rascal Farm Rd
Cody
WY
82414
trascal3@example.com
17.25
250.00
15
375
Melanie
Jackson
42…
arrow_forward
pps/assessment/take/launch.jsp?course_assessment_id%-_12831_1&course_id%3D_19279_1&content_id%3D 213791 1&step=null
ranslate
G ITDM4111 Tuesday... b Computer Science...
co Untitled2.ipynb - C...
S PDF Merge
Dashboard Prezi
Remaining Time: 38 minutes, 06 seconds.
Question Completion Status:
O DataNode
QUESTION 2
the performance of name node and the job tracker degrades i
When the number of nodes grows beyond
Hadoop version 1.0?
40000
10000
50000
30000
QUESTION 3
Which of the following is a framework used for computing large amount of data store in HDFS?
NameNode
arrow_forward
The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
arrow_forward
Alert dont submit AI generated answer.
arrow_forward
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits.
Table: Camper
CAMPER_NUMBER
1000
1001
1002
1003
CAMPER_LAST_NAME
Jones
Schmidt
Williams
Cooper
CAMPER_FIRST_NAME
Jamie
Pat
Clifford
Amanda
CAMPER_ADDRESS
1278 Essex Pl
4954 Spangled Way
956 Segull Lane
P. O. Box 998877
CAMPER_CITY
El Paso
Portland
Portsmouth
Birmingham
AL
CAMPER STATE
TX
ME
OH
CAMPER_ZIP_CODE
45251
79919
4108
45662
CAMPER_DRIVERS_LICENSE J1998743-98
87632434
WIL885123
765A876B897
CAMPER_EMAIL
jjones@somewhere.com patwonderfu341@nowhere.net williams98342@foomail.com coopera@nowhere.net
Table: Spot
SPOT NUMBER
101
102
103
104
The Pines The Glade Teardrop Spot Tent In Trees
SPOT_NAME
SPOT LENGTH
55
50
20
0
SPOT_PULLTHRU
1
0
0
0
SPOT_ELECTRIC AMPS 50
50
20
0
SPOT WATER
1
1
1
1
SPOT SEWER
1
1
0
SPOT_RATE_WEEKDAY 35
33
12…
arrow_forward
The following table shows a list of pets and their owners that is used by a veterinarian service.
P_Name
Type
Breed
DOB
Owner
O_Phone
O_E-mail
Kino
Dog
Std. Poodle
3/27/97
M. Downs
5551236
md@abc.com
Teddy
Cat
Chartraux
4/2/98
M. Downs
1232343
md@abc.com
Filo
Dog
Std. Poodle
2/24/02
R. James
2343454
rj@abc.com
AJ
Dog
Collie Mix
11/12/95
Liz Frier
3456567
liz@abc.com
Cedro
Cat
Unknown
12/10/96
R.James
7865432
rj@abc.com
Woolley
Cat
Unknown
10/2/00
M. Trent
9870678
mt@abc.com
Buster
Dog
Collie
4/4/01
Ronny
4565433
ron@abc.com
a. Describe 4 problems that are likely to occur when using this table.
b. Break the table into two tables in a way that fixes the four problems.
arrow_forward
None
arrow_forward
Customers
CustomerID INT
◆ FirstName VARCHAR(50)
◆ LastName VARCHAR(50) H
> Email VARCHAR(100)
> Address TEXT
Indexes
F
|
Orders
OrderID INT
> CustomerID INT
> OrderDate DATE
◆ TotalAmount DECIMAL (10,2)
Indexes
#
ShippingInformation
ShippingID INT
> OrderID INT
→ ShippingAddress TEXT
ShippingDate DATE
-K
> EstimatedArrivalDate DATE
→ ShipmentStatus VARCHAR(50)
Indexes
Reviews
ReviewID INT
> ProductID INT
> CustomerID INT
◆ Rating INT
Comment TEXT
> DatePosted DATE
Indexes
OrderDetails
OrderDetailID INT
▶I
> OrderID INT
HI-KO ProductID INT
→ Quantity INT
Subtotal DECIMAL (10,2)
Indexes
T
Categories
CategoryID INT
◆ CategoryName VARCHAR(255)
Indexes
Products
ProductID INT
-H ProductName VARCHAR(255)
> Description TEXT
◆ Price DECIMAL (10,2)
-I+ CategoryID INT
> DiscountID INT
Indexes
Discounts
DiscountID INT
◆ Discount Code VARCHAR(50)
◆ Discount Percentage DECIMAL (5,2)
> StartDate DATE
> EndDate DATE
Indexes
For the design above, Write in SQL a query to print customer names who made…
arrow_forward
Q2:
arrow_forward
6_#.
arrow_forward
Using the following entity information, the primary key of the student who lives in Eastpoint, FL is,
O Start Page A MOTerm Exam
L Relaional, 1 Untited 1
CIS25SOISTUDENT
VARCHARZ S EYTED
VARCHARZ 130 BYTE
VARDAA2 (3 BYTD
SLAST
SIRST
SMI
SADORESS
S CITY
SSTATE
CB2550LFACULTY
NUMEER I
VARCHARZ 0 YTE
VARCHARZ GO BYTE
CHARYT
CHAR LEYTE
VARDARZ 125 YTD
VARCHARZ 20 BYTE
FAST
EARST
MI
FPHONE VARCHARZ 10 BYTE
RANK
FUPER
CHAR 2YTE
VARCHARZ 0 YTD
VARCHAR2 (10 BYTE
CHAR 2 BYTE
DATE
NUMSER 4
NUMBER
INTERVAL YEAR TO MONTH
VARCHARZ OBYT
NUMBER
NUMBER
FACULTYFJD JD
SPHONE
SCLASS
5.006
SUPN
FACULTYFJDFK FJD
TIME DROLLID
STUDENTSID RD
STUDENT F ID K F D
STUDENT SID PK 6JD
Seriat Outut Query Result
SOL I AlI Ros Fetched: 5in 0.74 seconds
rDrLASTLIRST M HONE LRANK
rSUPERFMIN
1 Marx
2 Zhulin Mark
3 Lang ley ColinA
4 Broun JonnelD
5 Sealy Janes L
Teresa
4075921695 Associate
6338
4073875682 Full
(null)
1121
4075928719 Assistant
9871
4
4078101155 Full
(null)
8297
4079817153 Associate
1
Script Output Query…
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
- 1- Each Student Creates the F1 & F2 Equation With Their Own Number For example: Student Number: 249176126876 FI=2X^5+4X^4+9X^3+1X^2+7X^1+6X^0 F2 =1X^5+2X^4+6X^3+8X^2+7X^1+6X^0 For two equations: 1. Perform addition and the result (T) is variable. 2. Subtract and the result (C) is variable. 3. If: X = linspace (-5, 5, 100), plot the relationship between X and T. 4. Do the multiplication and the result (V) is a variable. 5. Divide and the result (A, B) is variable. 6. Introduce (T/F1) as a transfer function in MATLAB. 2- Program the desired operation using MATLAB commands for the given transfer function. write as: H1/H2=2X^5+9X^3+6/X^6+2X^4+8X^2+7X For X=linspace (1, 5, 10), if H1>H2, Draw the relationship between X and H1 or? Draw the relationship between X and H2 Note: Student number to be used in the solution; 207106106015 To be solved using the Matlap programarrow_forwardCorrect and detailed answer will be Upvoted else downvoted. Thank you!arrow_forward-center/sel-activity/11589?backpage=main&assignmentId=23921320 SI Scientific... The Zombie Apocalypse has finally happened! You have time to grab only five of the following items to help you survive. After choosing your items, get objective rankings from your teacher. cell phone grandfather's toolbox • First aid kit o box of matches box of non-perishable food. swiss army knife you got for your loth birthday 1 2 Dashboard 3 4 5 Your Top 5 Amazing! 0-5 Your objective decision-making skills will help you survive the Zombie Apocalypse! Add up the numbers in the last column to get your Survival Score Solid 6-15 For the most part, you showed objectivity under pressure. You've got a good chance of survival. MA $200 in cash 4 gallons of water quilt your grandma made photo of your family • LED flashlight baseball bat you hit your first homerun with Objective Ranking CK Fair 16-25 You may want to brush up on your LOGIC strategies in order to survive a Zombie Apocalypse. DELL Difference Good Luck…arrow_forward
- Estem.org/courses/64525/assignments/9460783?module_item_id=18078917 The following information can help you get started: • Invitation Details: it boils down to when and where o When: Time and date • Where: Address • Invitee List: Name and email • Name: First Name, or First Name and Last Name Email: Email address . Other considerations: After you complete your invitation, answer the following questions: 1. What type of data are time, date, and place? How are they different from the other data types on the invite and guest list? F4 A Additional information worth including: dress code, directions, gifting, how to contact you. . How will you know who is showing up? RSVP? . Is there a theme to your invitation/design? x F5 % F6 F7 DELL F8 F9 ROMNA F10 F11 PrtScrarrow_forwardDetermine the primary keys. This step is done normallywhile creating ER/EER.arrow_forwardTask 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.arrow_forward
- - Blackboard Learn =view&content id3_68980 1&course id3 2576 1# 44 / 71 90% Table 2.2: Data for the Customers table. Customer ID Job Description Job Status Completion Data 555-3451 555-6639 555-7877 555-2258 555-9111 555-8890 IMS Jacob's Motor Sales Kelth's Sports Cars, Inc. Randy's Od Makes Trevor's Rolling Wheels Jacob Danlels Kelth Moorehouse Randy Petersen Trevor Craig Jack Johnson Nick Stone KSI ROM TRW Jack's Timeless Classics Nick's Quick Rides ITC NQR Assignment : You have been asked to create a small information system to administer the records of a small educational institution using MS Access. The following details need to be stored: students' surname, first name, date of birth, the date they enrolled in the institution, papers available for study, including the paper code and paper title, the enrolments of students in particular papers, including date of enrolment, mark gained, and fee charged. Create a database with the appropriate number of tables to store the above data…arrow_forwardSUPPLIER PRODUCT ProductCode ProductnName unitPrice SupCode supCode (Number, 3) SupName (text, 20) АВC LLC (Number, 10) [Char(10)] (>0) 1111111 Calculator 10 111 111 2222222 Notebook 2.5 777 222 ХҮX LLC 3333333 Book-AI 20 222 3333 PQR LLC 4444444 Pen -2.0 222 222 AXL LLC 5555555 Pencil .500 111 Eraser .500 222arrow_forwardPython please starter code: # Web App to Get Stock Market Data from AlphaVantage Serviceimport requests#Function that gets stock info from API# Returns results in list of two strings# DO NOT EDIT THIS FUNCTION EXCEPT TO INSERT YOUR API KEY WHERE INDICATEDdef getStock(symbol):baseURL = "https://www.alphavantage.co/query?function=GLOBAL_QUOTE&datatype=csv"keyPart = "&apikey=" + "REPLACE WITH YOUR API KEY" #Add API keysymbolPart = "&symbol=" + symbolstockResponse = requests.get(baseURL+keyPart+symbolPart)return stockResponse.text #Return only text part of response#Function that computes and displays resultsdef main():# Add code that meets the program specifications (see instructions in Canvas)#Code that starts the appmain()arrow_forward
- Instagram You All Media 12/24/21, 4:18 PM Your company is developing a ticketing system for a new amusement park called Onigiri Land. The Onigiri Land tickets are categorised by age group category shown in Table 1 below. Those with privilege card (OLSP) has different tickets price as shown in Table 2 Table 1: Onigiri Land Age Category Category Age Group Babies 0 to 3 Child 4 to 12 years old Teen 13 to 20 years old Adult 21 to 59 years old Senior Citizen 60 years old and above 82Farrow_forwardOrder Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))arrow_forwardCan you please put this in ERD for mearrow_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