Customer_Profile(cust_id, first_name, last_name, gender, street, aptno, zipcode, dob);
Dept_Repository(dept_id, activity_type, activity_plan, activity_price);
Customer_Dept(cust_id, dept_id, cust_activity_type, cust_activity_plan, plan_join_date, plan_termination_date, trainer_id);
Accounts(cust_id, dept_id, cust_tot_cost);
Inventory(prod_id, dept_id, prod_name, prod_cost, prod_quant);
Customer_Login(cust_username, cust_id, cust_pwd);
Employees(emp_id, dept_id, employee_name, designation);
Below is the diagrammatical representation of the Schema:
No comments:
Post a Comment