Catalog Description:

CET 4429 Applied Database II

(3 credits) A study of a hierarchical database system, with the emphasis on the implementation of database management.

Course pre-requisites: CET 4427

Goals/Objectives of the course:

The primary purpose of this course is to provide students with the capabilities to optimize database querying and create user interface through the .NET Framework, which will provide the students with an in-depth understanding of the development of an enterprise modern database system that interact with the Symantec web.

Course Outcomes:

CO1:

• Students will be able to design and optimize a database.

CO2

• Students will be able to create user interface to manage and update the database.

CO3

• Students will be able manage transactions and concurrent database users.

CO4

• Students will be able to use databases and database tools to assist with decision support.  

Textbook:

David M Kroenke, Database Processing Fundamentals, Design, and Implementation, Tenth Edition, Prentice Hall, 2005

References:

Professional SQL Server 2005 Administration, Brian Knight (et.al.), Wiley Publishing, Inc. 2007

Topics Covered:

1.       Database Concepts Review

2.       Transaction and Concurrency Management

3.       Database Standards

4.       Database User Interfaces

5. Decision Support and OLAP Systems

Computer Usage:

Students are required to use word processing, spreadsheets, MS Access, SQL Server, Structured Query Language.

Laboratory Exercises:

To program using SQL language a database management program

Required Equipment:

Server Machines

Course Grading:

Course Grading Policies;

A = 90-100

B = 80-90

C = 70-80

D = 60-70

F = Below 60

Library Usage:

Students are encouraged to consult library and Internet references to aid in researching course material, complete written projects, and prepare oral presentations.

Course Assessment:

Assignments                                45%

Project                                          40%

Final Exam                                    15%

Course Policies:

Grading Objections:

All objections to grades should be made IN WRITING WITHIN ONE WEEK of the work in question. Objections made after this period has elapsed will NOT be considered, no exceptions.

Professionalism and Ethics:

Academic dishonesty in any form will not be tolerated!!! Violations of student academic behavior standards are outlined in The Golden Rule, the University of Central Florida's Student Handbook. See ttp://www.goldenrule.sdes.ucf.edu/ for further details.

Per university policy and plain classroom etiquette, mobile phones, pagers, etc. MUST be silenced during all classroom lectures and exams. Those not heeding this rule will be asked to leave the classroom immediately so as to not disrupt the learning environment.

Additional Course Information, Policies and Expectations:

Computer Skills/Usage

• WebCT and e-mail will be used to communicate with students and disseminate materials and assignments throughout the course. So LIVE and FEEDS students should check WebCT and their e-mail at least once per day.

• Students are expected to have access to and be familiar with a word processing application (e.g., Microsoft Word) as all assignments will require its use.

• Students are expected to have access to and be familiar with windows operating systems (XP, Server 2003), and how to install and uninstall software packages

Course Assignments

  • All assignments are due on or BEFORE the scheduled due date and time. Absolutely NO late assignments will be accepted.

  • All assignments must be submitted via WebCT, unless specified otherwise.

  • All assignments must be submitted in a high-quality and professional manner. They should be well-written and understandable. The steps/methods of solving the problems should be clearly stated.

  • Students are encouraged to collaborate outside of class to discuss and debate course concepts. However, all assignments MUST be completed and written up individually. Each student is required to turn in his or her own solutions. If the assignment has been designated a team assignment by the instructor, one copy of the assignment solutions containing the names of all team members is required.

Exams

All exams will be online. If students have problems taking the exam for any reason, they need to get in touch with instructor via email or provided phone number in the syllabus document.

Excusal from Course Assignments and Exams

• Excusal from submitting an assignment on-time:

- If an emergency arises and a student cannot submit the homework on or before the due date, the student MUST give notification to the instructor NO LESS THAN 24 HOURS BEFORE the due date and NO MORE THAN 48 HOURS AFTER the due date.

• Excusal from an exam:

- Excusal of a student from an exam due to an emergency such as student illness, family illness or death, etc. requires valid and provable documentation before the student is eligible for the makeup exam. The documentation must be given to the instructor  NO LESS THAN 24 HOURS BEFORE the due date and NO MORE THAN 48 HOURS AFTER the due date.

- Notification must be given to the instructor NO LESS THAN 24 HOURS BEFORE the scheduled exam for all other excuses such as conference/workshops, business trips, etc.

Makeup Assignments and Examinations

• There will be no makeup assignments given.

• Makeup exams will be given towards the end of the semester, at a date announced by the instructor. The makeup exams may be different and more challenging than those administered on the original date.

Course Coordinator:

Ron Eaglin, Associate Professor , reaglin@mail.ucf.edu