Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Create one new table

Create one new table

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Create one new table Products_xxxx. Your table names must follow the above format
(table name is case sensitive) with following fields in correct data types.

p_id: auto_increment integer, primary key 
 name: varchar(200), unique, NOT NULL 
 description: varchar(200), NOT NULL 
 type: varchar(50), NOT NULL 
 sell_price: float, NOT NULL 
 cost: float, NOT NULL 
 quantity: int, NOT NULL 
 e_id: int, NOT NULL, a foreign key to the employee_id field in the table

v_id: int, NOT NULL, a foreign key to the vendor_id field in the table.

109 iphone 123 110 cheese 111 asd 112 car 113 prod1 114 banjo 115 NULL 116 abcdeq 117 NULL2 118 LG 119 LG12 120 LG12n 121 aaaaaa 122 banjo-- 123 watch 124 d 125 | Fridge 126 | ddd 127 cat 128 ddddd 129 W 130 Juicer 131 | nintendo 132 | 3rd Generation. 133 coconut 134 rtrt 135 bananas 136 dog iphone 6 cheese asd vehicel test prod1 b NULL abcdeq NULL12 TV TV1 TV19 aaAA | b | apple | d | Refrigerator | d | animal | d e | Fruit Juicer jkjkk IPhone XV fruit fruit fruit | dog electronics kitchen electronics electronics furniture electronics furniture electronics furniture electronics electronics electronics | electronics electronics electronics electronics electronics | | electronics electronics | furniture furniture | kitchen electronics electronics electronics furniture kitchen | furniture 1300 500 15.99 5.99 | 5 | 3 | 2000 | 1000 | 3 2 | 500 3.1 3.1 123 | 3 | 15 | 3 | 10 | 550 | 123 123 750 222 220 4 3 400 15 450 45 | 259 20 5 65 98 800 500 3000 1000 500 200 2000 1000 2000 1000 1 | 4 | 3 | 4 | 40 | 8 | 20 4 60 1 | 100 50 ΞΕΝΟ 20 12 12 | 12 | 2 | 2 | 100 | 10 225 | 10 | 14 | 2147483647 | 1 | 1 | 1 | 1 | 1 | 3 | 4 | 21 1 | 3 | 3 | 3 | 10 4 221 | 221 | 1 6 6 6 1 6 6 | 1001 6 | 1001 6 1001 1 | 1001 1 1001 1 | 1001 1001 ∞ ∞099 1002 | 1005 | 1001 | 1001 1001 1002 6 6 1001 1002 8 1001 1001 8 8 6 1001 1002 8 | 1001 1 | 1001 1 1003 1 1001 1 1003 6 | 1001 6 1003 1001 1004 6 6 6
Transcribed Image Text:109 iphone 123 110 cheese 111 asd 112 car 113 prod1 114 banjo 115 NULL 116 abcdeq 117 NULL2 118 LG 119 LG12 120 LG12n 121 aaaaaa 122 banjo-- 123 watch 124 d 125 | Fridge 126 | ddd 127 cat 128 ddddd 129 W 130 Juicer 131 | nintendo 132 | 3rd Generation. 133 coconut 134 rtrt 135 bananas 136 dog iphone 6 cheese asd vehicel test prod1 b NULL abcdeq NULL12 TV TV1 TV19 aaAA | b | apple | d | Refrigerator | d | animal | d e | Fruit Juicer jkjkk IPhone XV fruit fruit fruit | dog electronics kitchen electronics electronics furniture electronics furniture electronics furniture electronics electronics electronics | electronics electronics electronics electronics electronics | | electronics electronics | furniture furniture | kitchen electronics electronics electronics furniture kitchen | furniture 1300 500 15.99 5.99 | 5 | 3 | 2000 | 1000 | 3 2 | 500 3.1 3.1 123 | 3 | 15 | 3 | 10 | 550 | 123 123 750 222 220 4 3 400 15 450 45 | 259 20 5 65 98 800 500 3000 1000 500 200 2000 1000 2000 1000 1 | 4 | 3 | 4 | 40 | 8 | 20 4 60 1 | 100 50 ΞΕΝΟ 20 12 12 | 12 | 2 | 2 | 100 | 10 225 | 10 | 14 | 2147483647 | 1 | 1 | 1 | 1 | 1 | 3 | 4 | 21 1 | 3 | 3 | 3 | 10 4 221 | 221 | 1 6 6 6 1 6 6 | 1001 6 | 1001 6 1001 1 | 1001 1 1001 1 | 1001 1001 ∞ ∞099 1002 | 1005 | 1001 | 1001 1001 1002 6 6 1001 1002 8 1001 1001 8 8 6 1001 1002 8 | 1001 1 | 1001 1 1003 1 1001 1 1003 6 | 1001 6 1003 1001 1004 6 6 6
| p_id | name 1 | iPod new1 34 39 hi 40 Apple 66 new 67 | lappy 68 | new test 69 new test3 70 new33 71 | Cake 72 | bc 73 74 | bcc 75 microwave new333 76 77 testing_jj 78 appleaads 81 aaa Test Jazziel 82 A 83 84 cup 00 00 Gary 85 headset 86 SAZ 87 88 loo 89 * 90 iPhone 91 | alexa 92 | new3 93 abc1233333 94 95 96 97 98 99 100 Test 101 testing the 5th 102 | testing the 6th 103 Testfff 104 Testff 105 Counter 106 Counter1 107 | Sink 108 dsgf egg table new test33 Light Up Bouncy Ball test the 4th iphone222 | description | hi this is a test 2e a new test Laptoppp this is a new test computer in good condituioin this is a test this is a new test this is a test Apple bc Dell laptop xps1 Xeon none microwave testing 123 xyzz aaa B Example Plastic sony headset mouse * Yellow voice this is a new test this is a new test egg description table dexciption this a new test A rubber ball that lights up when bounced test 222 Testing test test test test Granite Granite | Large dgdf | type furniture | electronics electronics kitchen furniture electronics furniture furniture furniture electronics furniture electronics electronics furniture kitchen furniture kitchen furniture | electronics electronics kitchen electronics furniture furniture furniture | electronics electronics electronics | kitchen kitchen kitchen furniture electronics electronics kitchen electronics furniture kitchen kitchen furniture furniture furniture furniture | kitchen furniture | sell_price | cost | quantity 2 | 40 12 | 15 | 100 | 9000 10 666 | 5 | 45 12 | 100 | 5 | 100 | 1234 490 250 14 25 333 | 11000 50 5000 44 | 65 45 333 10 300 3000 45 140 1111 | 2 4 20 150 | 45 2 | 2 2000 2000 80 43 333 5 10 33 | 5 | 5 | 1500 25 10 | 10900 | 4 44 400 400 | 450 54 10 | 12 | 122 1 3 | 15 | 100 | 20 1 | 1 | 1000 | 1000 | 45 | 33 | 100 | 2 | 5 | 3 | 1 | 1 | 1234 15 | 1 | 100 | 3 | 41 250 250 345 34 2000 400 12 200 3 | 5 5 | 3 | 3 | 1 | 1 | N N | e_id | v_id 3 | 1 | 2 | 1 1 | 2 | 1 | 3 5 | | 10 20 2 100 | 100 10 10 500 | 3 | 3 | 20 | 21 3 | 1000 | 1 | 1 | 100 10 10 20 4 4 | 20 5 3 | 1 | 1001 2 1001 2 | 1001 2 1001 1 | 1004 8 1002 7 | 1001 7 | 1001 1 | 1001 1 1001 1 | 1002 1 | 1001 1 | 1001 8 | 1001 1 1003 1 | 2 1 | 1001 1003 1001 1002 1 1001 1001 1001 LLLLL 1 1 1 1 1 1002 1001 1001 1001 1 1001 LLLN H 1 1 2 | 1001 1003 6 6 1001 1 1002 1 1002 1 1 1005 1003 1 | 1001 1002 तततततत 1 1 1001 1001 1001 1003 1 | 1001 1004 1 1 1 2 2 1004 6 1004 1 1001
Transcribed Image Text:| p_id | name 1 | iPod new1 34 39 hi 40 Apple 66 new 67 | lappy 68 | new test 69 new test3 70 new33 71 | Cake 72 | bc 73 74 | bcc 75 microwave new333 76 77 testing_jj 78 appleaads 81 aaa Test Jazziel 82 A 83 84 cup 00 00 Gary 85 headset 86 SAZ 87 88 loo 89 * 90 iPhone 91 | alexa 92 | new3 93 abc1233333 94 95 96 97 98 99 100 Test 101 testing the 5th 102 | testing the 6th 103 Testfff 104 Testff 105 Counter 106 Counter1 107 | Sink 108 dsgf egg table new test33 Light Up Bouncy Ball test the 4th iphone222 | description | hi this is a test 2e a new test Laptoppp this is a new test computer in good condituioin this is a test this is a new test this is a test Apple bc Dell laptop xps1 Xeon none microwave testing 123 xyzz aaa B Example Plastic sony headset mouse * Yellow voice this is a new test this is a new test egg description table dexciption this a new test A rubber ball that lights up when bounced test 222 Testing test test test test Granite Granite | Large dgdf | type furniture | electronics electronics kitchen furniture electronics furniture furniture furniture electronics furniture electronics electronics furniture kitchen furniture kitchen furniture | electronics electronics kitchen electronics furniture furniture furniture | electronics electronics electronics | kitchen kitchen kitchen furniture electronics electronics kitchen electronics furniture kitchen kitchen furniture furniture furniture furniture | kitchen furniture | sell_price | cost | quantity 2 | 40 12 | 15 | 100 | 9000 10 666 | 5 | 45 12 | 100 | 5 | 100 | 1234 490 250 14 25 333 | 11000 50 5000 44 | 65 45 333 10 300 3000 45 140 1111 | 2 4 20 150 | 45 2 | 2 2000 2000 80 43 333 5 10 33 | 5 | 5 | 1500 25 10 | 10900 | 4 44 400 400 | 450 54 10 | 12 | 122 1 3 | 15 | 100 | 20 1 | 1 | 1000 | 1000 | 45 | 33 | 100 | 2 | 5 | 3 | 1 | 1 | 1234 15 | 1 | 100 | 3 | 41 250 250 345 34 2000 400 12 200 3 | 5 5 | 3 | 3 | 1 | 1 | N N | e_id | v_id 3 | 1 | 2 | 1 1 | 2 | 1 | 3 5 | | 10 20 2 100 | 100 10 10 500 | 3 | 3 | 20 | 21 3 | 1000 | 1 | 1 | 100 10 10 20 4 4 | 20 5 3 | 1 | 1001 2 1001 2 | 1001 2 1001 1 | 1004 8 1002 7 | 1001 7 | 1001 1 | 1001 1 1001 1 | 1002 1 | 1001 1 | 1001 8 | 1001 1 1003 1 | 2 1 | 1001 1003 1001 1002 1 1001 1001 1001 LLLLL 1 1 1 1 1 1002 1001 1001 1001 1 1001 LLLN H 1 1 2 | 1001 1003 6 6 1001 1 1002 1 1002 1 1 1005 1003 1 | 1001 1002 तततततत 1 1 1001 1001 1001 1003 1 | 1001 1004 1 1 1 2 2 1004 6 1004 1 1001
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS