Catalog Description:

COP 4709 - Applied Database II

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

Course pre-requisites: CET 4708

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:

none 

References:

Web references will be given on course site.

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, Visual Studio.

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:

Weekly Assignments                                100%

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

• Florida Online e-mail will be used to communicate with students and disseminate materials and assignments throughout the course. 

• 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.

  • All assignments must be submitted via Drop Box, 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. 

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.

Makeup Assignments and Examinations

• There will be no makeup assignments given.

Course Coordinator:

Ron Eaglin, eaglinr@daytonastate.edu