CIS405A – Analysis and Logical Design I: Database

Instructor: Dr. M. Wang

Office: ST #609

Office Phone: (323) 343-2958 (Direct) or (323) 343-2983 (CIS Department)

Office Hour: 4:30 – 6:00 p.m. WR

E-mail: ming.wang@calstatela.edu

Web Site URL: http://www.calstatela.edu/faculty/mwang3/

Textbook: Fundamentals of Database Management Systems by Gillenson, Wiley.

ISBN: 978-0-4706247008

Textbook Site: http://bcs.wiley.com/he-bcs/Books?action=index&itemId=0470624701&bcsId=7037

Software Tools: Oracle Enterprise Server, Access, Visio and SAP ERP

Course Description:

The course introduces relational databases and DBMS using data modeling; entity-relationship analysis; normalization and SQL as well as SAP Business Data Warehouse. The course will cover the process of database development, implementation and management. Projects will reflect real-life problem-solving skills in the database world.

Prerequisite:

CIS283 and knowledge of MS Windows and file management

Objectives:

After successful completion of this course the student should be able to:

1. Understand the database architecture and development process.

2. Understand entity-relationship model and normalization.

3. Design and develop a relational database with ERD

4. Query a relational database with the SQL language

5. Understand the concepts of data warehouse and database in SAP ERP

Instructional Procedures:

Classroom activities will consist of lecture, example demonstration and in-class exercises. The contents taught in class will be followed by homework assignments, projects and exams.

Assessment of Academic Achievement:

Assignments (20%)

Mid-terms (28%)

Project Part I: Database Design (8%)

Project Part II: Database Implementation (8%)

Final Exam (36%)

The final grade will be determined on the above performance.

Grading scale: A 90-100%, B 80-89%, C 70-79%, D 60-69%, F 0-59%

Class Policies:

Projects and Assignments: To receive full credit a project and an assignment must be completed on time on the due date. The late penalties will be assessed as follows:

Up to 24 hours after time due --- 25% penalty

Over 24 hours after time due --- 100% penalty

Tests: Exams are cumulative in nature for this technical class. Absence from a test is excused only in a personal medical emergency.

Class attendance: Class attendance is required. Important work will be done in class. Regular attendance will improve your performance.

Honor code: All students are expected to act with honor and integrity in completing their academic requirements. Dishonesty and cheating will not be tolerated. This behavior will result in an F (zero points) on that assignment and possible expulsion from the course (an F in the course). Any suspicious behavior will be addressed.

Class conduct: Common courtesy and respect of all people and property expected. Punctual arrival of the class required. NO cell phones or beepers in class.