ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
WeekMondayTuesdayWednesdayThursdayColor Legend
2
19/7/20209/8/20209/9/20209/10/2020Project Work
3
Course logistics, Chapter 1 1-1-1.3 Connolly & Begg File-based approach vs. the database approach to storing data, User roles Connolly and Begg Chapter 1.4, Advantages and Disadvantages to DB Chapter 1.6Exam
4
29/14/20209/15/20209/16/20209/17/2020Project Work
5
ANSI-SPARC model 2.1 Database programming languages 2.2.1 & 2.2.2. Data model 2.3, functions of a DBMS 2.4; DBMS architectures DBMS architectures Chapter 3.1, Cloud computing 3.5 Connolly and Begg;Exam
6
39/21/20209/22/20209/23/20209/24/2020Homework
7
Relational model, integrity constraints and views Chapter 4 (Sections 4.2, 4.3, 4.4) Connolly and Begg;Homework 1 due (short essays on Ch. 1-4)My SQL should be installed on laptops, Murach Appendix A , Installation instructions on Resources page of website. My SQL workbench SQL CREATE TABLE, USEHoliday
8
49/28/20209/29/20209/30/202010/1/2020
9
SQL SELECT simple queries, aggrgation, KEYWORDS BETWEEN, IN, ORDER BY, LIMIT, GROUP BYHomework 2 due (create a MySQL DB)Exam 1 due (Database background and architecture Ch 1,2,3,4); SQL SELECT IN clause (INTERSECTION), NOT IN (set difference) and UNION (Murach Chapter 4), JOIN
10
510/5/202010/6/202010/7/202010/8/2020
11
correlated queries, subqueries in FROM and SELECT list; Murach Ch. 7, complex and nested queries (Murach CH. 7) , MySQL practice work correlated and uncorrelated nested queries, More DDL and DML commandsHomework 3 due (SQL SELECT)Complete nested queries, Relational AlgebraComplete Logical database design (Connolly & Begg Chapter 17,Cover physical database design 18 ); SQL join and set operations, nested queries. Project proposal due
12
610/12/202010/13/202010/14/202010/15/2020
13
Columbus day holidayContinue with Relational algebra Examples converting between RA and SQL,
14
710/19/202010/20/202010/21/202010/22/2020
15
Complete Division RA Modeling the real world, Connolly and Begg Chapter 12, UML notationhomework 4 due (importing data and SQL SELECT)structural constraints; EER (Chapter 13)
16
810/26/202010/27/202010/28/202010/29/2020
17
Enhanced entity relationship
Exam 2 (SQL and Relational Algebra)
Conceptual design (UML) to logical design ( Connolly & Begg Ch. 17) Logical design to Physical design
18
911/2/202011/3/202011/4/202011/5/2020
19
Normal form, functional dependencies (Connolly & Begg Chapter 14.5-14.9, Murach Chapter 10) ; Homework 5 due (database modeling)Start of Topic 4 SQL procedures, functions, triggers,events, prepared statements (Murach Ch. 16),
20
1011/9/202011/10/202011/11/202011/12/2020
21
Review for exam 3; triggers,events, prepared statements (Murach Ch. 16), Project proposal dueConnecting to MySQL from an application, Embedded SQL Murach Chapter 1, Connolly and Begg Chapter 29ACID; Concurrency problems, and Serializability Connolly & Begg Chapter 22.1, 22.2, Serializable schedules, Algorithms to support concurreny, precedence graph
22
1111/16/202011/17/202011/18/202011/19/2020
23
Locks and s ; Chapter 22Homework 6 due (SQL user defined functions and procedures )Exam 3 (conceptual design to SQL CREATE)Deadlock algorithm Recoverability Chapter 22; Isolation levels
24
1211/23/202011/24/202011/25/202011/26/2020
25
Intention locks, Timestamp alogrithm Connolly and Begg Ch 22 Homework 7 due (client application),Thanksgiving
26
1311/30/202012/1/202012/2/202012/3/202012/4/2020
27
Recoverability
The NoSQL movement, CAP theorm and other data models;
Exam 4 (Transactions and NoSQL)
28
1412/7/202012/8/202012/9/202012/10/202012/11/2020
29
Project workproject due
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100