• Home
• Teaching
• Research
• Service
• Contact Us

CSCI 6950 Advanced Database Design and Administration

Alina Lazar, CSIS, Youngstown State University, Fall 2012

Course Information

Instructor Information

Course Description

Design, development, implementation, and administration of large database systems at the enterprise level, including logical data models, data security and assurance, concurrent processing, data distribution, data marts, data warehouses, data mining, and data extraction, cleansing, and loading.

Management of large, complex databases involves technical skills and background needed by information systems professionals as well as tactical and strategic issues faced by information technology managers. This course provides conceptual knowledge, practical skills, and policy background for prospective information systems professionals and information technology managers. The course covers conceptual and product material about database modeling, integrity, index structures, query optimization, transaction management and physical implementation.

Objectives

By the end of this course, the student should be able to:

- Construct a conceptual DBMS.

- Develop a set of normalized database tables.

- Write SQL queries to extract data from the database.

- Define and explain the basic structures of relational databases.

- Compare and contrast centralized, distributed, and client-server database architectures.

- Discuss and apply issues of concern in database administration.

- Design and develop a database and end-user application with appropriate forms, reports, and queries.

Textbooks and Course Materials

Required Reading

Fundamentals of Database Systems, by Ramez Elmasri and Shamkant B. Navathe, 6th Edition, Publisher: Addison-Wesley, 2011, ISBN: 0013608620.

Recommended Reading

Any additional Database textbook, especially:

Head First SQL: Your Brain on SQL, by Lynn Beighley, 1st Edition, Publisher: O’Reilly, 2007, ISBN: 0596526849. Lecture Notes posted on Blackboard every week.

Software and Others

1. CSIS Oracle account
2. Access to Blackboard
3. SQLDeveloper and SQLModeler

Calendar and Schedule

Readings

Reading assignments from the textbook will be posted every week on Blackboard together with the lecture notes.

Assignments and Project

Six homework assignments are required. The assignments provide practice with database tasks using Oracle. The assignments cover table creation, procedures, triggers, materialized views. You will submit your assignments through the YSU Blackboard website.

All assignments are individual efforts.  On individual assignments, you can consult with your classmates on conceptual issues, but you should not share your answers with your classmates. It is important that you acquire individual problem solving skills so that you will be able to contribute productively in group settings. You may work in a small group for the case study project.

Exams

Midterm 1 - 09/27/2012, Thursday

Midterm 2 – 11/01/2017, Thursday

Final Exam - 12/11/2012 Tuesday 17:30 - 19:30

Polices

Grading

Grading will be based on the weighted average scores as follows:

Letter grades will be based on the weighted average score according to the following:

Attendance

Attendance and participation in class is very important. In addition to the normal lecture material, information will be given regarding assignments, due dates, explanation, and clarification of assignments, and material that is not covered in the assigned text. If you miss a class for any reason, it is your responsibility to become familiar with the material covered. It is also your responsibility to check the course website on a regular basis.

Missed Exams

There is no make-up for midterm exam. Missing an exam will greatly affect your grade since they carry a lot of weight. In case of illness or abnormal circumstances, please consult with the instructor in advance if possible to make alternate arrangements. You must formally inform the instructor in writing and present proper supporting documents within a week from the midterm. All students are required to write and pass the final exam in order to pass the course.

Missed Assignments

An assignment is late if it is not submitted at the beginning of class on the due date. Assignments that are submitted late will receive a 10% deduction in points available for each day an assignment is late.  Assignments submitted after the start of a class period on the due date are considered 1 day late.  Weekend days also count as late days.  After 10 days, a late assignment can no longer be submitted unless you have a very good excuse, e.g., Doctor's Excuse.

Example #1: An assignment is due on Tuesday.  You don't submit it until Thursday.  The assignment is 2 days late – you will be assessed a penalty of 20% of the points available.

Example #2:  An assignment is due at the beginning of class, but you submit it sometime later that same day – the assignment is late and you will be assessed a penalty of 10% of the points available.

You must allocate enough time to complete the assignment on time. 

Academic Honesty

You are required to do your own work on all homework. There are no group assignments, and since these assignments count toward your grade, the work must be yours. If you need help with an assignment, your primary source of help should be the instructor. You are, however, permitted to discuss an assignment with others, but are not allowed to share source code, ideas, or design charts in any way, shape or form. Identical assignments will get zero grades and will result in failure of the course.

Changes in the Syllabus

Instructor reserves the right to change syllabus, dates, test dates and procedures, class procedures, etc., as necessary.

Disability Services

In accordance with University procedure, if you have a documented disability and require accommodations to obtain equal access in this course, please contact me privately to discuss your specific needs. You must be registered with the CSP Disability Services, which is located at Wick House, and provide a letter of accommodations to verify your eligibility. You can reach CSP Disability Services at 330-941-1372