# data[].attributes.body
Today we have completed the report and video presentation. This is the discussion link used in every meeting and thank you the professor for suggestions.
https://web.microsoftstream.com/video/7f2f42e9-7c48-481e-866f-f312b1a381e7/?autoplay=true&app=microsoftteams&showinfo=false
https://web.microsoftstream.com/video/79adf748-5e1d-4ab7-99b8-d134c033f0a3/?autoplay=true&app=microsoftteams&showinfo=false
https://web.microsoftstream.com/video/a436f1f7-f950-4be9-b279-a9208a0a7914/?autoplay=true&app=microsoftteams&showinfo=false

# data[].attributes.body
Phairose Timasane 5931209249
Kawisara Thuatong  6031209009
Piyathida Srithong  6031209080
Methawadi  Lirakhon 6031209099
Wilasinee manochomphu 6031209106
Siriluk Jidnareang 6031209110

# data[].attributes.body
We have  a brain storming about the project that we’are up to
by re skimming  the lesson again and find  the solution method of “Normalization”  . Our work is in editing step of normalization but we are not done about 3NF diagram so we will upload the sheet . Now we allocate works into 3group
1.Phairose Timasane and Kawisara Thuatong are responded about excel diagram and Normalization making
2.Piyathida Srithong and Siriluk Jidnaraeng are responded about find the lesson of Normalization and checking the right information from excel
3.Methawadi Lirakhon and Wilasinee Manochomphu was responded about the report  of how and method of normalization
Now , we will keep updating the work group progressing by following day that lecturer mentioned in Google Classroom including the spreadsheet

# data[].attributes.body
We have  a brain storming about the project that we’are up to
by re skimming  the lesson again and find  the solution method of “Normalization”  . Our work is in editing step of normalization but we are not done about 3NF diagram so we will upload the sheet . Now we allocate works into 3group
1.Phairose Timasane and Kawisara Thuatong are responded about excel diagram and Normalization making
2.Piyathida Srithong and Siriluk Jidnaraeng are responded about find the lesson of Normalization and checking the right information from excel
3.Methawadi Lirakhon and Wilasinee Manochomphu was responded about the report  of how and method of normalization
Now , we will keep updating the work group progressing by following day that lecturer mentioned in Google Classroom including the spreadsheet

# data[].attributes.body
Update our work after discussing about the step of normalization.
We have to done 1NF-5NF already and will done SQL today.
And next we will going to do the report and video presentation.
We allocate the work into 3 groups.
1.Phairose Timasane and Kawisara Thuatong are checking the right information about 1NF-5NF and clean the excel information before export to phpMyAdmin
2.Siriluk Jidnaraeng and Methawadi Lirakhon are find the method to do the phpMyAdmin and
Import the data.
3.Piyathida Srithong and Wilasinee Manochomphu are do the report  to answer chapter2

# data[].attributes.body
Can you comment if it's right or wrong? on relationship diagram and Normalization, if it already corrects we can move another part.
Please let me know.

# data[].attributes.body
if there are something wrong, please let us know for correcting it thanks you in advance .

# data[].attributes.headline
Your diagram breaks important Normalization rules. 

# data[].attributes.subject
Your diagram breaks important Normalization rules. 

# data[].attributes.body
Example,
Department table: why there is a cost, style, color etc in Departments table. They should be related to SKU
SKU: table: why you have date , units sales etc.. those should be related to Sales data?
Tables are not normalized!
My advice is to go back to slides "Database Modeling" page 39 and learn the Case called Introduction to Transactions. The video is provided as well. This case is very similar to your project. Learn how to split the big table based on the concepts and create entities

# data[].attributes.body
Can you recommend on relationship diagram and Normalization, if it already corrects we can move another part?

# data[].attributes.headline
Good! What about the relationship diagram? Aj

# data[].attributes.subject
Good! What about the relationship diagram? Aj

# data[].attributes.body
5 normalization

# data[].attributes.body
Today we have a meeting to explain and understand about normalization ( 4NF 5NF) continue from last form and discuss more in the next section, explaining diagrams and continuing to explain business rules tomorrow.

# data[].attributes.headline
You don't need customer ID. There is no data given about any customer. However, there is a data about sales. What exactly is confusing?

# data[].attributes.subject
You don't need customer ID. There is no data given about any customer. However, there is a data about sales. What exactly is confusing?

# data[].attributes.body
Update our work After discussing about the step of normalization.
We have done 1NF-5NF. Please help to check and we going start to continuing to explain amd do business rules in  tomorrow.

We allocate the work into 3groups.
1.Phairose Timasane  Kawisara Thuatong and are responded about excel diagram and Normalization making of 1NF-5NF and checking the right information from excel and
2. Siriluk Jidnaraeng and Methawadi Lirakhon  are responded about find the lesson relationships in a form of diagram and business rules in those relationships.
3. Piyathida Srithong and Wilasinee Manochomphu was responded about the report  of Outcome: Report Chapter 1 explaining
* Introduction and problem statement

# data[].attributes.headline
Professor  can you answer my question ?   

# data[].attributes.subject
Professor  can you answer my question ?   

# data[].attributes.body
As we learned from online lessons ,they created exceptional table between Customer ID and Department so I have a question for you . Can we add the customer id and department   table in order to decrease confusing when we identified another information and easier to find the information.

# data[].attributes.body
Today we had a meeting about the assignment of 6members for reviewing about normalization technique again in order to make it right information and we will allocate responsibility to each of members too

# data[].attributes.body
Now, I created assignment til 3 normalization form , could you guys do it from me about 4 and 5 Normalization Form please.

# data[].attributes.headline
Keep it up! I am waiting for the excellent 

# data[].attributes.subject
Keep it up! I am waiting for the excellent 

# data[].attributes.body
week 1
Information will be corrected later On Thursday 26 March 2020.

# data[].attributes.body
We have  a brain storming about the project that we’are up to
by re skimming  the lesson again and find  the solution method of “Normalization”  . Our work is in editing step of normalization but we are not done about 3NF diagram so we will upload the sheet . Now we allocate works into 3group
1.Phairose Timasane and Kawisara Thuatong are responded about excel diagram and Normalization making
2.Piyathida Srithong and Siriluk Jidnaraeng are responded about find the lesson of Normalization and checking the right information from excel
3.Methawadi Lirakhon and Wilasinee Manochomphu was responded about the report  of how and method of normalization
Now , we will keep updating the work group progressing by following day that lecturer mentioned in Google Classroom including the spreadsheet