Course Number: CIS 3306
Course Title: Data Files and Databases
CRN: 30130
Instructor: Dr. R. Robbins
Office Hours: By appointment
Phone: 713-221-8594
email: robbinsr@uhd.edu
Technical Assistance with Vista: 713-221-8540, option 4

Course Description

This course introduces the development of computer-based systems to manage business data.  The organizational context of database management, concepts of data modeling, and database design are presented.  Data file management, database implementation and data retrieval using query languages and graphical user interface are introduced.  Database administration issues are discussed and new database technologies are introduced

PREREQUISITE: Prerequisite(s) ARE NOT optional, pre-requisites ARE requirements or courses that must be completed PRIOR to taking the course.  The pre-requisite(s) for this course are described in the UHD catalog course description as: Completion of the common core plus 18 additional hours and a grade of C or better in CIS 3301 and CIS 3302 are required.   

Upon completion of the prescribed work for this course, the student should be able to:

1. Define the components and terms used in database management systems;  this includes file systems, the relational model and an introduction to the Structured Query Language
2. Design a database system this includes entity relationship modeling, normalization of database tables, database design, and conceptual design
3. Implement the design of a database system this includes the design of a relational system utilizing SQL
4. Become familiar with the SAP database utilizing a tutorial which will introduce you to the basic navigation skills for SAP
5. Be familiar with some advanced tools used for database development and online database development
6. Be familiar with the utilization of databases in newly emerging areas such as: object-oriented databases, client/server systems, and data warehouses

Course Content

• File Systems and Databases
• Data Models
• The Relational Database Model
• ER Modeling
• Designing Databases with Visio Professional  AND Normalization
• SQL
• Database Design
• Transaction Management and Concurrency Control
• Distributed Database Management Systems
• The Data Warehouse
• Database Connectivity and Web Development
• Database Administration

Database Systems: Design, Implementation, & Management (7th edition) Rob, Peter and Coronel, Carlos. 
ISBN:  1-418-83593-5  

Software: Visio Professional 2003

Policies

STATEMENT OF REASONABLE ACCOMODATION:
"UHD adheres to all applicable federal, state, and local laws, regulations, and guidelines with respect to providing reasonable accommodations for students with disabilities. Students with disabilities should register with Disabled Student Services and contact their instructor(s) in a timely manner to arrange for appropriate accommodations. "

UNIVERSITY POLICIES:
All students are subject to UH-Downtown’s Academic Honesty Policy and to all other university-wide policies and procedures as they are set forth in the UH-Downtown University Catalog and Student Handbook.

ACADEMIC HONESTY POLICY:
The University Academic Honesty Policy will be strictly enforced. A good source of information to help you understand what constitutes plagerism can be found on the UHD Library website. In brief, PLAGIARISM (copying ideas, writings, etc. of another and passing them off as your own) is cheating. Any student suspected of violating this policy will be treated in accordance with the provisions of the Academic Honesty Policy found in the UHD Student Handbook. Please read the Academic Honesty Policy carefully. Any violation of this policy may result in an “F” for the course.

The system you will use to access this online course is Blackboard Vista. Students are expected to have computer access on a daily basis to successfully complete this course. Note: If you plan to access the course from work, try connecting early in the course. Some businesses have very rigid settings on their firewalls that do not allow participation in activities such as chat, or the interactivity necessary to take a quiz online.
Internet Service Provider - this course is done via connection through the internet. If you are going to work on your class from home, you must have DSL or cable modem line to guarantee solid high-speed access and optimal performance of the course program.

Blackboard Vista help is available, students should call 713-221-8540 and select option 4.