Question: Define each and every relation in the below ERD diagram in the below scheme: customer customer_id INT customer_address_id INT customername VARCHAR(45) customer_pass VARCHAR(45) customer_email VARCHAR(45)

Define each and every relation in the below ERD diagram in the below scheme:Define each and every relation in the below ERD diagram in the

customer customer_id INT customer_address_id INT customername VARCHAR(45) customer_pass VARCHAR(45) customer_email VARCHAR(45) HE customer_phn VARCHAR(45) date_bec_cust DATE Indexes addresses address_id INT city VARCHAR(45) Governrate/State VARCHAR(45) country VARCHAR(45) Postal Code VARCHAR(45) Zip Code VARCHAR(45) Indexes salaried_employee Salary_EMPLOYE_ID INT ANNUAL SALARY FLOAT EMPLOYEE ID INT Indexes invoice INV_ID INT CUS_NAME VARCHAR(45) PRODUCT_NAME INT PURCHASE_DA TE DATETIME PRICE DOUBLE PAYMENT_METHOD VARCHAR(60) ( TOTAL DOUBLE EMPLOYEE NAME VARCHAR(45) Indexes PT > productcatagory ProductCatagory VARCHAR(150) Indexes > employees employee_id INT employee_address_id INT employee_name VARCHAR(45) > employee_suppervisor INT + employee_department VARCHAR(450 employee_pass VARCHAR(45) ( employee_email VARCHAR(100) () employee_phone VARCHAR(45) other_emp_details VARCHAR(1000) Indexes ---- H product PRODUCT_ID INT product_type VARCHAR(150) supplier_id INT prod_name VARCHAR(100) ( QuantityInStock INT prod_price DOUBLE prod_desc VARCHAR(100) prod_cond VARCHAR(100) Pay_Me_METH VARCHAR(60) Pro_Reternabilty VARCHAR(100) prod_SoldDate DATE prod_ReturDate DATE Diffrence_IN_Date INT other_details VARCHAR(100) Index inv_prod ? idiny_prod INT ProductID INT Inv_ID_b INT Indexes payment_meth PaymeMETH VARCHAR(60) Indexes 1 hourly_employee ID INT HOURLY_RATE FLOAT EMP ID INT Indexes department DEPARTMENT_ID INT DEPARTMENT_NAME VARCHAR(45) Indexes suppliers suppler_id INT suppler_add_id INT suppler name VARCHAR(45) contact_name VARCHAR(45) ) supplier_phn VARCHAR(45) suppler_email VARCHAR(45) 1 more Indexes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!