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.