TASKS: 1. Transform the EER model (Appendix A) to Relational tables, making sure you show all the steps. The final set of tables should contain necessary information such as table names, attribute names, primary keys (underlined) and foreign keys (in italics).

2. a) Implement the tables in the ORACLE 12c Relational DBMS. When creating tables make sure you choose appropriate data types for the attributes and specify any nullot null or other constraints whenever applicable. b) Write one insert statement for each of your tables using realistic data. Make sure you take into consideration all the necessary constraints. Note: some data value will be checked to follow the information provided in Assignment 1, Part 1.

3. Apply Normalization Techniques (Bottom-Up approach) on Appendices A, B, C and D from Assignment 1 Part 1 to come up with BCNF tables.

4. Discuss the differences between the result of the top-down approach from question 1 above and the result of the bottom up approach from question 3 above. Provide some analysis on why they are similar or different for this particular problem.

look into this for assignement part 1 questions - 2b and 3

please help me its very urgent

will give five stars for the answer thank you

1 (0, N) N (1, 1 EndDate 1 (0, N Suburb N (1, N) M (1, M Corporate ndividual 1 (0, N N (1, 1 Casua Contract N (1,1 Has 1 (0, 1) 1 (0, N 1 1, 1) N (1, 1 Review nVOICe Review Text N (0, N) M (0, M Equipment Client Creates M (0, M) N (0, N Job N (1, 1) N (1, 1) 1 (0, N Business M (1, M 1 (0, N) N (0, N ndustry N (0, N 1 (1, N Freelancer Union EliteMember M (0, M Electrical Mechanical SemDateTime Career N (5, N) Seminar 1 (0, N) N (1, 1 EndDate 1 (0, N Suburb N (1, N) M (1, M Corporate ndividual 1 (0, N N (1, 1 Casua Contract N (1,1 Has 1 (0, 1) 1 (0, N 1 1, 1) N (1, 1 Review nVOICe Review Text N (0, N) M (0, M Equipment Client Creates M (0, M) N (0, N Job N (1, 1) N (1, 1) 1 (0, N Business M (1, M 1 (0, N) N (0, N ndustry N (0, N 1 (1, N Freelancer Union EliteMember M (0, M Electrical Mechanical SemDateTime Career N (5, N) Seminar