Note: project leader’s employee number is stored in the Projecttable.
Please reply with ERD
- Make An Erd On Www Lucidchart Com Links To An External Site For The Enclosed Set Of Tables Then Snip Its Image And E 1 (622.42 KiB) Viewed 23 times
Make an ERD on www.Lucidchart.com (Links to an external site.) for the enclosed set of tables. Then snip its image and e
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Make an ERD on www.Lucidchart.com (Links to an external site.) for the enclosed set of tables. Then snip its image and e
Make an ERD on www.Lucidchart.com (Links to anexternal site.) for the enclosed set of tables. Then snip itsimage and embed it in the answer box using the image icon. Toembed it, save the image in downloads folder. Then go to theinput text box and the use the image icon above the textbox (in thecenter) to embed the image file. Click the icon, on theupload screen. Check that on bottom left embed image isselected. Choose to upload a image from computer (click onthe rocket), point to downloads folder, select the file and clickSubmit.
Note: project leader’s employee number is stored in the Projecttable.
Please reply with ERD
6.16 Table name: EMPLOYEE EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB CODE News John 08-Nov-00 502 Senior David 12-Jul-89 501 Arbough June 01-Dec-97 503 Ramoras Anne Johnson Alice Smithfield William Alonzo Maria Washington Ralph Smith Larry Olenko Gerald Wabash Smithson Joenbrood 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 Jones Bawangi Pratt Williamson Frommer 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 Geoff Darlene Delbert Annelise Travis Gerald 1021 1022 1023 Angie James 05-Mar-12 22 05-Mar-12 25 05-Mar-12 15 06-Mar-12 15 06-Mar-12 22 06-Mar-12 15 06-Mar-12 25 06-Mar-12 22 06-Mar-12 25 G H E K K 06-Mar-12 18 06-Mar-12 18 06-Mar-12 18 06-Mar-12 15 07-Mar-12 22 08-Mar-12 25 07-Mar-12 25 07-Mar-12 22 D B W A B M K B L H J 104 101 114 Table name: ASSIGNMENT ASSIGN NUM ASSIGN DATE PROJ NUM EMP NUM ASSIGN HOURS TASSIGNICHG HOUR ASSIGN CHARGE 1001 04-Mar-12 15 103 1002 04-Mar-12 18 118 1003 05-Mar-12 15 101 1004 05-Mar-12 22 113 1005 05-Mar-12 15 103 1006 05-Mar-12:25 115 1007 105 1008 101 105 102 111 114 112 15-Nov-88 501 01-Feb-94 502 22-Jun-05 500 10-Oct-94 500 22-Aug-89 501 18-Jul-99 501 118 104 103 105 108 114 106 11-Dec-96 505 04-Apr-89 506 23-Oct-95 507 15-Nov-94 508 20-Aug-91 508 25-Jan-90 501 05-Mar-95 510 19-Jun-94 509 04-Jan-06 510 2.6 1.4 3.6 2.5 1.9 4.2 5.2 1.7 2.0 3.8 2.6 2.3 1.8 4.0 3.4 1.2 2.0 2.6 3.0 2.7 4.2 5.8 2.4 Table name: JOB JOB CODE JOB DESCRIPTION JOB CHG HOUR 500 501 502 503 504 505 506 507 508 509 510 15 18 22 25 Database name: Ch06_ConstructCc Table name: PROJECT PROJ NUM PROJ NAME Evergreen Amber Wave Rolling Tide Starflight 84.50 18.36 105.00 48.10 84.50 96.75 105.00 105.00 105.00 96.75 96.75 105.00 48.10 26.87 48.10 Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer 45.95 18.36 96.75 84 50 105.00 96.75 48.10 35.75 Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 219.70 25.70 378.00 120.25 160.55 406.35 546.00 178.50 210.00 367.65 251.55 241.50 86.58 107.48 163.54 55.14 36.72 251.55 253.50 283.50 406.35 278.98 85.80 EMP NUM 105 104 113 101 35.75 96.75 105.00 84.50 67.90 55.78 26.87 45.95 48.10 34.55 18.36 SOURCE: Course Technology/Cengage
Note: project leader’s employee number is stored in the Projecttable.
Please reply with ERD
6.16 Table name: EMPLOYEE EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB CODE News John 08-Nov-00 502 Senior David 12-Jul-89 501 Arbough June 01-Dec-97 503 Ramoras Anne Johnson Alice Smithfield William Alonzo Maria Washington Ralph Smith Larry Olenko Gerald Wabash Smithson Joenbrood 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 Jones Bawangi Pratt Williamson Frommer 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 Geoff Darlene Delbert Annelise Travis Gerald 1021 1022 1023 Angie James 05-Mar-12 22 05-Mar-12 25 05-Mar-12 15 06-Mar-12 15 06-Mar-12 22 06-Mar-12 15 06-Mar-12 25 06-Mar-12 22 06-Mar-12 25 G H E K K 06-Mar-12 18 06-Mar-12 18 06-Mar-12 18 06-Mar-12 15 07-Mar-12 22 08-Mar-12 25 07-Mar-12 25 07-Mar-12 22 D B W A B M K B L H J 104 101 114 Table name: ASSIGNMENT ASSIGN NUM ASSIGN DATE PROJ NUM EMP NUM ASSIGN HOURS TASSIGNICHG HOUR ASSIGN CHARGE 1001 04-Mar-12 15 103 1002 04-Mar-12 18 118 1003 05-Mar-12 15 101 1004 05-Mar-12 22 113 1005 05-Mar-12 15 103 1006 05-Mar-12:25 115 1007 105 1008 101 105 102 111 114 112 15-Nov-88 501 01-Feb-94 502 22-Jun-05 500 10-Oct-94 500 22-Aug-89 501 18-Jul-99 501 118 104 103 105 108 114 106 11-Dec-96 505 04-Apr-89 506 23-Oct-95 507 15-Nov-94 508 20-Aug-91 508 25-Jan-90 501 05-Mar-95 510 19-Jun-94 509 04-Jan-06 510 2.6 1.4 3.6 2.5 1.9 4.2 5.2 1.7 2.0 3.8 2.6 2.3 1.8 4.0 3.4 1.2 2.0 2.6 3.0 2.7 4.2 5.8 2.4 Table name: JOB JOB CODE JOB DESCRIPTION JOB CHG HOUR 500 501 502 503 504 505 506 507 508 509 510 15 18 22 25 Database name: Ch06_ConstructCc Table name: PROJECT PROJ NUM PROJ NAME Evergreen Amber Wave Rolling Tide Starflight 84.50 18.36 105.00 48.10 84.50 96.75 105.00 105.00 105.00 96.75 96.75 105.00 48.10 26.87 48.10 Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer 45.95 18.36 96.75 84 50 105.00 96.75 48.10 35.75 Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 219.70 25.70 378.00 120.25 160.55 406.35 546.00 178.50 210.00 367.65 251.55 241.50 86.58 107.48 163.54 55.14 36.72 251.55 253.50 283.50 406.35 278.98 85.80 EMP NUM 105 104 113 101 35.75 96.75 105.00 84.50 67.90 55.78 26.87 45.95 48.10 34.55 18.36 SOURCE: Course Technology/Cengage