Build Z_COMPANY database and its table structures using SQL language. INV_NUMBER LINE_NUMBER P_CODELINE_UNITS LINE_PRICE$14.9910011 13-02P210012 23109-HB1$9.9510021 54778-272$4.9910031 2238OPD$38.9510032 1546-Q02$39.953 13-02P21 54778-2T1003$14.9910043$4.9910042 23109-HB219.9510051 PVC23DRT12$5.8710061 SM-18277$6.9910062 2232/QTY$109.9210063 23109 HB19.9510064 89-WRE-O$256.9910071 13-02P22$14 992 54778-211 PVC23DRT1007$4.9910085$5.8710082 WRTT3$119.95$9.9510083 23109-HBFigure 1.5 LINE tablePINDATE P ONHAND PMIN P PRICE P DISCOUNT V_CODEP CODE11GER/31 Power painter, 16 psi, 3-nozzle1302/P2 7 25in pwr sa blade14-01AS 9.00-in pwr. Saw blade1646-002 Hrd cloth, 14-n, 2x601558-OW1 Hrd cloth, 1/2-n, 3602232/OTY BRD jgsw, 12-in blate2232/aWE BED jgsaw, B-in blade2238/OPD BLD codless dil, 12in23109-HB Claw hammer23114 AA Sledge hammer, 12 .54778 27 Rattal e, 16in fne9 WRE-O Hicut chain saw, 16 inPVC230RT PVC pipe, 35in. 6ASM 18277 125-in metal screw, 26Sw-23116 26in wt serew, 60WRVTTI Steel matting, 4v1.6", 5" meshP DESCRIPT5 S109.991503 Nov0113 Dec-0113 No0115Jan-0215Jan-0230-Dec-0124-Dec-0120Jan 0220 Jan-0200 Jan 020.000.060000.000002559521344213442311923119242082428832161623$14.9912$17.49139.95$43905 $100 9212230.060.100.060.000050.000.000000.102559521226995$14.402010213442420016-Dec 0143$4.995 $256.9907feb0220Feb0201-Mar0224Feb-0217-Jan-021118817223718751005 $119952122521231Figure 1.6 PRODUCT tableV CONTACT V AREACODEV CODE122 Bryson, inc21226 Superloo, inc. Flushing21231 DE Spply21344 Oomez Bros22567 Dome Supply Smah23119 Randsets Ltd.24004 Evackman Bros. Browning24200 ORDVA, inc.25443 BSK, Inc.25501 Danal Supples Smythe25505 Rubicon Sis.V HAMEV PHOHEV STATEV ORDERSmthson615223-3234TNSinghOrtega615615215-0006FL220-3245TN009-2546KYIN678-1419678-3900220-1410INAnderson615TN098-1234NHaktordSmhTN004NPL090-3629227-0000TN456-0092INOrton004FLFigure 1.7 VENDOR table (2.a) Build Z_COMPANY database and its table structures. Use the data listings as your guide todefine the data characteristics. For example, the PROD_CODE is always composed of eightcharacters, so it may be defined as CHAR(8), also ensure you create primary keys, foreign keysand RI constraints shown in the relational schema in Figure 1.2.(2.b) Enter the data into the table structures you defined in 2.a, to match the data in Figures 1.3through 1.7. Note: $ is for demonstration, tables data do not have to include $.CUSTOMERas CODEcus UNAMEcus FNAMEcus INETIALcus AREACODEcus PHONEcus BALANCEINVOICEIW NHRaus coceIw_ DATELINEIW MMERUNE NERcoDeLINE UNITSLINE PRICEFROOUCTCODEP_DESCRIPTP_INDATEPONNDPMINP_PRICEP DESCOUNTV coceVENDORV CODENJNANEV_CONTACTVAREACCCEVPHONEV_STATENORDERFigure 1.2 z_COMPANY database's relational schemaCUS CODE CUS LNAME Cus_FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE10010 RamasAlfred615044-2573S0.0010011 DunneLoonoK713804-1238$0.001UU12 SimenKatnyPaulb15345 610013 Olowski615894-21801536 7510014 OrlandoMyron616222 167210015 OBrian10016 Brown713615442-331297-122810.0010 001221.19AmyJamesCeorgeAClette10017 wams615290-2556S768.99121655$0 0010010 Faris713302-718510019 Smth615297-3809Figure 1.3 CUSTOMER tableINV NUMBER CUS_CODE10011002INV DATE10014 Wednesday, August 18, 199910011 Wednesday, August 18, 199910012 Wednesday, August 18, 1999Thursday, August 19, 1999Thursday, August 19, 1999Thursday, August 19, 1999Thursday, August 19, 1999Thursday, August 19, 19991003100410011100510018100610014100710015100810011Figure 1.4 INVOICE table

The given problem is related to relational database and SQL where the tables samples are given and…

Answered: Build Z_COMPANY database and its table…

Engineering

Computer Engineering

Build Z_COMPANY database and its table structures using SQL language

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

Related questions

Q: Can an actual SQL database from the real world be provided and explained?

A: We take the example of Oracle Database. It is a relational database. It goes under the names…

Q: Why might a database designer choose to store data in BSON format in NoSQL databases?

A: BSON, known as "Binary JSON, " is a format that encodes JSON documents into form. In No SQL…

Q: What is the significance of query optimization in a database environment?

A: Query optimization is a vital process within the realm of databases. Before delving into its…

Q: What are the key characteristics of a NoSQL database, and how does it differ from a traditional SQL…

A: Dynamic Host Configuration Protocol (DHCP) is a network protocol used to automate and simplify the…

Q: Explain the concept of sharding in NoSQL databases and its benefits in scalability.

A: NoSQL databases, often referred to as "Not Only SQL" databases, are a category of database…

Q: What is the role of SQL (Structured Query Language) in interacting with a database?

A: SQL (Structured Query Language) is essential for dealing with databases. It is a language that is…

Q: How are relationships between tables expressed in a relational database?

A: Relationships between tables expressed in a relational database: The building blocks of any…

Q: An example of a real-world SQL database, as well as an explanation of the database, should be…

A: The question is to give an example of a real-world SQL database, as well as an explanation of the…

Q: Database Design is "A graphical presentation of tables, including columns, and their relationships",…

A: In this question we have been given a statement related to database design, we need to determine…

Q: Consider the Schema of the university database. Select SQL query to display a list of all students,…

A: Let's go through each option and provide a detailed explanation for whether it is correct or…

Q: How can indexing on XML columns in a relational database optimize query performance?

A: Indexing on XML columns in a relational database can optimize query performance by accelerating the…

Q: When are DML modifications in database tables made permanent?

A: Introduction: In SQL Developer, you may insert a DML statement in the Worksheet. To access and…

Q: How precisely does one attach PHP to a MySQL database?

A: 1- Create a database connection object using the mysqli_connect() function. It requires the…

Q: Can an actual SQL database from the real world be provided and explained?

A: Introduction: A SQL (Structured Query Language) database is a type of relational database that…

Q: How is Structured Query Language (SQL) distinct from other computer languages?

A: Structured Query Language (SQL) is a programming language designed specifically for managing and…

Q: Explain the key characteristics of a Columnar Database architecture

A: In step2, I have provided brief answer of the given question---------------

Question

Build Z_COMPANY database and its table structures using SQL language.

INV_NUMBER LINE_NUMBER P_CODE
LINE_UNITS LINE_PRICE
$14.99
1001
1 13-02P2
1001
2 23109-HB
1
$9.95
1002
1 54778-27
2
$4.99
1003
1 2238OPD
$38.95
1003
2 1546-Q02
$39.95
3 13-02P2
1 54778-2T
1003
$14.99
1004
3
$4.99
1004
2 23109-HB
2
19.95
1005
1 PVC23DRT
12
$5.87
1006
1 SM-18277
$6.99
1006
2 2232/QTY
$109.92
1006
3 23109 HB
19.95
1006
4 89-WRE-O
$256.99
1007
1 13-02P2
2
$14 99
2 54778-21
1 PVC23DRT
1007
$4.99
1008
5
$5.87
1008
2 WRTT3
$119.95
$9.95
1008
3 23109-HB
Figure 1.5 LINE table
PINDATE P ONHAND PMIN P PRICE P DISCOUNT V_CODE
P CODE
11GER/31 Power painter, 16 psi, 3-nozzle
1302/P2 7 25in pwr sa blade
14-01AS 9.00-in pwr. Saw blade
1646-002 Hrd cloth, 14-n, 2x60
1558-OW1 Hrd cloth, 1/2-n, 360
2232/OTY BRD jgsw, 12-in blate
2232/aWE BED jgsaw, B-in blade
2238/OPD BLD codless dil, 12in
23109-HB Claw hammer
23114 AA Sledge hammer, 12 .
54778 27 Rattal e, 16in fne
9 WRE-O Hicut chain saw, 16 in
PVC230RT PVC pipe, 35in. 6A
SM 18277 125-in metal screw, 26
Sw-23116 26in wt serew, 60
WRVTTI Steel matting, 4v1.6", 5" mesh
P DESCRIPT
5 S109.99
15
03 Nov01
13 Dec-01
13 No01
15Jan-02
15Jan-02
30-Dec-01
24-Dec-01
20Jan 02
20 Jan-02
00 Jan 02
0.00
0.06
000
0.00
000
25595
21344
21344
23119
23119
24208
24288
32
16
16
23
$14.99
12
$17.49
139.95
$4390
5 $100 92
12
23
0.06
0.10
0.06
0.00
005
0.00
0.00
000
0.10
25595
21226
995
$14.40
20
10
21344
24200
16-Dec 01
43
$4.99
5 $256.99
07feb02
20Feb02
01-Mar02
24Feb-02
17-Jan-02
11
188
172
237
18
75
100
5 $11995
21225
21231
Figure 1.6 PRODUCT table
V CONTACT V AREACODE
V CODE
122 Bryson, inc
21226 Superloo, inc. Flushing
21231 DE Spply
21344 Oomez Bros
22567 Dome Supply Smah
23119 Randsets Ltd.
24004 Evackman Bros. Browning
24200 ORDVA, inc.
25443 BSK, Inc.
25501 Danal Supples Smythe
25505 Rubicon Sis.
V HAME
V PHOHE
V STATE
V ORDER
Smthson
615
223-3234
TN
Singh
Ortega
615
615
215-0006
FL
220-3245
TN
009-2546
KY
IN
678-1419
678-3900
220-1410
IN
Anderson
615
TN
098-1234
N
Haktord
Smh
TN
004
N
PL
090-3629
227-0000
TN
456-0092
IN
Orton
004
FL
Figure 1.7 VENDOR table

(2.a) Build Z_COMPANY database and its table structures. Use the data listings as your guide to
define the data characteristics. For example, the PROD_CODE is always composed of eight
characters, so it may be defined as CHAR(8), also ensure you create primary keys, foreign keys
and RI constraints shown in the relational schema in Figure 1.2.
(2.b) Enter the data into the table structures you defined in 2.a, to match the data in Figures 1.3
through 1.7. Note: $ is for demonstration, tables data do not have to include $.
CUSTOMER
as CODE
cus UNAME
cus FNAME
cus INETIAL
cus AREACODE
cus PHONE
cus BALANCE
INVOICE
IW NHR
aus coce
Iw_ DATE
LINE
IW MMER
UNE NER
coDe
LINE UNITS
LINE PRICE
FROOUCT
CODE
P_DESCRIPT
P_INDATE
PONND
PMIN
P_PRICE
P DESCOUNT
V coce
VENDOR
V CODE
NJNANE
V_CONTACT
VAREACCCE
VPHONE
V_STATE
NORDER
Figure 1.2 z_COMPANY database's relational schema
CUS CODE CUS LNAME Cus_FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE
10010 Ramas
Alfred
615
044-2573
S0.00
10011 Dunne
Loono
K
713
804-1238
$0.00
1UU12 Simen
Katny
Paul
b15
345 6
10013 Olowski
615
894-2180
1536 75
10014 Orlando
Myron
616
222 1672
10015 OBrian
10016 Brown
713
615
442-331
297-1228
10.00
10 00
1221.19
Amy
James
Ceorge
A
Clette
10017 wams
615
290-2556
S768.99
121655
$0 00
10010 Faris
713
302-7185
10019 Smth
615
297-3809
Figure 1.3 CUSTOMER table
INV NUMBER CUS_CODE
1001
1002
INV DATE
10014 Wednesday, August 18, 1999
10011 Wednesday, August 18, 1999
10012 Wednesday, August 18, 1999
Thursday, August 19, 1999
Thursday, August 19, 1999
Thursday, August 19, 1999
Thursday, August 19, 1999
Thursday, August 19, 1999
1003
1004
10011
1005
10018
1006
10014
1007
10015
1008
10011
Figure 1.4 INVOICE table

Organized collection of structured information, or data, typically stored in a computer system.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Introduction

VIEW

Table keys and foreign keys:

VIEW

CREATE DATABASE and TABLES using SQL:

VIEW

Screenshot

VIEW

Conclusion

VIEW

Step by step

Solved in 5 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Describe the primary keys and foreign keys in the context of database design.
Internet and database keywords vary greatly. They vary greatly. What are the main differences and benefits between the two in query formulation and information return?
How do self-joins enhance query capabilities in relational databases?
What are the considerations in software systems when choosing between NoSQL and SQL databases?
What key information should be included in a typical data dictionary entry for a database table?
Discuss the design principles behind NewSQL databases and how they aim to combine the best of both traditional SQL and NoSQL approaches.
Discuss the role of database indexing in optimizing complex multi-join queries in a relational database.
Could an example of a real-world SQL database be provided?
What are the principles of query optimization in database systems? How can query execution plans be improved?
In the context of database optimization, what are query execution plans, and how are they generated and utilized to improve query performance?