Referring to Figure 1 in Appendix 1, draw the entity relationship diagram (ERD). The marks distribution is as shown in t

[answerhappygod]

Referring To Figure 1 In Appendix 1 Draw The Entity Relationship Diagram Erd The Marks Distribution Is As Shown In T 1 (46.09 KiB) Viewed 14 times

Referring to Figure 1 in Appendix 1, draw the entity relationship diagram (ERD). The marks distribution is as shown in the following table. I Task Each entity will be given 2 marks Each attribute will be given 1 mark Each constraint will be given 1 mark Each relationship considering cardinality, optional and mandatory, will be given 1 mark . OLD Marks 8 23 9 5
JOB TABLE JOB ID AD PRES AD VP AD ASST AC MGR AC ACCOUNT SA MAN SA REP ST MAN ST CLERK IT PROG MK MAN MK REP LOC ID 1800 2500 1400 1500 1700 JOB TITLE President Administration Vice President Administration Assistant Accounting Manager Public Accountant Sales Manager Sales Representative Stock Manager Stock Clerk LOCATION TABLE Programmer Marketing Manager Marketing Representative STREET ADDRESS 460 Bloor St. W 8/17/1997 MIN SALARY MAX_SALARY 40000 30000 6000 16000 9000 20000 12000 8500 5000 20000 15000 3000 8200 4200 10000 6000 5500 2000 4000 9000 4000 MK REP Magdalen Centre. The Oxford Science Park 2014 Jabberwocky Rd 2011 Interiors Blvd 2004 Charade Rd 10000 15000 9000 POSTAL CODE ON M5S 1X8 OX9 978 26192 99236 98199 6000 DEPARTMENT TABLE DPT NAME MGR ID Administration 200 201 124 103 DPT ID 10 20 50 60 80 90 110 190 CITY Toronto Marketing Shipping Figure 1: EMPLOYEE database - 13- 201 Oxford Southlake South San Francisco Seattle IT Sales Executive Accounting Contracting 149 100 205 STATE PROVINCE Ontario Oxford Texas California Washington LOC ID 1700 1800 1500 1400 2500 1700 1700 1700 COUNTRY CANADA UNITED KINGDOM UNITED STATES UNITED STATES UNITED STATES SULIT/CONFIDENTIAL
EMPLOYEE TABLE EMP ID F NAME 100 Steven 101 Neena 102 Lex 200 Jennifer 205 Shelley 206 William 149 174 176 178 124 141 142 143 144 103 Alexander 104 Bruce 107 Diana 201 Michael 202 Pat Eleni Ellen Jonathon Kimberely Kevin Trenna Curtis Randall Peter L_NAME King Kochhar De Haan Whalen Higgins Gietz Zlotkey Abel Taylor Grant Mourgos Rajs Davies Matos Vargas Hunold Ernst Lorentz Hartstein Fay HIRE DATE 06/17/1987 09/21/1989 01/13/1993 09/17/1987 06/07/1994 06/07/1994 01/29/2000 05/11/1996 03/24/1998 05/24/1999 11/16/1999 10/17/1995 01/29/1997 03/15/1998 07/09/1998 01/03/1990 05/21/1991 02/07/1999 02/17/1996 08/17/1997 JOB ID AD PRES AD VP AD VP AD_ASST AC MGR AC ACCOUNT SA MAN SA_REP SA_REP SA REP ST MAN ST CLERK ST CLERK ST CLERK ST CLERK IT PROG IT PROG IT PROG MK MAN MK REP SALARY COM PCT MGR ID 24000 17000 17000 4400 12000 8300 10500 11000 8600 7000 5800 3500 3100 2600 2500 9000 6000 4200 13000 6000 0.2 0.3 0.2 0.15 100 100 101 101 205 100 149 149 149 100 124 124 124 124 102 103 103 100 201 DPT ID 88888888 90 90 90 10 110 110 80 80 50 50 50 50 50 60 60 60 20 20 DEPARTMENT TABLE DPT ID DPT NAME MGR ID