Page 1 of 8

School of Applied an Information Technology

Catonsville Campus

SCHEDULE: Database Concepts– CINS234WCH

January 25, 2019
This is NOT the FINAL VERSION

This is an Overview of Course Activities see the Learning Modules for specifics!!!

Date / Module / Activities / Due Date
Course Orientation Assignment:Due by midnight Wednesday August 27, 2008
It is important that you complete this assignment by the deadline. This assignment prepares you to successfully complete this course and determines the compatibility of your pc's hardware and software to course materials.
Read and Do the CourseOrientation Assignment that was sent to you.
TheCourse Orientation Assignmentis also posted on theDiscussion Board
8/27/08
1 /
  1. Do Course Orientation Assignmentposted on Discussion Board
  2. ReadChapter1:Introduction to Database Management
  3. Do Chapter 1:Henry Books CaseUse Word to prepare your answers*
  4. Do Concepts Review: Chapter 1 (WebCT) extra credit possible
*NOTE: No need to submit, grade is not recorded / Midnight
9/3/08
IMPORTANT:
Make sure you have made 6 copies of the CINS234Data folder and
renamed each folder copy to correspond with the following chapters:
Chapter2CINS234Data
Chapter3CINS234Data
Chapter4CINS234Data
CreateDBMSCINS234Data
MigrateDBMSCINS234Data
Chapter7-9CINS234Data
MySQLCINS234Data
Refer to Step 9b of theCourse Orientation Assignment for further details
9/4/08 / Attend the Catonsville Campus room H233 from 5:45pm – 8:40pm
Bring your textbook
Scheduled Activities:
Download Data Files and Create 7 Folders (if students have not completed)
Learn to Backup and Restore an Access Database
Learn to interpret an Entity Relationship (ER) Diagram
Analyze the Relational Database Model by determining Tables to use in Queries
Work with the Relational Database Model by writing simple Queries
9/4/08
2 /
  1. Read Handout: Backing Up and Restoring a Database
  2. ReadChapter 2: The Relational Model 1: Introduction and QBE
Omit RELATIONAL ALGEBRA pages 56-63
  1. View Demo under WebCT: Interpreting ER Diagrams
  2. View Demo under WebCT: Querying with Access the Basics
  3. Do Chapter 2: Henry Books Case*
Items:4, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21only
  1. Do Concepts Review: Chapter 2 (WebCT) extra credit possible
Use the following:
Folder: Chapter2CINS234Data
Database: Henry Books.accdb
If you do not complete a Chapter during one session, BACKUP the database before continuing to work on the Chapter.
You might consider backing up the database prior to performing a step you are somewhat uncertain about.
*NOTE: No need to submit, grade is not recorded / Midnight
9/10/08
9/11/08
3 / GRADED PROJECT
Do Alexamara Marina GroupCase
Do Chapter 2: Alexamara Marina Group Case
Items:4, 10, 12, 13, 14, 16, 17, 18, 19, 20only
Use the following:
Folder: Chapter2CINS234Data
Database: Alexamara.accdb
If you do not complete the Case during one session, BACKUP the database before continuing to work on the Case.
You might consider backing up the database prior to performing a step you are somewhat uncertain about. / Midnight
9/17/08
9/18/08
4 /
  1. View Demo under WebCT: Querying with Access SQL
  2. ReadChapter 3: The Relational Model 2 – SQL
  3. Do Chapter 3: Henry Books Case* - Write the Queries in SQL View
    Items: 9, 11, 12, 13, 14, 15, 16, 19, 20, 21only
  1. Do Concepts Review: Chapter 3 (WebCT) extra credit possible
Use the following:
Folder: Chapter3CINS234Data
Database: Henry Books.accdb
If you do not complete a Chapter during one session, BACKUP the database before continuing to work on the Chapter.
You might consider backing up the database prior to performing a step you are somewhat uncertain about.
*NOTE: No need to submit, grade is not recorded / Midnight
9/24/08
9/25/08
5 / GRADED PROJECT
Do Alexamara Marina Group Case
Do Chapter 3: Alexamara Marina Group Case
Items: 8, 10, 11, 12, 13, 14, 15, 18, 19, 20only
Write queries using the SQL View. Do NOT go back into the GUI View and make any changes. Making changes in the GUI View causes Access to the save the query using Access SQL and your query will be graded as incorrect.
Use the following:
Folder: Chapter3CINS234Data
Database: Alexamara.accdb
There is a SQL / How Do I Reference under Appendix B and C pages 345-356
If you do not complete the Case during one session, BACKUP the database before continuing to work on the Case.
You might consider backing up the database prior to performing a step you are somewhat uncertain about. / Midnight
10/1/08
10/2/08 / Attend the Catonsville Campus room H233 from 5:45pm – 8:40pm
Scheduled Activities:
Distribution of MySQL Database software
Distribution of Instructions for Installing MYSQL
Create Database and Tables using Script Files (*.sql)
Write Queries in MySQL| Save Asa Script (*.sql) file
Work with the Relational Database Model Advanced Topics – Views, Constraints…
10/2/08
6 /
  1. Read Chapter 4: The Relational Model 3 – Advanced Topics
  2. View Video under WebCT: Creating Databases/Queries using MySQL
  3. Do: Installing MySQLLabHandout
  4. Do: Creating and Querying a MySQL DatabaseLab Handout*
Use the following:
Folder: Chapter4CINS234Data
Script File: MySQL-Premiere.sql
  1. Do Chapter 4: Henry Books Case Items:2, 4, 6, 8and9only*
  2. Write the SQL Statements Using MySQL | Save Asa *.sql file
  3. Omit item 6 when writing SQL statements under MySQL
  4. Use Access GUI features to implement the same queries
Use the following:
Folder: Chapter4CINS234Data
Database: Henry Books.accdb (for Access only)
Script File: MySQL-Henry.sql (for MySQL only)
  1. Do Concepts Review: Chapter 4 (WebCT) extra credit possible
If you do not complete a Chapter during one session, BACKUP the database before continuing to work on the Chapter.
You might consider backing up the database prior to performing a step you are somewhat uncertain about.
*NOTE: No need to submit, grade is not recorded / Midnight
10/8/08
10/9/08
7 / GRADED PROJECT
Do Alexamara Marina Group Case
Do Chapter 4: Alexamara Marina Group Case
a. Items 1, 3, 6, 7, 8 only
b. Write SQL Statements in MySQL | Save AsScript file (for submittal)
c. Omit item 6 when writing SQL statements under MySQL
d. Use Access GUI features to implement these sameitems
(For queries other than Views use the item number as the name Query1…)
Use the following:
Folder: Chapter4CINS234Data
Database: Alexamara.accdb(Access only)
Script File:MySQL-Alexamara.sql (MySql only)
If you do not complete the Case during one session, BACKUP the database before continuing to work on the Case.
You might consider backing up the database prior to performing a step you are somewhat uncertain about. / Midnight
10/15/08
10/16/08 / Attend the Catonsville Campus room H233 from 5:45pm – 8:40pm
Scheduled Activities: - Please return the MySQL cds
Lecture Chapter 5
Work with Normalization
Create and Manage a Database using MySQL
Extra Learning for Extra Credit: Worth 10 points towards the Midterm Exam
Do items 1, 3, 5, 7, 10 and 11 of the Chapter 4 Henry Books Case – due10/16/08
10/16/08
8 /
  1. Read and Do: Creating/Managing a DBMS using MySQL Lab Handout
    Use the following:
Folder: MySQLCINS234Data
Database:Premiere Products.mdb- located in the Access 2000 Folder
If you missed 10/16 campus meeting MySQL is installed at the Catonsville and Essex Open Labs if needed
  1. Study Concept Reviews (WebCT) for Midterm Exam: Chapters 1 - 4
Midterm Exam Available to start taking today
*NOTE: No need to submit, grade is not recorded / Midnight
10/22/08
10/23/08
9 / Midterm Exam:
Chapters 1 – 4 TakeWebCT: 234 Midterm ExamOpen Textbooks / Notes / Midnight
Tonight
10/3/08
  1. Read Chapter 5: Normalization
  2. Do Chapter 5: Henry Books Case – Exercise #4*
  3. Do Concepts Review: Chapter 5 (WebCT) extra credit possible
Use the following:
Folder: Chapter5CINS234Data
Database: Henry Books.accdb
Software: Word
Answers should be written in Word using the Table, Column notation
Ex. TableName (Primary Key, Column2, Column3)
Solution will be available on the Solutions page on 10/30/08
*NOTE: No need to submit, grade is not recorded / Midnight
10/29/08
10/30/08 / Attend the Catonsville Campus room H233 from 5:45pm – 8:40pm
Scheduled Activities:
Lecture on Chapter 6 Database Modeling
Demonstrate creating a Database Model using Visio
Complete a Tutorial: Creating a Database Model using MS Visio
10/30/08
10 /
  1. Read Chapter 6: Design Methodology
  2. Install Visio 2007 or plan to use the Open Lab
  3. Do: MS Visio 2007 Professional Example Lab Handout
  4. Do: MS Visio 2007Professional TutorialLab Handout
Do Chapter 6: Henry Books Case*
Use the following:
Software: MS Visio 2007 Professional
Solution will be available on the Solutions page on 11/6/08
  1. Do Concepts Review: Chapter 6 (WebCT) extra credit possible
*NOTE: No need to submit, grade is not recorded / 11/5/08
11/6/08
11 / GRADED PROJECT
DoCase: Alexamara Marina Group
Do Chapter 5: Alexamara Marina Group – Additional Case Exercise
  • Item #2
  • Answers should be written in Word using the Table, Column notation Ex. TableName (Primary Key, Column2, Column3)
Do Chapter 6: Alexamara Marina Group – Additional Case Exercise
  • Design the E-R Model for the Marina Database using Visio
  • IncludeTables, Columns, Relationships, Primary and Foreign Keys, Cardinalities, Verb Phrases and the major Business Rules
  • Ignore Textbook and Use Surrogate Keys where appropriate
Do Chapter 6: Alexamara Marina Group – Additional Case Exercise
  • In Word, Design the Database using DBDL
  • Include Tables, Columns, Primary Keys and Foreign Keys
  • Ignore Textbook and Use Surrogate Keys where appropriate
IMPORTANT: This project will not be accepted late and corrections will not be allowed / Midnight
11/12/08
11/13/08
12 / FINAL PROJECT - GRADED PROJECT
Create the Database for the Marina E-R Model designed in the previousAppendix Bproject. Name the database Marina.accdb
Create the Database using MS Access using the GUI Interface
Use the Official Data Dictionary and E-R Diagramthat will be available on Learning Module 12 or the Handouts page on 11/13/08
  • Create the Tables and Relationships
  • Points will be deducted if specified Table and Column names are not used
  • Set Referential Integrity
  • Set Entity Integrity (Primary Keys)
  • E-mail me the Marina.accb file - under WebCT e-mail only!!!
If you do not complete the Project during one session, BACKUP the Access database before continuing to work on the Project.
You might consider backing up the database prior to performing a step you are somewhat uncertain about. / Midnight
11/19/08
Extra Learning for Extra Credit: Worth 10 points towards the Chapter 5-6 Project
CompleteReverse Engineering a Database Using Visio Lab Handout
under Handouts Page (Module 13) – due 12/3/08
11/20/08
13 /
  1. Read Chapter 7: DBMS Functions
  2. Use Access Help to Learn to do the following: *
  • Encrypt a Database by Using a Database Password – search on encrypt
  1. Read Chapter 9: Database Management Approaches these topics:
  2. Client/Server Systemspages283 – 287
  3. Web Access to Databases pages 287–293
  4. Data Warehouse and Data Mining pages 293–299
  5. Read: Data Warehouse and Data Mining Handout
  1. Do: Creating an Excel Pivot Table Using a Cube Lab Handout
  1. Read the following Handouts for Comprehension*
  2. Client Server Computing (Visual Studio 2005 needed–will do Lab on 12/4)**
  3. Web Database Applications (Visual Studio 2005 needed - will doLabon 12/4)**
  4. Do Concepts Review: Chapters 7 and 9(WebCT) extra credit possible
*NOTE: No need to submit, grade is not recorded
**If you must missed 12/4: Visual Studio 2005 is installed in Catonsville and Essex Open Labs / Midnight
12/3/08
Thanksgiving Holiday: College Closed November 26 – November 28, 2008
12/4/08 / Attend the Catonsville Campus room H233 from 5:45pm – 8:40pm
Scheduled Activities:
Client Server Computing Lab Handout
Web Database Applications Handout
12/4/08
14 /
  1. Review for Final Exam: Chapters 1 –7 and 9
  2. Do the following Lab Handouts:
  3. Client Server Computing (use Open Lab if you missed 12/4 class)
  4. Web Database Applications (use Open Lab if you missed 12/4 class)
  5. Do: Reverse Engineering a Database Handout for Extra Credit towards Chapter 5-6 Project (optional) – due 12/3/08
  6. Final Exam is Available to start taking today
/ --
12/5/2008Final Project Corrections (optional) Due by midnight
12/10/2008Final Exam Due by midnight
Take WebCT: 234 Final Exam Open Book and Open Notes