Question: Also, Create an Access database that reflects your ERD. The Access database should have the tables and attributes as shown above. You should create appropriate

 Also, Create an Access database that reflects your ERD. The Access

Also, Create an Access database that reflects your ERD. The Access database should have the tables and attributes as shown above. You should create appropriate relationships between the tables. It is not required to add the actual data to the tables.

C) A company wants to track education and professional certifications for their employees in a relational database. Create an ERD (Crows Foot notation) that can help track this information. The following image can provide you information about the tables and the data stored in them. Wirite the business rules for this database as necessary: (40 points) Table name: EMPLOYEE Table name: EDUCATION EDU DESCRPTION EMP NUM EMP LNAME EDU CODE CDP CNP CPA DR HS Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree 216 Romero 217 Randall 218 Aarden Table name: EMP EDUC EMP NUM EDU CODE EE YEAR M2 215 HS 215 JC 216 B4 216 COP 216 CNP 216 HS 217 HS 217 JC 218 84 218 CDP 218 CNP 218 HS 218 M2 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 C) A company wants to track education and professional certifications for their employees in a relational database. Create an ERD (Crows Foot notation) that can help track this information. The following image can provide you information about the tables and the data stored in them. Wirite the business rules for this database as necessary: (40 points) Table name: EMPLOYEE Table name: EDUCATION EDU DESCRPTION EMP NUM EMP LNAME EDU CODE CDP CNP CPA DR HS Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree 216 Romero 217 Randall 218 Aarden Table name: EMP EDUC EMP NUM EDU CODE EE YEAR M2 215 HS 215 JC 216 B4 216 COP 216 CNP 216 HS 217 HS 217 JC 218 84 218 CDP 218 CNP 218 HS 218 M2 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995

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 Databases Questions!