Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 2). You have used Reverse Engineering with Erwin Data Modeler by using IDEFIX (Erwin) notations after installing popular Wordpress Platform which is a blogging

image text in transcribed

Question 2). You have used Reverse Engineering with Erwin Data Modeler by using IDEFIX (Erwin) notations after installing popular Wordpress Platform which is a blogging software. You saw that it was NOT RELATIONAL. Your task in IT department is to make the data model relational. Write down the SQL DDL Statements to make data model relational one. (40 Points) wp comments wp_posts ID wp_commentmeta meta_id wp_term_taxonomy term_taxonomy_id comment_id meta_key meta_value term_id taxonomy description parent count wp_links link_id comment_ID comment_post_ID comment author comment_author_email comment_author_url comment_author_IP comment_date comment_date_gmt comment_content comment_karma comment_approved comment_agent comment_type comment_parent user_id wp_terms term_id post author posldate post_date_gmt post content post title poslexcerpt post_status comment status ping status posl_password poslname to_ping pinged post_modified post_modified_gmt post_content_filtered post parent guid menu_order post_type post_mime_type option_name comment_count name slug term_group wp_options option_id option_value autoload link_url link_name link_image link_target link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss wp_users ID wp_usermeta umeta_id user_id meta_key meta_value wp_postmela meta_id user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name wp_termmela meta_id post_id wp_term_relationships object_id term_taxonomy_id term_order meta_key meta_value term_id meta_key meta_value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Mannino Michael

5th Edition

0983332401, 978-0983332404

More Books

Students also viewed these Databases questions

Question

What is the Definition for Third Normal Form?

Answered: 1 week ago

Question

Provide two examples of a One-To-Many relationship.

Answered: 1 week ago