CSE2DBF - Database Fundamentals

Assignment Task

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) Write create table statements to implement the tables in the ORACLE APEX. When creating tables make sure you choose appropriate data types for the attributes and specify any null/not 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.

This CSE2DBF - IT Computer Science Assignment Help has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.