Table – 1 Groceries Dataset Transaction ID Items T1 Milk, Bread, Butter, Eggs, Sugar, Tea, Coffee, Biscuit, Cheese, Yogurt T2 Bread, Butter, Jam, Eggs, Milk, Sugar, Biscuit, Tea, Coffee, Yogurt T3 Bread, Butter, Cheese, Jam, Eggs, Milk, Yogurt, Biscuit, Tea, Coffee T4 Milk, Bread, Cheese, Butter, Sugar, Eggs, Coffee, Tea, Yogurt, Biscuit T5 Butter, Bread, Jam, Milk, Sugar, Coffee, Biscuit, Eggs, Yogurt, Tea T6 Milk, Butter, Cheese, Sugar, Biscuit, Yogurt, Eggs, Bread, Coffee, Tea T7 Bread, Jam, Milk, Butter, Eggs, Biscuit, Coffee, Yogurt, Sugar, Tea T8 Butter, Cheese, Bread, Eggs, Milk, Biscuit, Sugar, Tea, Coffee, Yogurt T9 Bread, Butter, Jam, Cheese, Yogurt, Biscuit, Coffee, Tea, Eggs, Milk T10 Milk, Bread, Butter...
DBMS Practice Experiment Design 7 tables as per the given requirements, with at least 10 rows per table, including primary keys and foreign keys wherever appropriate. Your tables should be as follows (attributes are suggested but you may modify them if needed): Table: Department Attribute Data Type Description dept_id (PK) INT Unique ID for department dept_name VARCHAR(50) Name of the department hod_name VARCHAR(50) Head of department name office_location VARCHAR(50) Location of the department office contact_email VARCHAR(50) Department email contact_phone VARCHAR(15) ...