IT data model Paper
Required Texts:
1. Fundamentals of Database Systems (7th Edition - 2015) by Elmasri and Navathe. Addison-Wesley Professional
2. PHP and MySQL Web Development (4th Edition – 2009 or 5th Edition 2014) by Luke Welling and Laura Thomson. Addison-Wesley Professional
Course Delivery:
This course is delivered online by utilizing the Canvas learning management system at Montclair State University (MSU), accessible via https://montclair.instructure.com/
Course Description:
Welcome to CSIT 555: Database Systems! This is a course primarily concerned with the theory, construction, and application of databases to meet the needs of an increasingly computerized world. You'll learn how to think like a computer scientist as you create your own database, learning how to translate a theoretical design from a client into a practical design that can perform queries, store and recall data, and more.
This course will take place over 16 weeks and is broken up into 8, 2-week modules. Within each learning module you will be asked to complete specific activities that will be submitted to your instructor, engage in collaborative exercises that may require peer collaboration, and other assignments as described in each module.
Course Goals:
1. Students are able to identify and define key database concepts
2. Students are able to model a small “data universe” with the E-R models
3. Student are able to perform through written statements data extraction from a database using Relational algebra
4. Students are able to perform through written statements and interactions with a database, database creation, update, and data extraction commands with SQL.
5. Students are able to use database software to create a relational database with multiple tables and a Web interface.
6. Students can identify functional dependencies in a database design.
7. Students can manipulate a database design correctly so that it is in first, second and third normal forms
8. Students are able to comprehend the basic storage structures involved with databases.
9. Students can apply skills in previous courses and their skills in this course to complete a database application project.
Course Schedule:
|
Learning Module |
Time Duration (EST) |
Readings and Media |
Assignments |
|
Module 1: Introduction to Databases |
(Wednesday 9/6 12:01am - Sunday 9/10 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 1 and 2 · M1 PowerPoint |
· Discussion 1.1 · Quiz 1.1 |
|
|
(Monday 9/11 12:01am - Sunday 9/17 11:59pm EST) |
|
· Discussion 1.2 · Quiz 1.2 |
|
Module 2: Data Model and Relational Design |
(Monday 9/18 12:01am - Sunday 9/24 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 3 and 4 · M2 PowerPoint
Media: · Animation 1 and 2 |
· Online Discussion · Quiz 2.1 |
|
|
(Monday 9/25 12:01am - Sunday 10/1 11:59pm EST) |
|
· Discussion 2.2 · Quiz 2.2 · Business Plan Draft |
|
Module 3: The Relational Model |
(Monday 10/2 12:01am - Sunday 10/8 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 5 and 9 · Project Documentation · M3 PowerPoint
Media: · Animation 3 |
· Discussion 3.1 · Quiz 3.1 |
|
|
(Monday 10/9 12:01am - Sunday 10/15 11:59pm EST) |
|
· Discussion 3.2 · Quiz 3.2 · Application Project: Workflow Report 1 · Theory Paper: Proposal · ER Diagram |
|
Module 4: Querying |
(Monday 10/16 12:01am - Sunday 10/22 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 8, 6, and 7 · M4 PowerPoint
Media: · Animation 4 |
· Discussion 4.1 · Quiz 4.1 · Application Project: Workflow Report 2 |
|
|
(Monday 10/23 12:01am - Sunday 10/29 11:59pm EST) |
|
· Discussion 4.2 · Quiz 4.2 · Application Project: Workflow Report 3 · (No submission): Work on ER for application project · (No submission): Work on detailed outline for theory project |
|
Module 5: Web Development and Programming |
(Monday 10/31 12:01am - Sunday 11/5 11:59pm EST) |
Readings: · PHP and MySQL Web Developments (Welling) · Chapters 1 through 11 (skip 8, 9, and 10) · M5 PowerPoint
Media: · Video: How to Log Into a Database Server Using CPanel |
· Discussion 5.1 · Quiz 5.1 · Application Project: Conceptual Model with translation into Relational Model · Application Project: Workflow Report 4 |
|
|
(Monday 11/6 12:01am - Sunday 11/12 11:59pm EST) |
|
· Discussion 5.2 · Quiz 5.2 · Application Project: Workflow Report 5 |
|
|
|
|
· Theory Project: Detailed Outline |
|
Module 6: Database Design |
(Monday 11/13 12:01am - Sunday 11/19 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 14 and 15 · M6 PowerPoint
Media: · Animation 5 |
· Discussion 6.1 · Quiz 6.1 · Application Project: Views and Roles “Sketches” · Application Project: Workflow Report 6 |
|
|
(Monday 11/20 12:01am - Sunday 11/26 11:59pm EST) |
|
· Discussion 6.2 · Quiz 6.2 · Application Project: Workflow Report 7 · Theory Project: Citations |
|
Module 7: Databases and the Physical Machine |
(Monday 11/28 12:01am - Sunday 12/10 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 16 and 17 · M7 PowerPoint |
· Discussion 7.1 · Quiz 7.1 · Application Project: Preliminary Database Design Discussion · Application Project: Workflow Report 8 · Schedule applied project demo · Schedule theory project demo |
|
|
(Monday 12/11 12:01am - Sunday 12/17 11:59pm EST) |
|
· Discussion 7.2 · Quiz 7.2 · Application Project: Workflow Report 9 · Theory Project: Final Draft of Paper Due · Schedule applied project demo · Schedule theory project demo |
|
Module 8: Advanced Topics |
(Monday 12/18 12:01am – Thursday 12/21 11:59pm EST) |
Readings: · Fundamentals of Database Systems (Elmasri/Navathe) · Chapter 30 · M8 PowerPoint |
· Discussion 8.1 · Quiz 8.1 · Ethics Assignment · Application Project: Full Documentation · Application Project: Workflow Report 10 · Application Project: Online Demonstration to Professor (can be completed earlier) · Theory Project: Presentation · Final Applied Project |
Evaluation and Grading
Students can generally work at their own pace but must complete all units consistent with the time limitations in your syllabus. Content may be removed and unavailable beyond the times described within this syllabus. All times are Eastern Time Zone. Not all course material is covered in the assigned readings. Examinations/evaluations may include material covered by lecture, PowerPoints, class discussion, or digital distributions in addition to assigned readings.
The following is a breakdown of the components that make up your overall grade in the course:
|
Component |
Percent of Overall Grade |
|
Discussions |
15% |
|
Quizzes |
15% |
|
ER Diagram Assignment |
5% |
|
Security and Ethics Assignment |
5% |
|
Application Project: Final Project |
20% |
|
Application Project: Module Based Assignments |
10% |
|
Application Project: Average of Workflow Reports |
5% |
|
Theory Project: Final Project |
15% |
|
Theory Project: Average of Module Based Assignments |
10% |
|
Total |
100% |