You have been tasked to create a database that will store a list of all managers and the employees who report directly to them. The following is stipulated:

No manage is managing more than three people.

No employee can work for more than one manage.

Which of these designs represents a normalized schema that meets the project requirements?

Question

You have been tasked to create a database that will store a list of all managers and the employees who report directly to them. The following is stipulated:

No manage is managing more than three people.
No employee can work for more than one manage.

Which of these designs represents a normalized schema that meets the project requirements?

Accepted Answer

A. CREATE TABLE `manager'

Answer

B. CREATE TABLE `managers' (

Answer

C. CREATE TABLE `manager' (

Answer

D. CREATE TABLE `message' (

You have been tasked to create a database that will store a list of all managers and the employees who report directly to them. The following is stipulated: - No manage is managing more than three…

Question

Options

How the community answered

Community Discussion