| ITMG 320 | ||||
| week eleven 6 april to 8 april | ||||
| Assignment Due: | ||||
| Session Materials | ||||
| https://waltonlab.uark.edu/ remote into uark epic (or horizon vm client) | ||||
| FACT | ||||
| Exam REVIEW SOLN AND SCREEN SHOTS | ||||
| Additional note on Normalization Dependency | ||||
| TEST | ||||
| Learning Objectives | ||||
| To demonstrate proficiency in database class concepts | ||||
| database concepts | normalization | 1nf, 2nf, 3nf...... | ||
| ERD | ||||
| SQL syntax and queries | ||||
| CREATE TABLE (in SQL) | ||||
| INSERT (in SQL) | ||||
| SELECT query (in SQL) | ||||
| SELECT FROM WHERE query (in SQL) | ||||
| LOGICAL OPERATORS (in SQL) | ||||
| IN EXACT MATCH (in SQL) | ||||
| IN AND NULL (in SQL) | ||||
| SORT CALCULATE (in SQL) | ||||
| TWO TABLES OR MORE (in SQL) | ||||