CSCI 6950 Advanced Database Design and Administration
Alina Lazar, CSIS, Youngstown State University, Fall 2012
301 Meshel Hall
5:10 - 6:25, Tuesday and Thursday
CSIS 3722 with a grade of C or better.
322 Meshel Hall
T R: 12:00 - 2:00 and 4:10 – 5:10, W: 11:00 - 12:00 or by appointment
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.
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
Fundamentals of Database Systems, by Ramez Elmasri and Shamkant B. Navathe, 6th Edition, Publisher: Addison-Wesley, 2011, ISBN: 0013608620.
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
- CSIS Oracle account
- Access to Blackboard
- SQLDeveloper and SQLModeler
Calendar and Schedule
Course and Databases Overview
Chapter 1 and 2
Data Modeling Using the ER Model
09/03 – Labor Day
The Relational Data Model
Review and Final
09/27 Midterm 1
Query Formulation with SQL
Advanced Query Formulation
Normalization of Relational Tables
Normalization of Relational Tables
Review and Midterm
11/01 Midterm 2
Chapter 13 and 14
11/11 Veteran’s day
Physical Database Design
11/22 & 11/23 Thanksgiving
Tuesday 5:30 – 7:30 PM
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.
Midterm 1 - 09/27/2012, Thursday
Midterm 2 – 11/01/2017, Thursday
Grading will be based on the weighted average scores as follows:
Homework assignments (6):
Midterm Examination (2):
Letter grades will be based on the weighted average score according to the following:
900 - 1000
800 - 899
700 - 799
600 - 699
Less than 599
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.
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.
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.
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.
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