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:
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).
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here