Question

MySQL Project, KimTay Pet Supplies and StayWell Student Accomodation questions 1-6. Input and output would be appreciated.

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
expand button
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
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
expand button
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

Want to see the full answer?

Check out a sample Q&A here
Blurred answer
Students who’ve seen this question also like:
Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
Not helpful? See similar books
Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
Computer Networks And The Internet. R1RQ
marketing sidebar icon
Want to see this answer and more?
Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*
*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.

Related Computer Engineering Q&A

Find answers to questions asked by students like you.

Q: By looking at the solutions below you must decide if the answer is right or wrong. Write (✓) if the…

A: pseudocode 1)    has condition A>=B  which is incorrect as  for A to be Tallest condition should…

Q: What are the most important factors to consider about data backup and recovery?

A: Introduction: Data backup: The directories, registration, licensing, and crucial operational data…

Q: #include using namespace std; int main() {

A: the answer is an 3 6 9

Q: PROBLEM 1 Perform Shannon-Fano Coding on the following character set. Character M1 M2 M3 M4 M5 M6 M7…

A: Shannon fan code is constructing a prefix based code on a set of symbols based on their…

Q: What software category do compilers and editors belong under? Explain?

A: Introduction: Compilers and editors are considered to be in the same category when it comes to…

Q: How do user applications and system services interact inside a microkernel architecture? Please use…

A: Given: Within a microkernel design, how can system services and user programmes communicate with one…

Q: You are given a dictionary of names and the amount of points they have. Return a dictionary with the…

A: In this problem we need to design the JS code  and will create a function that gets a array as…

Q: Where may information and communication technologies (ICTS) benefit business and education? What are…

A: Introduction: ICT wasn't explained to me till later in my teaching career.ICT refers to any…

Q: using namespace std; int main() int ij.n fact,sign=-1; float x, p.sum=0; cout>x; the value of n: "…

A: In this question we have to find the code output for the these given code snippet for C++ and select…

Q: Why is access to established technology innovation hubs vital for new technology entrepreneurs?

A: Introduction: Entrepreneurs have conducted extensive market research to identify current trends that…

Q: We discussed two algorithms for computing the transitive closure of a given relation. Use the…

A: Floyd-Warshall Algorithm is an algorithm fo finding the shortest path between all the pairs of…

Q: Our plan is to add one level to Flynn's taxonomy. What separates these P their competitors?

A: Introduction: As for your question, I have addressed it  the second phase. Multitasking The…

Q: * If X = 2,Y = 4, and Z = 6, which of the ?following will give a result of False (X > Y * Z) OR (X *…

A: 1.Option (c) (X>Y*Z) OR (Z>X*Y) will be the option which will be false. Explanation:- As the…

Q: What is a big corporation's usual process for asking authorization to make a network change?

A: You might also want to submit a modified requisition application and other supporting materials when…

Q: What risks are involved in moving databases from one server to another?

A: Data Lower Risk: The process of data migration may result in data loss. Some of the data may not…

Q: Where may information and communication technologies (ICTS) benefit business and education? What are…

A: Introduction: It wasn't until much later in my teaching career that the term "Information and…

Q: What does it mean for a system to be improved?

A: Introduction: The process of system improvement. To solve large-scale and complicated societal…

Q: The manager of your division says, "Photographs are saved in a database, and the design/structure…

A: To protect all of the pictures from malicious activity, security must be provided for that…

Q: Create a C++ program that will input a single letter and printout the corresponding digit on…

A: Program Approach:- 1. Include header file  2. Declare variable char ch 3. Take the input from the…

Q: Your task is to discover and summarize two research articles on project management ethics that have…

A: Bullying at Work:  An Ethical and Leadership Dilemma for All Project Managers" is the title of the…

Q: Describe the many hierarchical views of data that may be provided by LDAP without replicating the…

A: Start: The Lightweight Directory Access Protocol, also known as LDAP, offers a set of guidelines for…

Q: Which two applications are essential for system administrators?

A: Edvard identifies the following as the five states of machines: (a) Fresh — A computer that has its…

Q: What does the term "debugging" in relation to computer programming mean?

A: The answer for the above mentioned question is given in the following steps for your reference.

Q: Adding a level to Flynn's taxonomy would be beneficial, in our opinion. What differentiates premium…

A: Given: We recommend adding a level to Flynn's taxonomy. What makes computers at this level different…

Q: Dividing two occurrences will activate the CRC decoder

A: Cyclic Redundancy Check (CRC):   We know A cyclic redundancy check (CRC) is an error-detection…

Q: Why is access to established technology innovation hubs vital for new technology entrepreneurs?

A: Introduction: Entrepreneurs have discovered current trends via thorough market research that may…

Q: Two essential methods for identifying software flaws and defects are software testing and software…

A: Given Software testing and inspection are necessary to find software faults and mistakes. Software…

Q: What does it mean in the context of programming to "resist the impulse to code"?

A: Introduction: Don't give in to the urge to code: It implies that a software engineer should first…

Q: What information must a set of instructions include? Provide a brief overview of the SRC.

A: Details in the instruction set The component of the computer that is most related to programming is…

Q: Why is access to established technology innovation hubs vital for new technology entrepreneurs?

A: Innovation hubs are entrepreneurial hubs. They share an identity, a feeling of belonging, and…

Q: What are some signs that the useful life of a system is coming to an end?

A: We have to explain, what are some signs that the useful life of a system is coming to an end?

Q: 6. Let G be a simple k-regular graph with the property that every cycle has length at least 4. Prove…

A: There is nothing to show if k = 0, because every network contains at least 0 = 2k vertices. So we…

Q: Which of the three levels of abstraction is suitable for data?

A: Introduction: Database structures are complicated. Inventors employ abstraction to make the system…

Q: From a dataframe convert the months value to words (e.i. 1 = January, 2 = February, etc.)

A: I give the code in Python along with the code and output screenshots

Q: What does the term "debugging" in relation to computer programming mean?

A: Answer to the given question Debugging, in PC programming and designing, is a multistep cycle that…

Q: Which visible moon phase would come after the one below?

A: It is possible to see the moon: Every phase of the Moon is visible in the sky throughout the day,…

Q: What does it mean to adhere to a naming convention?

A: Introduction: A naming convention is a set of guidelines that are used in programming to choose the…

Q: Antiquated networks or protocols that finally disappear: current legacy legendary none of the above…

A: Antiquated networks or protocols that finally disappear:- Legacy

Q: How should the routing table for each router be configured?

A: Routing Table basically contains information about the route for packet in it. Routing Tables are…

Q: Question 3In the program below you will see that 6 random numbers in the range 1..49 arestored in…

A: srand() in C Parameters is seed which is an integer value which might operate as the algorithm's…

Q: Q4\A) Write C++ Program to do arithmetic operations depending upon user choice, using switch case.

A: C++ Program to Perform Arithmetic Operations using the Switch Case Algorithm: 1. Include the header…

Q: Is it possible to provide a succinct summary of the most crucial system installation steps?

A: The Answer is in step2

Q: using namespace std; evoid wth(int i, int &k) { i = 1; k = 2; 4} int main() { int x = 0; wth(x, x);…

A: Code Snippet #include <algorithm> #include <iostream> #include <vector> using…

Q: Which function is used to displays ?the value of the variable in Matlab None of the above O…

A: NOTE  :-  As per our guidelines we are supposed to answer only one question. Kindly repost other…

Q: Any software project may use verification, validation, and security testing techniques.

A: The Security ExamsComputer and network monitoring software analysis looks for flaws, threats, and…

Q: Do you feel that automation is promoting the expansion of knowledge-based occupations?

A: Answer: The term "automation" refers to a method of doing a variety of activities that uses…

Q: Start with an R command which creates DataB, a vector filled with 1000 random numbers from the…

A: Q: Code the given problems for the random vector

Q: The classes Month Calendar and DateTimerPicker are defined below.

A: DateTimerPicker: 1 This is handy for determining the value of a specific date and/or time. This is a…

Q: First I have to Nest an img element within the header element below the heading element. Use…

A: As per the given question, I need to modify the given code, such that it follows the given…

Q: #include using namespace std; void division (int num, int denom); int main() { division (5, -1);…

A: In this question we have been given some programs and we need to find out the correct output of the…

Knowledge Booster
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
  • 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
  • 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