| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

FrontPage

This version was saved 8 years, 2 months ago View current version     Page history
Saved by Nabeel Yousef
on January 4, 2016 at 7:03:59 pm
 

Welcome to COP4708 - Applied Database I

 

This courses addresses design and implementation of database systems within the concept of central administration, structured data storage. In addition this course addresses data manipulation 

Course pre-requisites: COP2220, or COP2001 or COP2800  (or equivalent)

 

Instructor

 

 

 

 

 

 

Dr. Nabeel Yousef

Professor and Fulbright Scholar

School of Engineering Technology

Daytona State College

Email: yousefn@daytonastate.edu

Phone: (386)506-4123

 

http://daytonastate.edu/CampusDirectory/empinfo.jsp?id=7823985769276911 

 

 

Course Outcomes

 

By the end of the semester students should be able to:

 

  • Apply the fundamentals of databases, and database management systems.
  • Design, normalize, and implement database systems.  
  • Describe common security models of database management systems 
  • Manipulate databases using database management tools and products.
  • Identify common security concerns in database management systems 
  • Apply security principles to the design and development of database systems and database structures

 

Course Information

  

COP4708 Syllabus.pdf

COP4708 Schedule.pdf

 

 

 

  

Textbook

 

David M Kroenke, Database Processing Fundamentals, Design, and Implementation, 12th Edition, Prentice Hall, 2011 ISBN 978-0132145374

 

The text book can be used in both COP4708 and COP4709

I am working on eliminating the text book and provide an electronic copy of the required material

 

Course Management

 

The course will be online based and will be offered through Florida Online Portal (online.daytonastate.edu).

  • Your Home Page will display the different courses that you have for this semester, clicking on the course link will take you to the course home page.
  • Course home page includes various tabs that will contain different course material
  • Florida Online e-mail will be used to communicate with students
  • Florida Online will be used to disseminate instructional materials and some assignments throughout the course.
  • Students should check Florida Online and their e-mail at least once per day. 
  • When sending e-mail to the instructor, please begin the “Subject:” of the message with the following: “COP4708” to identify the course of inquiry 

  • Check the news widget on a daily basis to get the latest updates

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

  • The use of the discussion board is highly encouraged. Please limit the use of the discussion board strictly to class issues.

  • In addition students will be suing spreadsheets, MS Access, Structured Query Language, MS Visio, MySQL Workbench 5.2, and Oracle. The following information will assist you obtaining these software packages:

 

 

Announcements

 

Welcome from Professor Yousef 

 

Welcome to Online COP4708 Applied Database I 

My name is Professor Yousef and I will be your instructor for this course. Please feel free to contact me vie e-mail at yousefn@daytonastate.edu.

Below you will see some links to course material. Please take the time to view, read and understand all of the provided material. 99% of all questions students have pertaining to this course are addressed in the Syllabus so please take the time to read through that document.

 

Welcome Video

 

Office Hours 

  

T 9:30 am - 3:30:00 pm (ATC Bldg, Room 107Q)

R 9:30 am - 11:30 am (ATC Bldg, Room 107Q)

R 1:30 am - 3:30pm (ATC Bldg, Room 107Q)

W 12:30 pm - 4:30 pm (Virtual hours Skype ID: professor.yousef)

 

Ice Breaker

  

Please take a moment to go to the discussions tab at Florida Online, click on "What is a Database Management System?" topic and share your understanding to that system with the class. Your posting is worth 10 points. Here is how your posting will be graded:

10 points: posted by the due date and contains your personal opinion

5 points: one day late or lacks your personal comments

0 points: more than one day late

 

Resources

The following links are very useful resources:

 

 

Major Topics Covered in This Course

 

  • Introduction to Database and Database Management Systems
  • Relational Databases and Normalization
  • Database Design Using Normalization
  • Data Modeling and database Vulnerabilities
  • Hashing and Encryption
  • Database Controls
  • Information Flow and Database Security Models
  • Transforming Data Models and Security Measures into Designs
  • Structured Query Language (SQL)
  • SQL for Applications
  • Managing Database with Oracle
  • Database Redesign
  • Managing Multi-user Database: Security issues and common DBMS Vulnerabilities    

                                          

Course Lectures 

 

Click here to access course Lecture Notes and Videos

 

The course video lectures are short MP4 videos that addresses the different course topics. For efficient lecture viewing I suggest you download the lecture to your hard drive and watch the lecture at your own convenience. You can pause, rewind, forward the video as needed.

 

Watching the course lectures and reviewing the course material will not make you an expert in databases. You need to practice as much as possible. If you have any additional questions please feel free to email me, call me, or come to my office at any time during office hours.

 

Assignments 

Assignment 1: The purpose of the assignment is to introduce students to basic databases that are saved as spreadsheets.

 

Assignment 2:The Purpose of this assignment is develop a database model with different security measures to address database vulnerabilities

 

Assignment 3: The purpose of this assignment is to introduce database hashing and encryption and database controls 

 

Assignment 4: The purpose of this assignment is to write a code to create a fully functioning database with views and records. 

 

Assignment 5: The purpose of this assignment is to create a secured database with multi-user access (adding database controls and security requirements)

Project Assignments 

 

Project Assignment 1

Assignment summary: Using an organization forms and spreadsheets identify the different entities that this organization would like to track in their system. Then list the different characteristics/attributes for each entity and identify the attribute that can be used as identifier/determinant for each entity. List all possible functional dependencies for each entity.

 

 

Project Assignment 2

Assignment summary: After you identified the entities, their attributes, determinants, and the functional dependencies in this assignment you will develop the database model and database design. The model should address data vulnerabilities and include suggested data controls. In the design include the implementation of the database security measures.   

 

 

Project Assignment 3:

Assignment Summary: In this assignment you need to convert the design into actual code that can be implemented in any Database Management System. You will also insert rows, manipulate tables, add constraints and display information from different tables. In addition you will write a code to encrypt database and secure data. 

 

 

 

 

 

 

 

 

Comments (0)

You don't have permission to comment on this page.