Table_rating table menu table_menu_type table_user menu_type_ID rating ID menu ID user_ID placed • type_name • description # menu_ID • remarks • data_recorded: date # customer ID • menu_name # price...


Table_rating<br>table menu<br>table_menu_type<br>table_user<br>menu_type_ID<br>rating ID<br>menu ID<br>user_ID<br>placed<br>• type_name<br>• description<br># menu_ID<br>• remarks<br>• data_recorded: date<br># customer ID<br>• menu_name<br># price<br>#menu_type ID<br>• menu image<br>ingredients<br>#menu_status<br>• full_name<br>• contact<br>• email address<br>* username<br>• password<br>assigned<br>represent<br>table_payment<br>payment_ID<br>4 order ID<br>C# amount<br>paid_by<br>-payment_date<br># processed_by<br>| assigned<br>to<br>table_customer<br>customer_ID<br>• Customer_first_name<br>• customer_last_name<br>• customer_middle_name<br>• customer_email<br>• customer_phone_number<br>• customer_landline<br>• profile_image<br>• customer_usemame<br>• customer password<br>table_order_details<br>I Jorder_details_ID<br>include<br>I l order_ID<br># menu_ID<br># amount<br># no of serving<br># total_amount<br>table_site_info<br># account_status<br>site_info_ID<br>L<br>• site_name<br>• description<br>• contact_info<br>* address<br>• last_update<br>Huser_ID<br>table_order<br>part of<br>placed<br>by<br># customer_ID<br>-order_date<br>#total_amount<br>Worder_status<br>#processed_by<br>pays<br>orders<br>Customers<br>PK customer_ID<br>- customer zip_code_prefix<br>- customer city<br>- customer state<br>PK order_ID<br>- customer ID<br>- order_status<br>- order purchase timestamp DATETIME<br>- order approved at DATETIME<br>- order_delivered_carrier_date DATETIME<br>- order_delivered_customer_date DATETIME<br>order estimated_delivery_date DATETIME<br>makes<br>order_items<br>orders_order_ID<br>PK order_ID<br>- product_ID<br>- shipping limit date DATETIME<br>- price DECIMAL<br>freight_value DECIMAL<br>contains<br>order_items_order_ID<br>payment order ID<br>products product_ID<br>раyment<br>contains<br>PK order_ID<br>payment_sequential<br>-раyment_type<br>- payment_installments<br>payment_value DECIMAL<br>products<br>PK product_ID<br>- product_category_name<br>- product_name_length<br>- product_description_length<br>- product photo_quantity<br>Given that information ERD and EERD. draw the dependency<br>diagram INF,2NF and 3NF. Make sure that you label the<br>transitive and/or partial dependencies.<br>

Extracted text: Table_rating table menu table_menu_type table_user menu_type_ID rating ID menu ID user_ID placed • type_name • description # menu_ID • remarks • data_recorded: date # customer ID • menu_name # price #menu_type ID • menu image ingredients #menu_status • full_name • contact • email address * username • password assigned represent table_payment payment_ID 4 order ID C# amount paid_by -payment_date # processed_by | assigned to table_customer customer_ID • Customer_first_name • customer_last_name • customer_middle_name • customer_email • customer_phone_number • customer_landline • profile_image • customer_usemame • customer password table_order_details I Jorder_details_ID include I l order_ID # menu_ID # amount # no of serving # total_amount table_site_info # account_status site_info_ID L • site_name • description • contact_info * address • last_update Huser_ID table_order part of placed by # customer_ID -order_date #total_amount Worder_status #processed_by pays orders Customers PK customer_ID - customer zip_code_prefix - customer city - customer state PK order_ID - customer ID - order_status - order purchase timestamp DATETIME - order approved at DATETIME - order_delivered_carrier_date DATETIME - order_delivered_customer_date DATETIME order estimated_delivery_date DATETIME makes order_items orders_order_ID PK order_ID - product_ID - shipping limit date DATETIME - price DECIMAL freight_value DECIMAL contains order_items_order_ID payment order ID products product_ID раyment contains PK order_ID payment_sequential -раyment_type - payment_installments payment_value DECIMAL products PK product_ID - product_category_name - product_name_length - product_description_length - product photo_quantity Given that information ERD and EERD. draw the dependency diagram INF,2NF and 3NF. Make sure that you label the transitive and/or partial dependencies.
Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here