Choose Oracle data types for the attributes in the normalized relations that you created in Problem and Exercise 19 in Chapter 4.

Data from Exercise 19.

Figure 4-35 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints. In addition, verify that the resulting relations are in 3NF.

EMPLOYEE Emp ID Emp Name Emp Type Belongs To REGION COUNTRY Country ID Country Name Region ID Region Name COUNTRY DEVELOPMENT DEVELOPER H MANAGER MANAGER H 0 Developer Type Manages Supervises Supervises ASSIGNMENT Score Hours Rate MEMBERSHIP Joined Left PROJECT TEAM Proj ID Proj Start Date Proj End Date Leads Team ID H Team Name Is Responsible For Team Start Date H SENIOR WIZARD Is Deputy Team End Date JUNIOR Mentors