Question

Based on the ER Diagram in Figure 1 Product Suppliers, and the relation model from task 1 use SQL DDL commands to create the tables in Oracle SQL Plus. Use the SQL DDL CREATE TABLE command to: • Create the tables - think about the order in which to create the tables so as to avoid any problems with FK to PK links • Develop the attributes • Select suitable data types/length • Ensure that you create PK and FK constraints where appropriate • The syntax for creating a composite PK is: CREATE TABLE YourTableName (Column1 datatype1, Column2 datatype2, CONSTRAINT PK_Name PRIMARY KEY (Column1, Column2)); • After creating each table - view the table schema (design) in Oracle SQL Plus, then copy/paste the query and the table schema into your final report • Also save all of your code in a notepad file EGIS SUPPLIER EGIS +PK SupplD EGIS SuppName RE Contact EGIS Email EGIS UNREGISTE COMPONENT UNF PK CompID CompName Description Cost Price UNRE CompSupp RED UNRE ERED E PK,FK CompIDO PK,FK SuppID RED UNREGISTERI UNREGISTERED UNREGISTERED UNREGISTE NREGISTERED UNREGISTERI UNREGISTERED UNREGISTERI NREGISTERED UNREGIS REGISTERED UNREGIS INREGISTERED UNREGIS ED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS ERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS BUILD PK,FK CompID PK,FK ProdID ComponentQuantity ERED UNRE ERED NRE C RE ERED UNRE PRODUCT HPK ProdID ProdName QuantityOnHand SalePrice TERED UNREGIS TERED UNREGIS STERED UNREGIS STERED UNREGIS STERED UNREGIS UNREGISTERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS UNREGISTERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS Figure 1: Entity Relationship Diagram - Product Suppliers

          Based on the ER Diagram in Figure 1 Product Suppliers, and the relation model from task 1 use SQL
DDL commands to create the tables in Oracle SQL Plus. Use the SQL DDL CREATE TABLE command to:
• Create the tables - think about the order in which to create the tables so as to avoid any problems
with FK to PK links
• Develop the attributes
• Select suitable data types/length
• Ensure that you create PK and FK constraints where appropriate
• The syntax for creating a composite PK is: CREATE TABLE YourTableName (Column1 datatype1,
Column2 datatype2, CONSTRAINT PK_Name PRIMARY KEY (Column1, Column2));
• After creating each table - view the table schema (design) in Oracle SQL Plus, then copy/paste the
query and the table schema into your final report
• Also save all of your code in a notepad file
EGIS
SUPPLIER
EGIS
+PK SupplD
EGIS
SuppName
RE
Contact
EGIS
Email
EGIS
UNREGISTE
COMPONENT
UNF
PK CompID
CompName
Description
Cost Price
UNRE
CompSupp
RED UNRE
ERED
E
PK,FK CompIDO
PK,FK SuppID
RED UNREGISTERI
UNREGISTERED UNREGISTERED UNREGISTE
NREGISTERED UNREGISTERI
UNREGISTERED UNREGISTERI
NREGISTERED UNREGIS
REGISTERED UNREGIS
INREGISTERED UNREGIS
ED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
ERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
BUILD
PK,FK CompID
PK,FK ProdID
ComponentQuantity
ERED UNRE
ERED
NRE
C
RE
ERED UNRE
PRODUCT
HPK ProdID
ProdName
QuantityOnHand
SalePrice
TERED UNREGIS
TERED UNREGIS
STERED UNREGIS
STERED UNREGIS
STERED UNREGIS
UNREGISTERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
UNREGISTERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
Figure 1: Entity Relationship Diagram - Product Suppliers

Based on the ER Diagram in Figure 1 Product Suppliers, and the relation model from task 1 use SQL
DDL commands to create the tables in Oracle SQL Plus. Use the SQL DDL CREATE TABLE command to:
• Create the tables - think about the order in which to create the tables so as to avoid any problems
with FK to PK links
• Develop the attributes
• Select suitable data types/length
• Ensure that you create PK and FK constraints where appropriate
• The syntax for creating a composite PK is: CREATE TABLE YourTableName (Column1 datatype1,
Column2 datatype2, CONSTRAINT PKName PRIMARY KEY (Column1, Column2));
• After creating each table - view the table schema (design) in Oracle SQL Plus, then copy/paste the
query and the table schema into your final report
• Also save all of your code in a notepad file
EGIS
SUPPLIER
EGIS
+PK SupplD
EGIS
SuppName
RE
Contact
EGIS
Email
EGIS
UNREGISTE
COMPONENT
UNF
PK CompID
CompName
Description
Cost Price
UNRE
CompSupp
RED UNRE
ERED
E
PK,FK CompIDO
PK,FK SuppID
RED UNREGISTERI
UNREGISTERED UNREGISTERED UNREGISTE
NREGISTERED UNREGISTERI
UNREGISTERED UNREGISTERI
NREGISTERED UNREGIS
REGISTERED UNREGIS
INREGISTERED UNREGIS
ED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
ERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
BUILD
PK,FK CompID
PK,FK ProdID
ComponentQuantity
ERED UNRE
ERED
NRE
C
RE
ERED UNRE
PRODUCT
HPK ProdID
ProdName
QuantityOnHand
SalePrice
TERED UNREGIS
TERED UNREGIS
STERED UNREGIS
STERED UNREGIS
STERED UNREGIS
UNREGISTERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
UNREGISTERED UNREGISTERED UNREGISTERED UNREGISTERED UNREGIS
Figure 1: Entity Relationship Diagram - Product Suppliers

Added by Shawna S.

Question

Please give Ace some feedback