2023 Weekly tasks or assignments Individual or Group Projects will be due by Monday and late submissions will be | Assignment Collections

Weekly tasks or assignments (Individual or Group Projects) will be 
due  by  Monday and late submissions will be assigned a late penalty in 
accordance with the late penalty policy found in the syllabus. NOTE: All
 submission posting times are based on midnight Central Time. Using the 
DBMS you chose in the previous Discussion Board assignment, download and
 install that software to prepare for the Database and Data Model to be 
created. Once the software is running and the database is available, 
complete the following: Create the physical data model for the logical 
data model that you submitted in IP3. This should include all of the 
data definition language SQL. Your submission should include all DDL 
needed to: Create the tables Create the primary keys Create the foreign 
keys Add DML statements to: Add data of 1 customer who buys from the 
company Provide the DML to add 1 employee who interacts with customers 
Give DML to change data of the employee, giving the commission a 25% 
increase Give DML to delete the customer and employee data Write 3 
SELECT statements: To select the customer details To select the 
employees details To show which employee services which customer Add the
 SQL for the DDL, DML, and SELECT statements to the project template 
section titled "Advanced SQL." Name the document CS352_<First and 
Last Name>_IP4.doc. Submit your Word document and make sure that it 
contains the following: Screenshot of the ERD, logical data model from 
previous assignments. The DDL to create the tables, including the table 
definition and the primary and foreign key definitions. SQL to add data 
to the tables Add data of 1 customer who buys from the company Provide 
the DML to add 1 employee who interacts with customers Give DML to 
change data of the employee, giving the commission a 25% increase Give 
DML to delete the customer and employee data Write 3 SELECT statements: 
To select the customer details To select the employees details To show 
which employee services which customer