Spring 2016 Schedule (ISQS 3348, Database Management Systems)

 

MWF 12-12:50p, BA025

--------------------------------------------------------------------------------------------------------------------------------------

Textbooks and Lecture Materials:

Database Concepts by David Kroenke and David Auer

 

Exercises & Assignments

 

Week

Date

Day

Contents

Readings & References

Labs/Assignments

Notes

0

22-Jan

F

Introduction

What’s a DB?

 

 

1

25-Jan

M

Getting Started

Chapter 1

Access 2013 #0

Access 2013 #1

Access 2013 #2

Access 2013 #3

Access 2013 #4

 

 

1

27-Jan

W

Getting Started

Chapter 1

Access 2013 #5

Access 2013 #6

Access 2013 #7

MySQL

SQL Server 2014

Set up working environment

 

1

29-Jan

F

The Relational Model

Chapter 2

Access 2013 #8

Access 2013 #9

Access 2013 #10

Assignment 1 (Downloadable here)

(1) pp53-54 (6e) / pp56-57 (7e), Exercise 1.30 to 1.32 (7e), or 1.31 to 1.33 (6e); 

(2) pp56-57 (6e) / p60 (7e), Garden Glory Project Questions.

Due: 2/3, Wednesday, before class meeting, either hardcopy or e-copy by email (sent to isqs3358@gmail.com).

 

2

1-Feb

M

The Relational Model

Chapter 2

Access 2013 #11

Access 2013 #12

 

 

2

3-Feb

W

The Relational Model

Chapter 2

 

 

2

5-Feb

F

Structured Query Language

Chapter 3

SQL Scripting #1

SQL Scripting #2

Assignment 2

(1) pp99-100 (6e) / pp108-109 (7e), Exercise 2.38 to 2.42;

(2) pp105-106 (6e) / pp114-115 (7e), Garden Glory Project Questions (you may use the tables in Assn1 keys).

Due: 2/10, Wednesday, before 11:59p, either hardcopy or e-copy by email (isqs3358@gmail.com).

3

8-Feb

M

Structured Query Language

Chapter 3

SQL Scripting #3

SQL Scripting #4

Lab Exercise 0: Create a database with three tables: (Adviser, Student, Course), screenshot one page sent by email to isqs3358@gmail.com, due 2/13

 

3

10-Feb

W

Structured Query Language

Chapter 3

SQL Scripting #5

SQL Scripting #6

Lab Exercise 1: Create a database with SQL scripts, screenshot one page sent by email to isqs3358@gmail.com, due 2/15

 

3

12-Feb

F

Structured Query Language

Chapter 3

SQL Scripting #7

SQL Scripting #8

Assignment 3

pp198-199 (6e) / pp216-218 (7e), Exercise 3.57 to 3.61.

Due: 2/19, Friday before 11:59p, email the SQL codes and the screenshots of the database (isqs3358@gmail.com).

 

4

15-Feb

M

Structured Query Language

Chapter 3

SQL Scripting #9

SQL Scripting #10

4

17-Feb

W

Data Modeling and the Entity-Relationship Model

Chapter 4

E-R Model

 

4

19-Feb

F

Data Modeling and the Entity-Relationship Model

Chapter 4

Assignment 4, due 2/29, Monday before 11:59p, email the SQL codes and the screenshots of the database (isqs3358@gmail.com).

Review questions:

pp252-253 (6e) / pp280-281, Question 4.1 to 4.27

 

5

22-Feb

M

Data Modeling and the Entity-Relationship Model

Chapter 4

Lab Exercise 2: SQL Exercises, screenshots in a Word file sent by email to isqs3358@gmail.com, due 2/26

5

24-Feb

W

Data Modeling and the Entity-Relationship Model

Chapter 4

5

26-Feb

F

Review 1

Chapter 1, 2, 4 (the first part)

Assignment 5, due 3/10,Thursnday before 11:59p, email the SQL codes and the screenshots of the database (isqs3358@gmail.com).

 

 

6

29-Feb

M

Exam 1

 

 

 

6

2-Mar

W

Database Design

Chapter 5

Lab Exercise 3: due 3/4

 

6

4-Mar

F

Database Design

Chapter 5

Assignment 6, due 3/21, Monday before 3class meeting.

Review questions:

pp295-296 (6e) / pp325-326 (7e), Question 5.1 to 5.35

Form project teams

7

7-Mar

M

Database Design

Chapter 5

Lab Exercise 4: due 3/10

Teams meeting with the instructor

7

9-Mar

W

Database Design

Chapter 5

 

Project: proposal due (1 page)

7

11-Mar

F

Term project advising

 

Assignment 7 (due 3/30, Wednesday, before class meeting)

 

8

14-Mar

M

Spring Break

 

 

 

8

16-Mar

W

Spring Break

 

 

 

8

18-Mar

F

Spring Break

 

 

 

9

21-Mar

M

Database Administration

Chapter 6

Lab Exercise 5: TBD, screenshots in a Word file sent by email to isqs3358@gmail.com, due 3/25

9

23-Mar

W

Database Administration

Chapter 6

Assignment 8 (due 4/4, Monday, before class meeting

 

9

25-Mar

F

Database Administration

Chapter 6

Project: Database design due

10

28-Mar

M

Easter – No class

 

 

10

30-Mar

W

Database Administration

Chapter 6

10

1-Apr

F

Review 2

 

11

4-Apr

M

Exam 2

Chapter 5, 6

 

11

6-Apr

W

Database Processing Applications

Chapter 7

Lab Exercise 6: Review and explore Azure SQL Server.

   

11

8-Apr

F

Database Processing Applications

Chapter 7

Azure

 

12

11-Apr

M

Cloud computing

 

Project: Database Implementation due  

12

13-Apr

W

Cloud computing

 

 

12

15-Apr

F

Virtual machine

Lab Exercise7: Install and test VirtualBox and SQL Server 2014 (see http://www.intowindows.com/how-to-install-windows-7-on-virtualbox/). Due 4/20

 

13

18-Apr

M

Rescheduled

Exam3-1 due before class

13

20-Apr

W

Web database

Appendix I

13

22-Apr

F

Web database

Appendix I

 

 

14

25-Apr

M

Web database

Appendix I

Exam3-2 due before class

14

27-Apr

W

Web database

Appendix I

14

29-Apr

F

2016 Big Data Symposium

 

 

   

15

2-May

M

Review (SQL Scripting)

 

Exam3-3 due before class

Project:  Demonstrative Database Application

15

4-May

W

Review (SQL Scripting)

 

 

16

9-May

M

 

 

 

Group Project Report due

16

13-May

F

Final (Exam 3-II, 4)

 

 

1:30-4:00p