Transform the EER model (Appendix A) to Relational tables, making sure you show all the steps
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

Transform the EER model (Appendix A) to Relational tables, making sure you show all the steps


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 12G 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.

3. Normalize the user views provided in Appendices A and B of assignment 1 part 1 specification. Clearly show individual steps of UNF, INF, 2NF and 3NF. List the final tables. Discuss the differences between the result of the top-down approach from question 1 above and the result of the bottom up approach (Normalization result). Provide some analysis on why they are similar or different for this particular problem.

Hint
Management "EER or the enhanced entity–relationship model, also called as extended entity–relationship model in computer science is a high-level or conceptual data model incorporating extensions to the original ER (entity–relationship) model, that is used in the design of databases i.e. it is a high-level data model that incorporates the extensions to the original ER modelIt was developed to ...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.