Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started