Module 3 To print a copy of your commands and results using Oracle, use the browser's Pret You may also consult with your instructor for any specific instructions on how shehe mand on the File menu or click the Print button on the browser's toolbar like your work submitted Kim Tay Pet Supplies Use SQL to complete the following exercises. 1. 04 Create a table named REP The table has the same structure as the SALES REP and the COMMISSION and RATE columns should use the NUMERIC data type. Exo shown in Figure 3-15 except the LAST NAME column should use the VARCHAR outs the command to describe the layout and characteristics of the REP table. Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser address: 427 Billings Dr.: city: Cody; state: WY, postal: 82414; cell phone: 307-555-630 records to the tables. Be sure to select the script file for the particular DBMS that you ar Run the script file for the Kim Tay Pet Supplies database to create the five tables and ad using (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for this commission: 0.00; and rate: 0.05. Display the contents of the REP table. Delete the REP table. text, ask your instructor for assistance.) Confirm that you have created the tables correctly by describing each table and comparing Confirm that you have added all data correctly by viewing the data in each table and com the results to Figures 3-15, 3-39, 3-41, 3-43, and 3-45. paring the results to Figure 2-1 in Module 2. 5. 6. N 2. 34 Critical Thinking 1. Review the data for the ITEM table in Figure 2-1 in Module 2 and then review the data types used to create the ITEM table in Figure 3-34. Suggest alternate data types for the DESCRIPTION, ON HAND, and STOREHOUSE fields and explain your recommendations. Stay Well Student Accommodation following exercises. CHOOL RENTALS. The table has the same structure rept the PROPERTY_ID and OFFICE MONTHLY RENT colun
Module 3 To print a copy of your commands and results using Oracle, use the browser's Pret You may also consult with your instructor for any specific instructions on how shehe mand on the File menu or click the Print button on the browser's toolbar like your work submitted Kim Tay Pet Supplies Use SQL to complete the following exercises. 1. 04 Create a table named REP The table has the same structure as the SALES REP and the COMMISSION and RATE columns should use the NUMERIC data type. Exo shown in Figure 3-15 except the LAST NAME column should use the VARCHAR outs the command to describe the layout and characteristics of the REP table. Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser address: 427 Billings Dr.: city: Cody; state: WY, postal: 82414; cell phone: 307-555-630 records to the tables. Be sure to select the script file for the particular DBMS that you ar Run the script file for the Kim Tay Pet Supplies database to create the five tables and ad using (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for this commission: 0.00; and rate: 0.05. Display the contents of the REP table. Delete the REP table. text, ask your instructor for assistance.) Confirm that you have created the tables correctly by describing each table and comparing Confirm that you have added all data correctly by viewing the data in each table and com the results to Figures 3-15, 3-39, 3-41, 3-43, and 3-45. paring the results to Figure 2-1 in Module 2. 5. 6. N 2. 34 Critical Thinking 1. Review the data for the ITEM table in Figure 2-1 in Module 2 and then review the data types used to create the ITEM table in Figure 3-34. Suggest alternate data types for the DESCRIPTION, ON HAND, and STOREHOUSE fields and explain your recommendations. Stay Well Student Accommodation following exercises. CHOOL RENTALS. The table has the same structure rept the PROPERTY_ID and OFFICE MONTHLY RENT colun
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
MySQL Project, KimTay Pet Supplies and StayWell Student Accomodation questions 1-6. Input and output would be appreciated.
Transcribed Image Text:QL Workbench
Migration X
Local instance MySQL80 x
Edit View Query Database Server
SQL
tor:
GEMENT
Server Status
Client Connections
Users and Privileges
Status and System Variables
Data Export
Data Import/Restore
NCE
Startup/Shutdown
Server Logs
Options File
RMANCE
Dashboard
Performance Reports
Performance Schema Setup
stration
ation
umn: last_name
Schemas
lation:
3_general_ci
Finition:
ast_name varchar(45)
Info
Session
or closed
Type here to search
D
E
Query 1
12
13
21
4
14
15
16
5
6
9
10
11
10
7
8
LL
2
18 >
19 .
20
Output
V
D
F
0
Action Output
Tools Scripting Help
Time
SQL File 1*
create table REP;
REP ID char (2) PRIMARY KEY,
FIRST NAME varchar(20),
LAST_NAME varchar(20),
ADDRESS varchar(20),
CITY varchar(15),
E
STATE char(2),
POSTAL char(5),
CELL PHONE char(12),
COMMISSION DECIMAL (7,2),
RATE DECIMAL (3,2),
);
insert into KIMTAY.SALES_REP values('05', 'Susan', 'Garcia',
42 Mountain Ln, Cody
insert into KIMTAY. SALES_REP values('15', 'Donna','Smith',
insert into KIMTAY.SALES_REP values('10', 'Richard', 'Miller', '87 Pikes Dr',
312 Oak Rd,
insert into KIMTAY.SALES_REP values ('20', 'Daniel', 'Jackson', '19 Lookout Dr
Ralston
Powell,
Elk Butte,
2 31-17-09 presta datahaea STAYWEU
O
Action
SQL File 2* x SQL File 3*
%
R T
G
5
B
Y
H
SQL File 4*
Limit to 1000 rows
#
87
U
99+
K
W
Message
NY
WX
NY
82414, 307-824-1245, 12743.16,
82440
82448 387-486-43211, 20872.11,
387-982-8401 14912.92,
(307-883-9481
Error Code: 1007. Can't crasta datahaca otswall datahaca avieto
0
0.06,
P
0.04);
8.06);
0.84);
8.84);
88°F ^ Q
Context Help Snippets
to 4)
prt sc
SQLAdditi
1
Autom.
disabled.
manuall
current ca
toggle a
Duration
/ Fetch
0.000 ser
6:45 PM
9/21/2022
delete
backspace
Transcribed Image Text:2.
3.
1.
To print a copy of your commands and results using Oracle, use the browser's Print
You may also consult with your instructor for any specific instructions on how she/he w
mand on the File menu or click the Print button on the browser's toolbar.
like your work submitted.
Kim Tay Pet Supplies
Use SQL to complete the following exercises.
6.
shown in Figure 3-15 except the LAST NAME column should use the VARCHAR data type
and the COMMISSION and RATE columns should use the NUMERIC data type. Executa
Create a table named REP. The table has the same structure as the SALES REP
the command to describe the layout and characteristics of the REP table.
Add the following row to the REP table: rep ID: 35, first name: Fred; last name: Kiser,
address: 427 Billings Dr.; city: Cody; state: WY; postal: 82414; cell phone: 307-555-6309,
Run the script file for the Kim Tay Pet Supplies database to create the five tables and add
commission: 0.00; and rate: 0.05. Display the contents of the REP table.
Delete the REP table.
you are
using (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for this
records to the tables. Be sure to select the script file for the particular DBMS that
text, ask your instructor for assistance.)
5.
2.
Module 3
3.
4.
com
1.
comparing
Confirm that you have created the tables correctly by describing each table and
the results to Figures 3-15, 3-39, 3-41, 3-43, and 3-45.
Confirm that you have added all data correctly by viewing the data in each table and com-
paring the results to Figure 2-1 in Module 2.
Critical Thinking
Review the data for the ITEM table in Figure 2-1 in Module 2 and then review the
data types used to create the ITEM table in Figure 3-34. Suggest alternate data types
for the DESCRIPTION, ON_HAND, and STOREHOUSE fields and explain your
recommendations.
Stay Well Student Accommodation
Use SQL to complete the following exercises.
1.
Create a table named SUMMER SCHOOL_RENTALS. The table has the same structure
as the PROPERTY table shown in Figure 3-48 except the PROPERTY_ID and OFFICE
should be changed to WEEKLY RENT. Execute the command to describe the layout and
NUMBER columns should use the NUMBER data type and the MONTHLY_RENT column
characteristics of the SUMMER SCHOOL RENTALS table.
Add the following row to the SUMMER SCHOOL RENTALS table: property ID: 13; office
ID: 1; address: 5867 Goodwin Ave; square feet: 1,650; bedrooms: 2; floors 1; weekly rent:
400; owner number: CO103.
Delete the SUMMER SCHOOL RENTALS table.
Fun the script te for the Sync
Oracle, or SQL Server (No
instructor for assistance)
Confirm that you have created the tables conectly by describing nach table and comparing
the results to Figures 3-48.
Confirm that you have added all data corectly by viewing the data in each table and com
paring the results to Figures 1-4 through 19 in Module 1
OFFICE
COLUMN
OFFICE NUM
OFFICE NAME
ADDRESS
AREA
CITY
STATE
ZIP CODE
TYPE
DECIMAL
OWNER
COLUMN
OWNER NUM
LAST NAME
FIRST NAME
CITY
ADDRESS
CHAR
CHAR
CHAR
STATE
ZIP CODE
TYPE
CHAR
CHAR
CHAR
25
PROPERTY
COLUMN
PROPERTY ID
OFFICE NUM
ADDRESS
SQR FT
CHAR
BDRMS
CHAR
LENGTH
CHAR
2
CHAR
TYPE
25
DECIMAL PLACES NULLS ALLOWED
DECIMAL
DECIMAL
CHAR
LENGTH
2
2
Property ID (primary key)
Number of office managing the property
Property address
Property size in square fact
Number of bedrooms of the property
Number of floors
FLOORS
MONTHLY RENT
OWNER NUM
Monthly property rent
Number of property owner
FIGURE 3-48 Table layouts for the StayWell Student Accommodation database
DECIMAL
DECIMAL
DECIMAL
25
.5
DECIMAL
CHAR
DECIMAL PLACES NULLS ALLOWED DESCRIPTION
Okner zip code
2
5
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 5 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY