Exam 1z0-882 topic 1 question 68 discussion

Actual exam question from Oracle's 1z0-882

Question #: 68
Topic #: 1

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, employee2 varchar (50) DEFAULT NULL, employee varchar (50) DEFAULT NULL, UNIQUE ( manager , employee1, employee2, employee3) )
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, employee_listvarchar (150) DEFAULT NULL, )
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,

Show Suggested Answer

Suggested Answer: A 🗳️

by chehin at May 14, 2022, 4:51 p.m.

Comments

Submit Cancel

chehin

3 years ago

For A : "manager" is not valid at this posicion...

upvoted 1 times

...