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:
Assignment 5:
|
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.