Purpose of the Course

The purpose of this, the first course in the database sequence, is to introduce the student to good database design. This includes understanding underlying theoretical models and hands-on experience with the standard database query language, SQL. In particular, it prepares the student for INSYS365, which is an advanced course in SQL, particularly as implemented by Oracle.

How to get in touch with me

Instructor: Dr. Xiaohua Tony Hu

Email: xh29@drexel.edu

Homepage: http://cci.drexel.edu/faculty/thu/

Office: 3401 Market Street, Suite 300, Room 325

phone: 215-895-0551

fax: 215-895-2494

office hr: 9:30-10:30am Tuesday or by appointment

Lecture Time: 8:00-9:20am Tuesday and Thursday

classroom: UCROSS 151

Grades

Quiz	15%
Homework	10%
Mid-term	15% (Week 6)
Group Project	30%
Final (Comprehensive)	Week 11(30%)

Standards:

Homework

All homework must be submitted in hard copy format after the class on the due date, with your name and identification of which homework it is (e.g., John Student, Homework 5).

No homework will be accepted late unless arrangements are made in advance. All homework must be printed from computer. No hand-written homework is accepted, absolutely no exception.

Exams

No exams or quizzes will be given late unless arrangements are made in advance, or unless a written note (e.g., from a doctor) is supplied.

All exams will be closed book, unless otherwise noted.

Projects

No project will be accepted late unless arrangements are made in advance.

If you are having any trouble with project teammate, tell me SOONER rather than LATER!

If you don’t pull your weight in a project, you receive a reduction in grade, at my discretion. Project standards may be found on my web site.

Project Structure: (For complete details, please refer to Project document)

Statement of Purpose and Scope

Requirements

Analysis (Discussion of the current system, manual or automated)

Design (ERD)

Relational Model

Data Dictionary

SQL code

Project Structure, continued

N.B.

Spelling and grammar count!

Project paper must be paginated.

One file with CREATE TABLE statements, called CREATE.SQL.

One file with INSERT statements, called INSERT.SQL.

One file for each of 8-12 queries, named appropriately.

One file with commands that will DELETE all database objects created above.

You may do you Oracle homework and project using iCommon facilities, or you may download the Oracle Database Express Edition

http://www.oracle.com/technetwork/indexes/downloads/index.html from Oracle and install at your own PC

Oracle ID at iCommon: Request an Oracle ID at https://linux.ischool.drexel.edu/signup/index.pl

Week #	Materials Covered
1	General Introduction and Introduction to ER Modeling
2	ER Model, Quiz 1;
3	ER Model con’t.
4	Conversion to Relational Schema
5	ER Model Extensions, Quiz 2
6	Midterm; Introduction to Relational Algebra & Relational Theory
7	SQL
8	SQL con’t.
9	SQL cont.
10	Quiz 3, Normalization & Review

Textbook:

Title: R. Elmasri and S.B. Navathe, Fundamentals of Database Systems, Benjamin/Cummings, 6th Ed. (Older version is okay.)

Recommended:

Title: Oracle Database 11g The Complete Reference (Oracle Press)

Authors: Kevin Loney

Publisher: McGraw-Hill (Osborne)

ISBN-13: 978-0071598750

Slides: Lecture slides will be available on the course website before classes.

Plagiarism

All the students are expected to be honest and do their assignments by their own. Any kind of similarity between any two assignments will directly result in F for both the students, NO EXCEPTION, NO EXCUSE in this case. Just making minor changes in the assignments taken from somebody or from other sources and submitting the assignment will not work. So please do submit your own work. If you can’t do it, then just attempt it, points will be given for attempting