Web design conference - Create the PROJECT_MANAGER table and add records: CREATE
Create the PROJECT_MANAGER table and add records: CREATE TABLE Project_Manager ( project VARCHAR2(32) NOT NULL, manager VARCHAR2(32) NOT NULL, PRIMARY KEY (project, manager) ); INSERT INTO Project_Manager VALUES( Analysis , Joe ); INSERT INTO Project_Manager VALUES( Analysis , Jim ); INSERT INTO Project_Manager VALUES( DW , Larry ); INSERT INTO Project_Manager VALUES( DW , Gemima ); INSERT INTO Project_Manager VALUES( HTML , Jackson ); COMMIT; Create the MANAGER_EMPLOYEE table and add records: CREATE TABLE Manager_Employee ( manager VARCHAR2(32) NOT NULL, employee VARCHAR2(32) NOT NULL, PRIMARY KEY (manager, employee) ); INSERT INTO Manager_Employee VALUES( Gemima , Columbia ); INSERT INTO Manager_Employee VALUES( Jackson , Columbia ); INSERT INTO Manager_Employee VALUES( Jackson , Riffraff ); INSERT INTO Manager_Employee VALUES( Jim , Magenta ); INSERT INTO Manager_Employee VALUES( Jim , Riffraff ); INSERT INTO Manager_Employee VALUES( Joe , Brad ); INSERT INTO Manager_Employee VALUES( Larry , Brad ); INSERT INTO Manager_Employee VALUES( Larry , Janet ); COMMIT; As previously stated, the one hard-and-fast rule with respect to 5NF is that the pre-5NF records must be identical to the 5NF divided up tables (as shown in Figure 4-44) when querying the database. In other words, the two queries must match in this case, records from one table must match records from the three joined tables. 120 Chapter 4
Please visit our professional web hosting services to find out about cheap and reliable webhost service that will surely answer all your demands.