Question: Q: Normalize it to the 5th Normal Form? if any table is not normalized, normalize it ? ADMIN_USERS ADMIN_USERNAME ISNO ADMIN PASSWORD MAIN CATEGORIES SUB
Q: Normalize it to the 5th Normal Form? if any table is not normalized, normalize it ?
ADMIN_USERS ADMIN_USERNAME ISNO ADMIN PASSWORD MAIN CATEGORIES SUB CATEGORIES SNO MAIN CATEGORY ID MAIN CATEGORY_NAME MAIN CATEGORY_STATUS SNO SUB CATEGORY.ID SUB TO MAIN CATEGORY SUB_CATEGORY_NAME SUB CATEGORY STATUS PRODUCTS PRODUCT IMAGE SNO PRODUCT ID PRODUCT_MAIN_CATEGORY PRODUCT SUB CATEGORY PRODUCT NAME PRODUCT PRICE PRODUCT DETAILS PRODUCT DESCREPTION PRODUCT FEATURES PRODUCT STATUS PRODUCT TIMESTAMP PRODCUT_ORDER HEADING_BANNER SMALL SECOND HEADING SNO BANNER ID LARGE_FIRST_HEADING BANNER IMAGE BANNER TIMESTAMP BANNER STATUS PRIMARY_KEY USER REGISTER SNO USER FULL NAME USER GMAIL PHONE NUMBER USER PASSWORD REGISTERED_TIME FOREIGN KEY CART CART NO PRODUCT_ID_FOR_CART PRODUCT_REGISTERD_BY_USERGMAIL PRODUCT QUANTITY PRODUCT TO CART DATE USER_ORDER SNO ORDER 10 PRODUCT ID USER_GAMIL USER ADDRESS USER CNIC USER PHONE NUMBER QUANTITY ORDER STATUS TOTAL_PRICE ORDER DATE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
