School of Mathematics &
Computer Science
Course#: CSC (0145) 391-006 Database Management Independent Study
Class Time: T 12:15 - 1:30
Instructor: Professor
Pepper
Office: Science 108 or Alumni Hall 114
Telephone: 516-747-2362, and please leave a message with your phone number.
Office Hours: Tuesday 12:15-1:30 & Thursday 9:55 - 10:40
E-mail: pepper@adelphi.edu
http://www.adelphi.edu/~pe16132
Blackboard: http://my.adelphi.edu/
Still being decided
This course covers in-depth analysis of the relational database model, objectives of database processing, database design, and storage structures and access methods. Database design and normalization, normal forms. Programming assignments will be done using Access or Oracle or MS SQL. UML Diagramming.
Grading System
The course grading scale is: A+ 99-100, A 93-98, A- 90-92, B+ 87-89, B 83-86, B- 80-82, C+ 77-79, C 73-76, C- 70-72, D 60-69, and F is below 59. It is not anticipated that grades will be curved.
Grading will be based on timely delivery of high quality deliverables.
Disabilities
If you have a physical, medical or learning disability and
require accommodations, please contact the Office of Disability Support
Services (DSS) to discuss these accommodations. DSS is located in the
University Center Room 310 at 516-877-3145.
Schedule
|
Thursday Date |
Meeting Date |
Pepper presents |
Deliverable |
|
2/1 |
2/1 |
What is a database & what are functions |
|
|
2/7 |
2/7 |
Basic SQL Select / sort /join High level spec |
www.functionx.com/sqlserver/ 1-5 and glance at 6-7 |
|
2/14 |
2/14 |
Connect to DB Lytec intro How to ERD and class diagram |
www.functionx.com/sqlserver/ 8-9 & 13-15 and glance at 10-12 (demonstrate ability to use ms sql
in general) |
|
2/21 |
Skip |
Email worded description of Lytec layout |
Demonstrate ability to query Lytec
database a little |
|
2/28 |
2/28 |
Division of responsibility & UML; Normal forms |
ERD of all Lytec tables needed (maybe some UML) based on worded description |
|
3/6 |
3/4*** |
Total query / complex join |
Tech spec for required queries and pgm and UML diagrams and demonstrate experimentation with queries |
|
3/20 |
3/20 |
Handling sql variations |
All required queries if all field entered |
|
3/27 |
3/27 |
Visual C++ |
All required SQL code for final project |
|
4/3 |
4/3 |
Visual C++ |
Work through tutorial |
|
4/10 |
4/10 |
Connect to DB |
Finish tutorial; One field screen in visual C++ |
|
4/17 |
4/17 |
|
Query Lytec using one field screen in Visual C++ |
|
4/24 |
Skip |
|
Final project if all fields filled, no sort or total |
|
4/31 |
4/29*** |
|
Final project if all fields filled on one sort and total |
|
5/6 |
5/6 |
|
Final project all fields |
|
5/15 |
5/15 |
|
Hopefully done by now |