CIS405A –
Analysis and Logical Design I: Database
Instructor: Dr. M. Wang
Office: ST #609
Office Phone: (323) 343-2958
Office Hour:
E-mail: ming.wang@calstatela.edu
Web Site URL: http://www.calstatela.edu/faculty/mwang3/
Textbook: Database Systems: Design, Implementation, & Management, By Peter Rob & Carlos Coronel, Course Technology, Sixth Edition, 2004. ISBN: 0-619-21323-X
Software Tools: Oracle
Course Description:
An introduction to data modeling using entity-relationship analysis; relational
database concepts; normalization; SQL query language and the role of database
in information systems. The course will cover the process of database
development and implementation. Projects will reflect real-life problem-solving
skills in the database world.
Prerequisite:
CIS283/CIS284 and knowledge of MS Windows and file management
Objectives:
After successful completion of this course the student should be able to:
¾
Understand
the database architecture and development process.
¾
Understand
entity-relationship model and normalization.
¾
Design
and develop a relational database
¾
Query
a relational database with the SQL language
¾
Understand the concepts of data warehouse and
database in e-commerce
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.