HOME
 
SYLLABUS
 
SCHEDULE
 
LECTURE SLIDES
 
LECTURE FILES
 
LECTURE VIDS
 
TIMELINES
 
ASSIGNMENTS
 
GRADE DATABASE
 
RESOURCES
 
LINK TO TEXTBOOK MINDTAP
 
LINK TO UARK EPIC

 

Tentative Schedule for MSBA 504 Fall 2020
note subject to change
 

 

Date TOPIC READINGS ASSIGNMENT
tue 25 aug Intro to Class/ Database/Relational Model Appendix B, Chapter 2 assignment one 
thr 27 aug into to structured query language Chapter 2     files Assignment Two
tue 1 sept Wildcards, sorting, aggregate functions Chapter 2,3  
thr 3 sept Wildcards, sorting, aggregate functions Chapter 2,3  
tue 8 sept Subqueries Chapter 3 assignment three
thr 10 sept  Unions, intersection,  JOINs   1912 H  QUIZ Chapter 3 assignment four
tue 15 sept EXAM ONE DB SQL    
thr 17 sept Update, alter tables Chapter 3,4 assignment five
tue 22 sept Sequence, index, views, triggers Chapter 3,4 assignment six
thr 24 sept Working with strings, dates Chapter 5,6 assignment seven
tue 29 sept Constraints, normalization Chapter 5,6  
thr 1 oct Database and system design Chapter 5,6  
FRI 2 oct project/presentation/sql/python/odbbc Chapter 5,6  
tue 6 oct EXAM TWO

create 2.1.1 new

insert 2.1.1 new

insert2.2.2 if prev

 		 sportsdb