| 
  • 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 11 years, 6 months ago View current version     Page history
Saved by Nabeel Yousef
on September 4, 2012 at 10:21:09 am
 

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,

 Associate Professor,

 School of Engineering Technology

 Office: 107F, Advanced Technology Center (ATC) 

 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.  
  • Manipulate databases using database management tools and products.  
  • Compare different database systems and choose the proper and most efficient system

 

Course Information

  

Course Syllabus

Course Schedule

Welcome Video

Syllabus Session

Agreement, Schedule and Ice Breaker Session

  

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:

 

Resources

The following links are very useful resources:

 

Announcements

 

Welcome Back from dr. Eaglin 

 

Welcome back to all students! Engineering Technology now has a student study area and library in ATC room 107 (big open area). This area has 4 large tables and outlets on the floor for charging laptops. We encourage all students who can take advantage of the ability to use the resources at the ATC - to please do so.

In addition we have tutor service in programming, math, science, and engineering available and also a tutor from the Writing Center (Tuesday only) at the ATC.

We wish all the students a best for a great semester and encourage all students to take full advantage of the resources available.

Dr. Ron Eaglin

Associate Vice President, College of Technology

 

Welcome from Professor Yousef 

 

Welcome to Online COP4708 Applied Database I V1.

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

 

Welcome Video

 

Office Hours 

  

T 9:30 am - 5:00 pm (ATC Bldg, Room 107F)

W 9:30 am - 11:30 am (ATC Bldg, Room 107F)

W 1:30 am - 5:00 pm (ATC Bldg, Room 107F)

R 12:30 am - 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

Major Topics Covered in This Course

 

  • Introduction to Database  and Database Management Systems           
  • The Relational Model and Normalization                                 
  • Data Modeling                                                                          
  • Transforming Data Models into Designs                                  
  • Structured Query Language (SQL)                                          
  • SQL for Applications                                                                
  • Managing Database with Oracle                                             
  • Database Design Using Normalization                                     
  • Database Redesign                                                                   
  • Managing Multi-user Database    

                                          

Course Lectures 

 

Click here to access course Video Lectures

 

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 an expert in databases. You need to practice as much as possible. If you have any additional questions please feel free to 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:

 

Assignment 3:

 

Assignment 4:  

Project Assinments 

 

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 1: click here to download

 

Project Assignment 2

Assignment summary: After you identifed the entities, their attribues, determinants, and the functional dependencies in this assignment you will develop the database model and database design. In the model you will create a rough graphical representation model that will represent each entity, their attribute and their relationship with each other. In the design you will convert each identifier into primary key, identify the data type, and data size for each attribute, In addition you need to identify the null/not null constraints.  

Project Assignment 2: click here to download

 

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.

Project Assignment 3: click here to download

 

 

 

 

 

 

 



Comments (0)

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