Question: Business rules Normalized ERD using Crows Foot notation. This must be created in Visio and also saved as PDF. The printout must be readable. Use

Business rules Normalized ERD using Crows Foot
  1. Business rules
  2. Normalized ERD using Crows Foot notation. This must be created in Visio and also saved as PDF. The printout must be readable. Use appropriate fonts & size and work with the placement and spacing of the entities.
  3. Simplified data dictionary: Name & Normal Form of each table, followed by a 2-column table listing the attributes in the first column and a brief description (if necessary) in the second column. Include justification if the table is not 3NF. Also indicate PK and FKs and describe derived attributes and why they are needed.
  4. Notes explaining design decisions and assumptions.
HR department EMPLID Marketing departu EMPID Employees EMP NE Empontress El department Loperation departon 2 EY_ID Managment department Em 1 hairt Payroll Informats relation to Employer _IT) Inver CHELI ord-20 Acconting deposment) Emp-ID Supplers Begant. Id produt_id Orders CIRCHID Products distraction Shipment Sales rep Timersery Returns Clients HR department EMPLID Marketing departu EMPID Employees EMP NE Empontress El department Loperation departon 2 EY_ID Managment department Em 1 hairt Payroll Informats relation to Employer _IT) Inver CHELI ord-20 Acconting deposment) Emp-ID Supplers Begant. Id produt_id Orders CIRCHID Products distraction Shipment Sales rep Timersery Returns Clients

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!