EER Transformation and Table Creation - IT Computer Science Assignment Help

Assignment Task

Task

This assessment requires you to convert the ER/EER model into a relational data model and implement a relational database system.

Assessment criteria:

This assessment will measure your ability to:

• Transform the ER/EER model into relational tables.
• Transform the ER/EER model into relational tables. 
• Create and implement tables in the ORACLE Relational DBMS.
• Write insert statements for each of your tables using realistic data, considering all necessary constraints.

Tasks:

1. Transform the EER model (Appendix A later in this document) 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 (italicised).

2. a) Implement the tables in the ORACLE Relational DBMS. 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 IT Computer Science Assignment has been solved by our IT Computer Science Expert at My Uni Papers. 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. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.