1z0-882 Exam Dumps | You have been tasked to create a database that will store a list of all managers and the employees who

<< Prev Question Next Question >>

Question 37/61

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?

A. CREATE TABLE 'manager' (
'manager' varchar (50) DEFAULT NULL,
'employee_list'varchar (150) DEFAULT NULL,
)

B. CREATE TABLE 'managers' (
"id' int(11) NOT NULL AUTO_INCREMENT,
'manager' varchar (50) DEFAULT NULL ,
PRIMARY KEY ('id')
)
CREATE TABLE "employees' (
'id' int(11) NOT NULL AUTO _INCREMENT,
'manager_id' int(11) DEFAULT NULL,
'employee varchar (25) DEFAULT NULL,
PRIMARY KEY ('id')
)

C. CREATE TABLE 'manager'
'manager' varchar (50) DEFAULT NULL,
'employee2' varchar (50) DEFAULT NULL,
'employee' varchar (50) DEFAULT NULL,
UNIQUE ( 'manager ', 'employee1', 'employee2, 'employee3')
)

D. CREATE TABLE 'message' (
'id' int(11) NOT NULL AUTO_INCREMENT,
'manager' varchar(50) DEFAULT NULL,
PRIMARY KEY ("id')
)
CREATE TABLE 'employees' (
'id int (11) NOT NULL AUTO _INCREMENT,
'employees' varchar(25) DEFAULT NULL,
)

Question 37/61

LEAVE A REPLY

Download PDF File