HELP ASAP!! ( using ORACLE MySQL workbench) can you create ERD diagram. Using Crows foot notation and include the attrib

Post by **answerhappygod** » Fri Jul 08, 2022 7:26 am

HELP ASAP!!
( using ORACLE MySQL workbench) can you create ERD diagram. Using Crows foot notation and include the attributes . All many to many (N:M) diagrams should be broken down into Associative entities.
*USE FOLLOWING FIGURES FOR REFERENCES (4-10, 4-13, 4-20)*
*POST SCREENSHOTS ON HOW YOU GOT IT*

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 1 (39.58 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 2 (53.23 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 3 (39.92 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 4 (42.92 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 5 (47.02 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 6 (44.21 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 7 (31.82 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 8 (40.08 KiB) Viewed 46 times

: Help Asap Using Oracle Mysql Workbench Can You Create Erd Diagram Using Crows Foot Notation And Include The Attrib 9 (37.75 KiB) Viewed 46 times

CREATE TABLE AGENT ( AGENT_CODE varchar(50), AGENT PHONE varchar(50) ); INSERT INTO AGENT VALUES ('125', '6152439887'); INSERT INTO AGENT VALUES ('167', '6153426778"); INSERT INTO AGENT VALUES ('231', '6152431124"); INSERT INTO AGENT VALUES ('333', '9041234445'); /" -- "/ CREATE TABLE CUSTOMER ( CUS_CODE varchar(50), CUS LNAME varchar(50), CUS_ZIP varchar(50), AGENT_CODE varchar(50) ); INSERT INTO CUSTOMER VALUES ('1132445', 'walker","32145","231'); INSERT INTO CUSTOMER VALUES ('1217782", "Adares', '32145","125"); INSERT INTO CUSTOMER VALUES ('1312243", "Rakowski', '34129","167"); INSERT INTO CUSTOMER VALUES ('1321242', 'Rodriguez', '37134","125"); INSERT INTO CUSTOMER VALUES ('1542311", "Smithson', '37134","421'); INSERT INTO CUSTOMER VALUES ('1657399", "Vanloo', '32145","231'); /* -- */ CREATE TABLE DIFF_TBL1 ( STU FNAME varchar(50), STU_LNAME varchar(50) ); INSERT INTO DIFF_TBL1 VALUES ('George", "Jones'); TNCEPT TNTA OTEE TRI VAI IEC/ana "Caith'\. File Edit View >; INSERT INTO DIFF_TBL1 VALUES("George", "Jones'); INSERT INTO DIFF_TBL1 VALUES ('Jane", "Smith'); INSERT INTO DIFF TBL1 VALUES("Peter' "Robinson'); INSERT INTO DIFF_TBL1 VALUES ('Franklin', Johnson'); INSERT INTO DIFF_TBL1 VALUES ('Martin', 'Lopez"); /" -- "/ CREATE TABLE DIFF_TBL2 ( EMP_FNAME varchar(50), EMP LNAME varchar(5e) ); INSERT INTO DIFF_TBL2 VALUES("Franklin", "Lopez'); INSERT INTO DIFF_TBL2 VALUES ('William', "Turner'); INSERT INTO DIFF_TBL2 VALUES ('Franklin', Johnson');
INSERT INTO DIFF_TBL1 VALUES ('George' *Jones'); INSERT INTO DIFF_TBL1 VALUES ('Jane', 'Smith'); INSERT INTO DIFF_TBL1 VALUES ('Peter', 'Robinson"); INSERT INTO DIFF_TBL1 VALUES ('Franklin', 'Johnson'); INSERT INTO DIFF_TBL1 VALUES ('Martin', 'Lopez'); /" - "/ CREATE TABLE DIFF_TBL2 ( EMP_FNAME varchar(se), EMP LNAME varchar(50) ); INSERT INTO DIFF_TBL2 VALUES ('Franklin", "Lopez'); INSERT INTO DIFF_TBL2 VALUES ('William', 'Turner'); INSERT INTO DIFF_TBL2 VALUES ('Franklin', Johnson'); INSERT INTO DIFF_TBL2 VALUES ('Susan', 'Rogers'); // CREATE TABLE DIV_TBL1 ( P_CODE varchar(50), CUS_CODE varchar(50) ); '10040'); INSERT INTO DIV_TBL1 VALUES ('123456', '10400"); INSERT INTO DIV_TBL1 VALUES ('123456', '11501"); INSERT INTO DIV TBL1 VALUES ('123456', '10030'); INSERT INTO DIV_TBL1 VALUES ('123456', '12550'); INSERT INTO DIV TBL1 VALUES ('234567', '12350'); INSERT INTO DIV TBL1 VALUES ('234567', INSERT INTO DIV TBL1 VALUES ('234567", INSERT INTO DIV TBL1 VALUES ('234567', INSERT INTO DIV_TBL1 VALUES('234567', INSERT INTO DIV_TBL1 VALUES ('345678", INSERT INTO DIV_TBL1 VALUES ('345678', INSERT INTO DIV TBL1 VALUES ('345678', INSERT INTO DIV_TBL1 VALUES ('456789" 10500 '10030"); '12550'); 10400'); '11630"); "12550'); *11630"); VALUES ('345678', INSERT INTO DIV_TBL1 VALUES('123456' INSERT INTO DIV_TBL1 VALUES ('234567" INSERT INTO DIV_TBL1 VALUES ('234567', INSERT INTO DIV_TBL1 VALUES ('234567', INSERT INTO DIV_TBL1 VALUES ('234567', INSERT INTO DIV_TBL1 VALUES ('234567', INSERT INTO DIV_TBL1 VALUES ('345678'", INSERT INTO DIV TBL1 INSERT INTO DIV TBL1 VALUES ('345678", INSERT INTO DIV_TBL1 VALUES ('456789¹ INSERT INTO DIV_TBL1 VALUES ('567890', INSERT INTO DIV_TBL1 VALUES ('567890', INSERT INTO DIV_TBL1 VALUES ('567890', INSERT INTO DIV_TBL1 VALUES ('678901', INSERT INTO DIV_TBL1 VALUES ('678901', INSERT INTO DIV_TBL1 VALUES ('678901" 12550'); '12350'); '10040'); '10500' '10030'); '12550' '10400'); '11630'); '12550'); '11630'); '10600'); '10030'); '12550'); '11500'); '10400'); '11630');
INSERT INTO DIV_TBL1 VALUES ('567890" INSERT INTO DIV TBL1 VALUES ('567890" INSERT INTO DIV_TBL1 VALUES ('567890', '12550'); INSERT INTO DIV_TBL1 VALUES ('678901', '11500'); INSERT INTO DIV_TBL1 VALUES ('678901" '10400'); INSERT INTO DIV_TBL1 VALUES ('678901" *11630'); /* -- */ CREATE TABLE DIV_TBL2 ( P_CODE varchar(50) ); INSERT INTO DIV_TBL2 VALUES ('123456'); INSERT INTO DIV_TBL2 VALUES ('234567'); INSERT INTO DIV_TBL2 VALUES ('567890'); /* -- */ CREATE TABLE INT_TBL1 ( STU_FNAME varchar(50), STU_LNAME varchar(50) ); INSERT INTO DIFF_TBL1 VALUES ('George", "Jones'); INSERT INTO DIFF_TBL1 VALUES ('Jane', 'Smith'); INSERT INTO DIFF_TBL1 VALUES ('Peter', 'Robinson'); INSERT INTO DIFF_TBL1 VALUES ('Franklin', 'Johnson'); INSERT INTO DIFF_TBL1 VALUES ('Martin', 'Lopez'); INSERT INTO DIFF_TBL1 VALUES ('Martin', 'Lopez'); / -- / CREATE TABLE INT_TBL2 ( EMP_FNAME varchar(50), EMP_LNAME varchar(50) ); '10600'); '10030'); INSERT INTO DIFF_TBL2 VALUES ('Franklin", "Lopez"); INSERT INTO DIFF_TBL2 VALUES ('William', 'Turner'); INSERT INTO DIFF_TBL2 VALUES ('Franklin' *Johnson'); INSERT INTO DIFF_TBL2 VALUES ('Susan", "Rogers'); CREATE TABLE PROD_TBL1 ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), );
Turner); INSERT INTO DIFF_TBL2 VALUES("W1111am INSERT INTO DIFF_TBL2 VALUES ('Franklin', 'Johnson'); INSERT INTO DIFF_TBL2 VALUES ('Susan", "Rogers'); /" -- "/ CREATE TABLE PROD_TBL1 ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); INSERT INTO PROD_TBL1 VALUES ('123456", "Flashlight","5.26'); INSERT INTO PROD_TBL1 VALUES ('123457","Lamp', '25.15'); INSERT INTO PROD TBL1 VALUES ('123458', 'Box Fan', '10.99'); INSERT INTO PROD_TBL1 VALUES ('213345", "9v battery","1.92'); INSERT INTO PROD_TBL1 VALUES ('311452", "Powerdrill","34.99'); INSERT INTO PROD_TBL1 VALUES ('254467', '100w bulb","1.47'); /* -- */ CREATE TABLE PROD_TBL2 ( STORE varchar(5e), AISLE varchar(50), SHELF varchar(50) ); INSERT INTO PROD TBL2 VALUES ('23", "W"," INSERT INTO PROD_TBL2 VALUES ('24', 'K',' INSERT INTO PROD_TBL2 VALUES ('25', '2"," CREATE TABLE PROJ_TBL1 ( P_CODE varchar(5e), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); 10.99'); INSERT INTO PRO)_TBL1 VALUES ('123456", "Flashlight","5.26'); INSERT INTO PROJ TBL1 VALUES ('123457","Lamp', '25.15'); INSERT INTO PROJ_TBL1 VALUES ('123458", "Box Fan INSERT INTO PROJ_TBL1 VALUES ('213345", "9v battery","1.92"); INSERT INTO PROJ_TBL1 VALUES ('311452", "Powerdrill', '34.99"); INSERT INTO PROJ_TBL1 VALUES ('254467", "100w bulb', '1.47"); CREATE TABLE SEL_TBL1 ( P CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric(4,2), ); INSERT INTO SEL_TBL1 VALUES ('123456", "Flashlight","5.26"); INSERT INTO SEL_TBL1 VALUES("123457" amp', '25.15'); INSERT INTO SEL TBL1 VALUES/123458 Box Fan' '10.00'):
INSERT INTO PROJ_TBL1 VALUES ('213345', '9v battery', '1.92'); INSERT INTO PROJ_TBL1 VALUES ('311452", "Powerdrill', '34.99"); INSERT INTO PROJ_TBL1 VALUES ('254467","180w bulb","1.47'); /* -- */ CREATE TABLE SEL_TBL1 ( P_CODE varchar(5e), P_DESCRIPT varchar(50), PRICE numeric (4,2), }; INSERT INTO SEL_TBL1 VALUES ('123456', 'Flashlight","5.26"); INSERT INTO SEL_TBL1 VALUES ('123457","Lamp', '25.15'); INSERT INTO SEL_TBL1 VALUES ('123458', 'Box Fan", "10.99'); INSERT INTO SEL_TBL1 VALUES ('213345', '9v battery","1.92'); INSERT INTO SEL_TBL1 VALUES ('311452', 'Powerdrill","34.99"); INSERT INTO SEL_TBL1 VALUES ('254467', '100w bulb","1.47"); /* -- "/ CREATE TABLE UNI TBL1 ( P CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); INSERT INTO UNI_TBL1 VALUES ('123456', 'Flashlight","5.26'); P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); North. INSERT INTO SEL_TBL1 VALUES ('123456", "Flashlight","5.26'); INSERT INTO SEL_TBL1 VALUES ('123457", "Lamp', '25.15'); INSERT INTO SEL_TBL1 VALUES ('123458', 'Box Fan', '10.99"); INSERT INTO SEL_TBL1 VALUES ('213345', '9v battery', '1.92'); INSERT INTO SEL_TBL1 VALUES ('311452', 'Powerdrill', '34.99'); INSERT INTO SEL_TBL1 VALUES ('254467', '100w bulb', '1.47'); / _ / CREATE TABLE UNI_TBL1 ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); INSERT INTO UNI_TBL1 VALUES ('123456", "Flashlight', '5.26'); INSERT INTO UNI_TBL1 VALUES ('123457', 'Lamp', '25.15'); INSERT INTO UNI_TBL1 VALUES ('123458', 'Box Fan', '10.99'); INSERT INTO UNI_TBL1 VALUES ('213345', '9v battery","1.92'); INSERT INTO UNI_TBL1 VALUES ('311452", "Powerdrill', '34.99'); INSERT INTO UNI_TBL1 VALUES ('254467", "100w bulb","1.47");
ADAN ANTO TOLI VALUES 7553 9V battery L INSERT INTO SEL_TBL1 VALUES ('311452', 'Powerdrill', '34.99"); INSERT INTO SEL_TBL1 VALUES ('254467', '100w bulb', '1.47'); // CREATE TABLE UNI_TBL1 ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), INSERT INTO UNI_TBL1 VALUES ('123456', 'Flashlight', '5.26"); P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); INSERT INTO SEL_TBL1 VALUES ('123456', 'Flashlight', '5.26'); INSERT INTO SEL_TBL1 VALUES ('123457', 'Lamp', '25.15'); INSERT INTO SEL_TBL1 VALUES ('123458', 'Box Fan', '10.99'); INSERT INTO SEL_TBL1 VALUES ('213345', '9v battery","1.92'); INSERT INTO SEL_TBL1 VALUES ('311452", "Powerdrill', '34.99'); INSERT INTO SEL_TBL1 VALUES ('254467', '100w bulb","1.47'); /" -- "/ CREATE TABLE UNI_TBL1 ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); PILY INSERT INTO UNI_TBL1 VALUES ('123456', 'Flashlight', '5.26'); INSERT INTO UNI_TBL1 VALUES ('123457", "Lamp', '25.15'); INSERT INTO UNI TBL1 INSERT INTO UNI_TBL1 VALUES ('123458', 'Box Fan', '10.99'); VALUES ('213345', '9v battery', '1.92'); INSERT INTO UNI_TBL1 VALUES ('311452", "Powerdrill', '34.99"); INSERT INTO UNI_TBL1 VALUES ('254467', '100w bulb', '1.47'); CREATE TABLE UNI_TBL2 ( P_CODE varchar(50), P_DESCRIPT varchar(50), PRICE numeric (4,2), ); INSERT INTO UNI_TBL2 VALUES ('345678", "Microwave', '160'); INSERT INTO UNI_TBL2 VALUES ('345679", "Dishwasher", "500"); INSERT INTO UNI_TBL2 VALUES ('123458', 'Box Fan', '10.99'); */
Figure 4.10 Example Relationships SUPPLIER SUPPLIER- QUOTATION QUOTATION MOTHER CHILD FATHER PARENT
Figure 4.13 Two Versions of a 1:N O-M Relationship DEPARTMENT O DEPARTMENT HO 1:N Minimum cardinality (O-M) Maximum cardinality (1:N) EMPLOYEE EMPLOYEE
Figure 4.20 Example Subtype Entities STUDENT StudentID STUDENT StudentID LastName FirstName isGradStudent UNDERGRADUATE StudentID HighSchoolGPA ScoreOnSAT isGradStudent GRADUATE StudentID UndergraduateGPA ScoreOnGMAT HIKING CLUB StudentID LastName FirstName DateDuesPaid AmountPaid SAILING CLUB StudentID DateDuesPaid AmountPaid