Professor Porter EUP

Edinboro University

CSCI 313-001 Database Management Systems (Spring 2020)

CSCI 313-001 Course Information

Syllabus
Student Files
Groups

Week

Lecture/Notes

Assignments

#1
Jan 13-17

Chapter 1
Appendix A - Text
Appendix A - Slides

Read: Chapter 1 & Appendix A
Install: Microsoft Office (Access)

#2
Jan 20-24

NO CLASS ON MONDAY JANUARY 20TH

Chapter 1
Appendix A - Text
Appendix A - Slides

Homework 1 - Appendix A:
Exercise A.12
Steps A - U
pg. A-44 - A-47
*Upload your Cape_Codd.accdb database to D2L drop box Homework 1*
Recursive Relationships
Due: January 31st @ 11:30PM

Read: Chapter 2

#3
Jan 27-31

Chapter 2 - Part 1
Chapter 2 - Part 2

Homework 2 - Chapter 2:
Review Questions
2.17 - 2.54
pg. 121 - 123
*Upload a Word document with each SQL query or question response to D2L drop box Homework 2*
Cape Codd Access Database
Smart Quotes to Straight Quotes in Word
Due: February 10th @ 11:30PM

Read: Chapter 2

#4
Feb 3-7

Chapter 2 - Part 1
Chapter 2 - Part 2

Read: Chapter 3

#5
Feb 10-14

Chapter 3
Feb 14 Notes

ACM - A Relational Model of Data for Large Shared Data Banks
Full Paper - A Relational Model of Data for Large Shared Data Banks

Exam #1 ⟹ Friday February 21st

Homework 3 - Chapter 3:
Case Questions Regional Labs
Questions A - J
pg. 186 - 187
*Upload a Word document with each question response to D2L drop box Homework 3*
Due: February 19th @ 11:30PM

Group Assignment 1 - Chapter 2:
The Queen Anne Curiosity Shop Project
Questions A - U
pg. 133 - 140
*Use Microsoft Access for these questions*
*Upload a Word document with each SQL query or question response to D2L drop box Group Assignment 1*
*Upload a separate statement explaining how your group distributed the work and what each group member was assigned*
*Designate a Group Leader who will upload the answers for the entire group*
Due: February 24th @ 11:30PM

Read: Chapter 3

#6
Feb 17-21

EXAM #1

Chapter 3
Feb 17 Notes
Feb 19 Notes

Read: Chapter 4

#7
Feb 24-28

Chapter 4

Homework 4 - Chapter 4:
Review Questions
4.2, 4.3, 4.4, 4.6, 4.9, 4.10, 4.18, 4.19, 4.22, 4.34
pg. 206 - 208
*Upload a Word document with each question response to D2L drop box Homework 4*
Due: March 7th @ 11:30PM

Group Assignment 2 - Chapter 3:
The Queen Anne Curiosity Shop Project
Questions A - G
pg. 187 - 189
*Upload a Word document with each question response to D2L drop box Group Assignment 2*
*Upload a separate statement explaining how your group distributed the work and what each group member was assigned*
Group Assignment 3 - Chapter 4:
The Queen Anne Curiosity Shop Project
Questions A - G
pg. 209 - 210
*Upload a Word document with each question response to D2L drop box Group Assignment 3*
*Upload a separate statement explaining how your group distributed the work and what each group member was assigned*
Due: March 7th @ 11:30PM

Read: Chapter 5, Appendix B & Appendix C

#8
Mar 2-6

Chapter 5
Appendix B - Text
Appendix B - Slides
Appendix C - Text
Appendix C - Slides

Read: Chapter 5 & 6

#9
Mar 9-13

SPRING BREAK - NO CLASSES

#10
Mar 16-20

EXTENDED SPRING BREAK - NO CLASSES

#11
Mar 23-27

READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L

#12
Mar 30-Apr 3

READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L

#13
Apr 6-10

READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L

#14
Apr 13-17

READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L

#15
Apr 20-24

READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L

#16
Apr 27-May 1

Final Exam Review

FINALS WEEK
CSCI313-001: FRIDAY MAY 1ST
10:15AM-12:15PM
ROSS 136

Resources:

Office 365 Install on Windows 10
W3Schools SQL Tutorials
MySQL Downloads
MySQL 8.0 Reference Manual

Schedules:

Spring 2020 CSCI Tutoring Schedule
Last update: