Given the business rule "An employee may have many degrees." Suppose that an employee has the following degrees. BA, BS, MBA, etc. These degrees could be stored in a single string as a multivalued...


Given the business rule "An employee may have many degrees." Suppose that an employee has the following degrees. BA, BS, MBA, etc. These degrees could be stored in a single string as a multivalued attribute name EMP_DEGREE in an EMPLOYEE table such as the one shown below:






























EMP_NUMEMP_LNAMEEMP_DEGREE
123CarterBA, BS, MBA
124SmithBBA, MBA
125JonesAS
126DoeBS, MS, PhD.

This design is flawed, so correct it by creating additional table(s) and attributes(s) and show the relationships between them. Show all the data above in your table(s). Add additional data if new attributes were added. Show primary and foreign keys in your table(s).



Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here