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: http://www.calstatela.edu/faculty/mwang3/
Textbook: Fundamentals of Database Management Systems by Gillenson, Wiley.
Software Tools: Oracle Enterprise Server, Access, Visio and SAP ERP
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
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:
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%
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.