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


Web Site URL:


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

ISBN: 978-0-4706247008


Textbook Site:

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.



CIS283 and knowledge of MS Windows and file management



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.