Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Local Edit View Query Database Server 6 & 86 wigator00000000000000000000000 HEMAS Filter objects kimtay < Tables Views Stored Procedures Functions sakila Tables Views Stored Procedures Functions: staywell Tables Views Stored Procedures Functions 1444 sys Tables eve confin Administration Schemas Information: Schema: staywell O ^ Query 1 customer SQL File 3" BZIROS 10 CREATE TABLE SUMMER SCHOOL RENTALS 2 3 4 5 6 7 Q 8 Tools Scripting Help 9 10 11 12 13 14 15 e( PROPERTY ID DECIMAL (0) PRIMARY KEY NOT NULL, OFFICE NUM DECIMAL (0) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, SQR FT SMALLINT NOT NULL, BDRMS TINYINT NOT NULL, FLOORS TINYINT NOT NULL, WEEKLY RENT SMALLINT NOT NULL, OWNER NUM CHAR(5) NOT NULL I ); INSERT INTO SUMMER SCHOOL RENTALS VALUES ('1','1','30 west Thomas Rd., 1600','3','1',1400, "BU106'); Result Grid Field ▶ PROPERTY ID OFFICE NUM ADDRESS Result 4 x Output Filter Rows: SQR FT BORMS FLOORS WEEKLY RENT OWNER NUM Type decimal(10,0) NO decimal(10,0) varchar(100) smallint tinyint tinyint smallint char (5) 2 2 2 2 2 2 2 2 2 Null NO Key PRI Export: Default HULL NULL NULL HULL HULL Limit to 1000 rows HULL HULL HULL Wrap Cell Content: A Extra Q17 OR

Local Edit View Query Database Server 6 & 86 wigator00000000000000000000000 HEMAS Filter objects kimtay < Tables Views Stored Procedures Functions sakila Tables Views Stored Procedures Functions: staywell Tables Views Stored Procedures Functions 1444 sys Tables eve confin Administration Schemas Information: Schema: staywell O ^ Query 1 customer SQL File 3" BZIROS 10 CREATE TABLE SUMMER SCHOOL RENTALS 2 3 4 5 6 7 Q 8 Tools Scripting Help 9 10 11 12 13 14 15 e( PROPERTY ID DECIMAL (0) PRIMARY KEY NOT NULL, OFFICE NUM DECIMAL (0) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, SQR FT SMALLINT NOT NULL, BDRMS TINYINT NOT NULL, FLOORS TINYINT NOT NULL, WEEKLY RENT SMALLINT NOT NULL, OWNER NUM CHAR(5) NOT NULL I ); INSERT INTO SUMMER SCHOOL RENTALS VALUES ('1','1','30 west Thomas Rd., 1600','3','1',1400, "BU106'); Result Grid Field ▶ PROPERTY ID OFFICE NUM ADDRESS Result 4 x Output Filter Rows: SQR FT BORMS FLOORS WEEKLY RENT OWNER NUM Type decimal(10,0) NO decimal(10,0) varchar(100) smallint tinyint tinyint smallint char (5) 2 2 2 2 2 2 2 2 2 Null NO Key PRI Export: Default HULL NULL NULL HULL HULL Limit to 1000 rows HULL HULL HULL Wrap Cell Content: A Extra Q17 OR

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: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...
See similar textbooks
icon
Related questions
Question

Assignment: Staywell Student Accomodation 

I don't understand what I need to do here, its in mySQL. Help would be appreciated!

MySQL Workbench File tab SQL Local instance MySQL80 x Edit is lock SQL Navigator: SCHEMAS Q Filter objects View Query Database kimtay < →1 Tables Views Stored Procedures Functions sakila Tables Views Stored Procedures Functions staywell Tables Views Stored Procedures Functions sys Tables eve confin Administration Schemas Information Schema: staywell Object Info Session Q Server Query 1 N 2 2 3 4 5 6 7 customer BIZTA and 8 9 10 11 12 13 O 14 15 Type here to search alt A S Tools Scripting Help Result Grid Field W CREATE TABLE SUMMER SCHOOL RENTALS Result 4 x Output ********* PROPERTY_ID OFFICE NUM ADDRESS SQR_FT BDRMS FLOORS WEEKLY RENT # PROPERTY ID DECIMAL (0) PRIMARY KEY NOT NULL, OFFICE_NUM DECIMAL (0) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, SQR_FT SMALLINT NOT NULL, BDRMS TINYINT NOT NULL, FLOORS TINYINT NOT NULL, WEEKLY RENT SMALLINT NOT NULL, OWNER_NUM CHAR (5) NOT NULL ); INSERT INTO SUMMER SCHOOL RENTALS VALUES ('1','1','30 West Thomas Rd., 1600', '3','11,1400, 'BU106'); OWNER_NUM char(5) Action Output Time # X SQL File 3* x Filter Rows: 3 Type Null decimal(10,0) NO decimal(10,0) NO varchar(100) NO smallint NO tinyint NO tinyint NO smallint NO NO E Action D #1 $ 4 C Key PRI O Ai R I F Export: % Default NULL NULL HULL TEL NULL NULL NULL Limit to 1000 rows NULL HULL 5 V Wrap Cell Content: A Extra T G 46 99+ hp Y & 7 H Message U B N Ip 8 J 19 144 ho K M O alt Result Grid Form Editor 0 Read Only C Pel Upc... 142. P 니
Transcribed Image Text:MySQL Workbench File tab SQL Local instance MySQL80 x Edit is lock SQL Navigator: SCHEMAS Q Filter objects View Query Database kimtay < →1 Tables Views Stored Procedures Functions sakila Tables Views Stored Procedures Functions staywell Tables Views Stored Procedures Functions sys Tables eve confin Administration Schemas Information Schema: staywell Object Info Session Q Server Query 1 N 2 2 3 4 5 6 7 customer BIZTA and 8 9 10 11 12 13 O 14 15 Type here to search alt A S Tools Scripting Help Result Grid Field W CREATE TABLE SUMMER SCHOOL RENTALS Result 4 x Output ********* PROPERTY_ID OFFICE NUM ADDRESS SQR_FT BDRMS FLOORS WEEKLY RENT # PROPERTY ID DECIMAL (0) PRIMARY KEY NOT NULL, OFFICE_NUM DECIMAL (0) NOT NULL, ADDRESS VARCHAR(100) NOT NULL, SQR_FT SMALLINT NOT NULL, BDRMS TINYINT NOT NULL, FLOORS TINYINT NOT NULL, WEEKLY RENT SMALLINT NOT NULL, OWNER_NUM CHAR (5) NOT NULL ); INSERT INTO SUMMER SCHOOL RENTALS VALUES ('1','1','30 West Thomas Rd., 1600', '3','11,1400, 'BU106'); OWNER_NUM char(5) Action Output Time # X SQL File 3* x Filter Rows: 3 Type Null decimal(10,0) NO decimal(10,0) NO varchar(100) NO smallint NO tinyint NO tinyint NO smallint NO NO E Action D #1 $ 4 C Key PRI O Ai R I F Export: % Default NULL NULL HULL TEL NULL NULL NULL Limit to 1000 rows NULL HULL 5 V Wrap Cell Content: A Extra T G 46 99+ hp Y & 7 H Message U B N Ip 8 J 19 144 ho K M O alt Result Grid Form Editor 0 Read Only C Pel Upc... 142. P 니
2. 1. 5. 6. To print a copy of your commands and results using Oracle, use the browser's Pri You may also consult with your instructor for any specific instructions on how she/he mand on the File menu or click the Print button on the browser's toolbar. like your work submitted. and the COMMISSION and RATE columns should use the NUMERIC data type. Exe Create a table named REP. The table has the same structure as the SALES REP shown in Figure 3-15 except the LAST_NAME column should use the VARCHAR 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 commission: 0.00; and rate: 0.05. Display the contents of the REP table. Delete the REP table. Run the script file for the Kim Tay Pet Supplies database to create the five tables and a records to the tables. Be sure to select the script file for the particular DBMS that you are using (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for this text, ask your instructor for assistance.) Confirm that you have created the tables correctly by describing each table and compar 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. 3. 4. Module 3 Kim Tay Pet Supplies Use SQL to complete the following exercises. 1. 2. Critical Thinking name: Kiser 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 5. ducit Run the script te for the StayWell data tables. Be sure to select the script Oracle, or SQL Server) (Not if you do no instructor for assistance) 6. Confirm that you have created the tables comectly by describing the results to Figures 3-48. 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 NUMBER columns should use the NUMBER data type and the MONTHLY_RENT column should be changed to WEEKLY_RENT. Execute the command to describe the layout and 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. 3. Delete the SUMMER SCHOOL RENTALS table. Confirm that you have added all data corectly by viewing the data in paring the results to Figures 1-4 through 1-9 in Module OFFICE COLUMN OFFICE NUM OFFICE NAME ADDRESS AREA CITY STATE ZIP CODE TYPE CITY DECIMAL ADDRESS STATE CHAR OWNER COLUMN OWNER NUM LAST NAME FIRST NAME CHAR CHAR CHAR ZIP_CODE CHAR LENGTH DECIMAL PLACES HULLS ALLOWED ONSCRIPTION TYPE CHAR CHAR 23 CHAR CHAR PROPERTY COLUMN PROPERTY ID OFFICE NUM ADDRESS SQR FT BDRMS FLOORS CHAR CHAR LENGTH CHAR 2 25 TYPE 25 25 MONTHLY RENT OWNER NUM DECIMAL DECIMAL 3 CHAR LENGTH DECIMAL PLACES MULLS ALLOWED DESCRIPTION Cort DECIMAL DECIMAL Property 10 (primary key) Number of office managing the property Property address Property size in square feet Number of bedrooms of the property Number of floors Monthly property rent Number of property owner FIGURE 3-48 Table layouts for the StayWell Student Accommodation database 25 DECIMAL DECIMAL CHAR S Os 2 C 5 Cerver street my ky Cwberats DECIMAL PLACES NULLS ALLOWED DESCRIPTION
Transcribed Image Text:2. 1. 5. 6. To print a copy of your commands and results using Oracle, use the browser's Pri You may also consult with your instructor for any specific instructions on how she/he mand on the File menu or click the Print button on the browser's toolbar. like your work submitted. and the COMMISSION and RATE columns should use the NUMERIC data type. Exe Create a table named REP. The table has the same structure as the SALES REP shown in Figure 3-15 except the LAST_NAME column should use the VARCHAR 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 commission: 0.00; and rate: 0.05. Display the contents of the REP table. Delete the REP table. Run the script file for the Kim Tay Pet Supplies database to create the five tables and a records to the tables. Be sure to select the script file for the particular DBMS that you are using (MySQL, Oracle, or SQL Server). (Note: If you do not have the script files for this text, ask your instructor for assistance.) Confirm that you have created the tables correctly by describing each table and compar 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. 3. 4. Module 3 Kim Tay Pet Supplies Use SQL to complete the following exercises. 1. 2. Critical Thinking name: Kiser 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 5. ducit Run the script te for the StayWell data tables. Be sure to select the script Oracle, or SQL Server) (Not if you do no instructor for assistance) 6. Confirm that you have created the tables comectly by describing the results to Figures 3-48. 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 NUMBER columns should use the NUMBER data type and the MONTHLY_RENT column should be changed to WEEKLY_RENT. Execute the command to describe the layout and 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. 3. Delete the SUMMER SCHOOL RENTALS table. Confirm that you have added all data corectly by viewing the data in paring the results to Figures 1-4 through 1-9 in Module OFFICE COLUMN OFFICE NUM OFFICE NAME ADDRESS AREA CITY STATE ZIP CODE TYPE CITY DECIMAL ADDRESS STATE CHAR OWNER COLUMN OWNER NUM LAST NAME FIRST NAME CHAR CHAR CHAR ZIP_CODE CHAR LENGTH DECIMAL PLACES HULLS ALLOWED ONSCRIPTION TYPE CHAR CHAR 23 CHAR CHAR PROPERTY COLUMN PROPERTY ID OFFICE NUM ADDRESS SQR FT BDRMS FLOORS CHAR CHAR LENGTH CHAR 2 25 TYPE 25 25 MONTHLY RENT OWNER NUM DECIMAL DECIMAL 3 CHAR LENGTH DECIMAL PLACES MULLS ALLOWED DESCRIPTION Cort DECIMAL DECIMAL Property 10 (primary key) Number of office managing the property Property address Property size in square feet Number of bedrooms of the property Number of floors Monthly property rent Number of property owner FIGURE 3-48 Table layouts for the StayWell Student Accommodation database 25 DECIMAL DECIMAL CHAR S Os 2 C 5 Cerver street my ky Cwberats DECIMAL PLACES NULLS ALLOWED DESCRIPTION
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS