CSCI 6315

Applied Database Systems

Using Oracle

Dr. John P. Abraham

Spring 2004

Current Course Schedule (Spring, 2004)

By

Dr. John P. Abraham

University of Texas – Pan American

CSCI 6380	ARRANGED
CSCI 6390	ARRANGED
Office Hours	M 8:30-9:00 PM	Please make appointment	For evening students only
OFFICE HOURS	T 8:30-9:00	Please make appointment	For evening students only
OFFICE HOURS	M 9:30 - 11:30 AM
OFFICE HOURS	Th 9:00-12:00 NOON
CSCI 6315 Applied Database Systems	M 5:45 - 8:25 PM	Syllabus	midtermReview
CSCI 6335 Advanced Computer Architecture	Th 5:45 – 8:25 PM	Syllabus
ELEE 6335 Advanced Computer Architecture	Th 5:45 – 8:25 PM	SyllabusEE
CSCI 4390 Senior Project	BY APPOINTMENT

Teaching Assistants: Mr. Sebastian Puthenpurayil. All homework and lab related assignments will be handled by the TA.

Kyewook Lee, Tele: 956-661-9103. email: kyewooklee@hotmail.com. Kyewook Lee will be responsible for Oracle related teaching and laboratory assignments.

Email for the TA – smputhenpur@panam.edu

Web http://cs.panam.edu/~sebastian/

Warning: This is a very time intensive course. If you do not have 12 hours a week in addition to the class period, do not sign up for this course.

Required Text Book:

Thomas Conolly and Carolyn Begg, Database Systems, A Practical Approach to Design, Implementation and Management. 3^rd ed. Addison Wesly, 2002. ISBN 0-201-70857-4

Recommended Reading:

Carol McCullough-Dieter, Oracle9i Database Administrator: Implementation and Administration. Thomson Course Technology, 2003. ISBN 0-619-15900-6

Benjamin Rosenzweig and Elena Silvestrova, Oracle PL/SQL, 2^nd Edition, Prentice Hall 2003. ISBN 0-13-047320-0

Objectives for the course: Upon completion of the course the student will:

1. Demonstrate knowledge in theoretical foundation of database.

2. Install and administer the Oracle database 9i.

3. Create and maintain a sample database with all its associated relations.

4. Create reports as specified by the faculty.

5. Remotely connect to the database and manipulate the data.

Assignments:

The TAs will coordinate the Oracle portion of this course. They will give specific assignments to you each week. Please consult their websites for weekly assignments and instructions.

Tentative Schedule

Date	Activity – Topic	Chapters
1/12/04	Introduction and database environment	1,2
1/19/04	Holiday-Martin Luther King
1/26/04	Relational Model and Relational Algebra	3,4 - students bring quiz
2/2/04	DML, DDL	5,6 - students bring quiz
2/9/04	QBE and RDBMSs	7,8 - students bring quiz
2/16/04	Database Planning, Design and Administration and Fact Finding Techniques	9, 10 students bring quiz
2/23/04	Mid Term Exam
3/1/04	Entity-Relationship Modeling	11, 12
3/8/04	Spring Break
3/15/04	Normalization and Methodology	13, 14 - students bring quiz
3/22/04	Logical Database design and physical database design	15, 16 & 17 - students bring quiz
3/29/04	Security, Transactional management	18, 19 - students bring quiz
4/5/04	Query Processing and Programmatic SQL	20-21 - students bring quiz
4/12/04	Advanced Topics	TBA - students bring quiz
4/19/04	Advanced Topics	TBA -students bring quiz
4/26/04	Advanced Topics	TBA -tudents bring quiz
	FINAL EXAM

Each student will come up with a database project applicable to his/her area of expertise and develop a schema for an Oracle application. Present this to the class showing tables, relationships, reports, etc. You do not have to implement it. This is the planning document.

Student Presentations. Please be aware that you will not be allowed to change dates. Maximum of two 5-10 min presentations per day.

Date	Topic	Name
1/19/04	Holiday-Martin Luther King
1/26/04
2/2/04
2/9/04
2/16/04
2/23/04
3/1/04
3/8/04	Spring Break
3/15/04
3/22/04
3/29/04
4/5/04
4/12/04
4/19/04
4/26/04

Attendance and class participation is required to pass the course.

Grading:

Test grades - 50% 90%-100% A

Assignments - 30% 80%-89% B

Daily Quizzes (student created) 10%* 70%-79% C

Student presentations 10%

*For each day of class you will prepare 10 multiple choice questions (along with keys) over the material covered. Please bring two copies of the tests. These questions will be given as daily quizzes. Maximum 5 points will be given for good questions you bring and 10 points for the quiz you take that day. Only multiple choice questions will be accepted. These quizzes may not be made up. Therefore, it is essential that you come to every class on time. The quizzes are given at the beginning of the class. Students arriving late may turn in their questions, but won’t be allowed to take the quiz.

If you wish to drop the course, please do so on or before the deadline. It is your responsibility to have the drop form signed and turned into the registrar before the deadline. Your professor will not submit a drop grade.

If you must miss an exam, make prior arrangements. No make-up exams will be given unless you contact me in advance! Homework assignments may be submitted to me by email or hardcopy in my mailbox prior to class time. Late homeworks will be levied heavy penalties. Penalty: One day late 10%, 1 week late 20%, 2 weeks late 50%. Not accepted afterwards.

Student Integrity

Cheating of any kind will not be tolerated. Any assignment or exam that is handed in must be your own work. However, talking with one another to understand the material better is strongly encouraged. Recognizing the distinction between cheating and cooperation is very important.

All papers submitted must be your original work in your own words. If you paraphrase or quote another work word for word, the work must be cited.
If you copy someone else's solution, you are cheating. If you let someone else copy your solution, you are cheating. We will not distinguish between the person who copied a solution and the person whose solution was copied. Both people will be treated as cheaters.
If someone dictates a solution to you, you are cheating. Everything you hand in must be in your own words, based on your own understanding of the solution.
If someone helps you understand the problem during a high-level discussion, you are not cheating. We strongly encourage students to help one another understand the material presented in class, in the book, and general issues relevant to the assignments.
When taking an exam, you must work independently. Any collaboration during an exam will be considered cheating.
If you are caught cheating you will be given an F for the course. Further disciplinary action may be taken.

Final Note: If you have a documented disability which will make it difficult for you to carry out the work as I have outlined and/or if you need special accommodations/assistance due to the disability, please contact the Office of Services for Persons with Disabilities (OSPD), Emilia Ramirez-Schunior Hall Room 100 immediately. Appropriate arrangements/accommodations can be arranged.