Course Syllabus
Department of Mathematics and Computer Science, Lincoln University| COURSE ID: | CSC-354 |
| COURSE NAME: | Database Management |
| CREDITS: | 3 |
TEXT BOOK
Modern Database Management, Eight Edition; by Mary B. Prescott, Fred R. McFadden, and Jeffrey A. Hoffer.
INSTRUCTOR INFORMATION
***To be provided for each section***
COURSE DESCRIPTION
This course will introduce students to the principles of single and multiple applications of database systems. In addition, it will develop graphical and logical skills that are used to construct logical models of information handling systems. Topics include normalization and removal of data redundancies, insertion, deletion, and update anomalies; logical and physical views of data, the entity-relationship model, data description and data manipulation languages, relational, hierarchal, and network approaches, as well as data security and integrity and database processing for the web.
PREREQUISITE CSC-254 (Data Structures)COURSE GOALS- STUDENT LEARNER OUTCOMES
The student should
- Learn the underlying data structures needed for database processing and management.
- Learn the fundamentals of database development process.
- Be able to utilize E-R (Entity-Relationship) and enhanced E-R data models in database design.
- Be able to apply normalization steps in database design and removal of data anomalies.
- Be able to use a database management system product such as MS ACCESS.
- Become proficient in using SQL language
- Learn about client/ server applications.
- Learn about Internet database-enabled connectivity.
TENTATIVE SCHEDULE OF WEEKLY ASSIGNMENTS
Reading Assignment:
WEEK 1
. Introduction to Database Environment & Database Development Process (Chapter 1-2)
WEEK 2-7
. Modeling Data, including but no limited to E-R & Enhanced E-R and Business Rules (Chapter 3-4)
. Logical Database Design and the Relational Model, including but not limited to Normalization & Mapping ER into tables (Chapter 5)
. Advanced Normal Forms (Appendix B)
WEEK 8-15
. SQL (Chapter 7-8)
. The Internet Database Environment (Chapter 10)
. Data Warehousing/ Database Administration including security & Encryption (Chapter 11-12)
Topics Covered:
. Components of a database system
. MS Access including VBA coding
. Data structures used in database processing
. Database analysis
. The entity-relationship model
. The Enhanced E-R Model and Business rules
. Database Design
. The relational model
. Normalization and removal of data redundancies and insertion, deletion, and update anomalies
. Database implementation
. SQL language
. Hierarchical and network models
. Client/Server architectures
. Administration including database security and reliability
. Internet applications of database and information management
Approximate Tests and Projects Schedule:
. One Practical Test (on the computer) approximately week 6
. One Written Test during the midterm week
. One Written Test approximately week 12
. A presentation of Case Study Data Base Project approximately week 13
. The final exam is written and is administered during the official university final schedule period.
COURSE ASSESSMENT- LEARNING OPPORTUNITIES*
-
Computer Projects
Computer Projects will be given on material covered in class. General computer labs are available throughout the campus for students to do their work. The students are encouraged to make regular visits during office hours, to meet in study groups, and to use the Computer/ Programming Tutors from the School of Natural Sciences.
-
Late Work And Make-Ups
All computer projects, assignments, quizzes and exams must be completed by the scheduled date. Late assignments or make-up tests or quizzes will only be allowed with official documentation and grades may be lowered. To qualify for a make-up, a student must have notified the professor and rescheduled in a timely manner.
GRADING STANDARDS- ASSESSMENT TOOLS
The grades will be evaluated based on the practical and written tests/ quizzes as follows.
| Projects | 20% |
| Final project presentation | 5% |
| Tests | 75% |
| Practical test (on the computer) | 50 points |
| First written Test | 100 points |
| Second written Test | 100 points |
| The final exam (written) | 100 points |
The grading scale guideline: **
| A | 92-100% |
| A- | 88-91% |
| B+ | 85-87% |
| B | 82-84% |
| B- | 78-81% |
| C+ | 75-77% |
| C | 72-74% |
| C- | 68-71% |
| D+ | 65-67% |
| D | 58-64% |
| F | 0-57% |
UNIVERSITY POLICY
1) Attendance:
Lincoln University uses the class method of teaching, which assumes that each student has something to contribute and something to gain by attending class. It further assumes that there is much more instruction absorbed in the classroom than can be tested on examinations. Therefore, students are expected to attend all regularly scheduled class meetings and should exhibit good faith in this regard. For the control of absences, the faculty adopted the following regulations:
- Four absences may result in an automatic failure in the course.
- Three tardy arrivals may be counted as one absence.
- Absences will be counted starting with whatever day is specified by the instructor but not later than the deadline for adding or dropping courses.
- In case of illness, death in the family, or other extenuating circumstances, the student must present documented evidence of inability to attend classes to the Vice President for Student Affairs and Enrollment Management. However, in such cases the student is responsible for all work missed during those absences.
- Students representing the University in athletic events or other University sanctioned activities will be excused from class (es) with the responsibility of making up all work and examinations. The Registrar will issue the excused format to the faculty member in charge of the off- or on-campus activity for delivery by the student(s) to their instructors.
Students are responsible for proper conduct and integrity in all of their scholastic work. They must follow a professor's instructions when completing tests, homework, and laboratory reports, and must ask for clarification if the instructions are not clear. In general, students should not give or receive aid when taking exams, or exceed the time limitations specified by the professor. In seeking the truth, in learning to think critically, and in preparing for a life of constructive service, honesty is imperative. Honesty in the classroom and in the preparation of papers is therefore expected of all students. Each student has the responsibility to submit work that is uniquely his or her own. All of this work must be done in accordance with established principles of academic integrity.
An act of academic dishonesty or plagiarism may result in failure for a project or in a course. Plagiarism involves representing another person's ideas or scholarship, including material from the Internet, as your own. Cheating or acts of academic dishonesty include (but are not limited to) fabricating data, tampering with grades, copying, and offering or receiving unauthorized assistance or information.3) The Student Conduct Code:
Students will be held to the rules and regulations of the Student Conduct Code as described in the Lincoln University Student Handbook. In particular, excessive talking, leaving and reentering class, phones or pagers, or other means of disrupting the class will not be tolerated and students may be asked to leave. Students who constantly disrupt class may be asked to leave permanently and will receive an F.
4) The Core Curriculum Learner Competencies:All courses offered through the Department of Mathematics and Computer Science require students to meet at least the following out of the 8 Core Curriculum Learner Competencies:
(1) Listen and effectively communicate ideas through written, spoken, and visual means;(2) Think critically via classifying, analyzing, comparing, contrasting, hypothesizing, synthesizing, extrapolating, and evaluating ideas;
(6) Apply and evaluate quantitative reasoning through the disciplines of mathematics, computational science, laboratory science, selected social sciences and other like-minded approaches that require precision of thought;
(8) Demonstrate positive interpersonal skills by adhering to the principles of freedom, justice, equality, fairness, tolerance, open dialogue and concern for the common good.
Note:
* The instructor of a given section of the course may make some modifications to the evaluation as well as to the rest of the syllabi including but not limited to; the grade weights, number of tests, and test total points.
**The grading scale guideline includes a 2-point flexibility.
Please consult with the department chairperson for any program updates or corrections which may not be yet reflected on this page _ last updated 11/20/2007.
|
Lincoln University of the Commonwealth of Pennsylvania |