Close browser 

Home  

Syllabus 
Objective 
Instructors 
Class Hours 
Lab Hours 
Prerequisites 
Textbooks  
Grading 
Important Dates 
Attendance 
Web Conferencing
Exams 
Academic Honesty & Ethics 
Tentative Schedule 
Lab Schedule 
Assignment Submission  Schedule 

Assignments/
Project  

Labs 

Lecture Notes  

Other Resources

Download the syllabus                           

Objective

This is an introductory course in database and file management systems.  It will help students to develop an understanding of the role of data modeling, file management and database systems in information systems.  At the completion of this course, you should:

•       Develop an appreciation of the role of data, files and databases in information systems.

•       Understand the database development activities during the System Development Life Cycle (SDLC)

•       Be familiar with data modeling concepts (E-R and Class diagrams) used in database development.

•       Be able to create databases and pose complex SQL queries of relational databases.  

•    Develop an appreciation for several DBMS's (ACCESS, SQL Server and ORACLE)

•       Be familiar with a broad range of data management issues including data integrity and security. 

•   Utilize a CASE tool for data modeling and schema creation.

Instructors

Class Hours  

Lab Hours 

Prerequisites 
CIS 1048 Introduction to IS&T
CIS 1073 (81): Computer Programming and Higher Level Language
If you are registered for this course, but do not meet the pre-requisite, contact the instructor immediately.  Students who have not completed the pre-requisites will not be awarded a grade for this course.

Textbooks 
Modern Database Management,  by Jeffrey A. Hoffer, Mary B. Prescott and Fred R. Mcfadden. Published by Prentice Hall.

Lab Notes  posted on the web. Use the link on the right. Password is required.

Grading 

Assignments, lab projects and schedules will be available from the course web site.  Students are expected to view/download the assignments and lab projects.  Thus, students should make it a point to visit it frequently.  Failing to check the course web site is not an acceptable excuse for late submission, or missing exams.  Late submissions, unless permitted, will not be accepted. The 'others'  portion of the grade will is subjective, reflecting class participation, effort, individual contribution to the project and significant improvement during the semester.

Assignments & Quizzes
There will be several assignments.  It includes, data modeling and SQL projects. The assignments have to be submitted at the beginning of class on the due date.  In addition there may be announced or unannounced quizzes/assignments. 

Lab
Attendance is REQUIRED. During each Lab session you will be expected to do the assignments listed in the Lab schedule bellow. Your work and progress will be reviewed and evaluated at designated milestones.

Project
Each group of students will select a project which they will work on through the semester. It involves the design of the database, forms, reports and a switchboard for a 'real life' system of their choice.

Grading Scale
Grading is expected to be on the following scale:

This is just a guideline, the final grading may slightly differ from this scale.
NOTE: The minimum passing grade for the course is "C". 

Important Dates 
Students should regularly visit this website and also the course web conferencing site at http://tuportal.temple.edu for all announcements.  Some important dates are…

Attendance 
Attendance is expected, and may be recorded from time to time.  Absences for legitimate professional activities and illnesses are acceptable only if prior notice is given to the instructor by e-mail or phone.  Scheduling conflicts with your work, extra-curricular activities, or any other such activities is not a valid excuse.  Also, review Temple University attendance policy at http://www.temple.edu/ugbulletin97/policies_part1.html#attendance.  Although attendance is not a specific part of the course evaluation it has a direct effect on class participation.  If you are not in class you cannot participate. 

Attendance and class participation will be taken into account in final grading, namely, the 'Others' portion of the grade . Class participation means that you attend class regularly and have completed your assigned readings.  It means that you ask relevant questions and make informed comments in class. 

Web Conferencing 
We use a web conferencing tool:  Temple's Black Board for outside class interaction. You will need to get a password from Computer Services to log on to this site.  The site can be used as a message board and also as a discussion forum where you may post comments/questions about the course, assignment, projects or any other relevant matter.
Please note that this forum is strictly for discussion on the course content, assignments and projects. All maters of class policy should be addressed directly to the instructor. I do not expect to moderate the forum, however I will intervene if I feel the need to redirect the focus back on the course.

Exams 
Exams will be in class and in the lab.  They may include application/problem solving questions, short answer and/or a  combination of multiple choice.  You will be notified whether the exam will be open book and open notes.  The content for exams is cumulative, i.e. all material covered up to the day of exam may be included.  Exams will generally be based on material covered in class, but not necessarily restricted to it.  There will be no make up exams.  

Academic Honesty & Ethics
Temple University, the school, the department and I expect you to observe the highest ethical standards. Simply put, we count on you to do the right thing. You are expected to always do your own work. When working in the lab, on your assignments or the team project you may consult others or you study as a group but always submit your own original work.  All violations of academic honesty will be handled according to university policy.  

Disability Disclosure
Any student who has a need for accommodation based on the impact of a disability should contact me privately to discuss the specific situation as soon as possible. Student must provide me with a note from the office of Disability Resources and Services at in 100 Ritter Annex, 215-204-1280, regarding their disability. 

Tentative Schedule 
This is a tentative outline of when the various topics will be covered.  You are expected to have read the designated chapters prior to attending the class. 

Lab Schedule 
Scheduled labs for this course are based on the enclosed lab material.  This is a tentative session schedule, check later for a final schedule.  The labs are mainly self-directed with help from Lab assistant to answer questions and solve problems.  The labs are not meant for instruction or completing assignments. To derive maximum mileage from the labs you should read the sessions designated ahead of time.  You are expected to be thoroughly familiar with usage of Windows operating systems.

    Click here for the lab instructions
    Click here to download the demo Furniture Co. database
   
Assignment Submission Schedule (Tentative)

Last Updated
Tuesday, January 18, 2011