Course Details
Course Code: INFO171 Course ID: 4450 Credit Hours: 3 Level: Undergraduate
This course is a study of data modeling and database design. It applies the relational database model to construct Entity Relationship (ER) diagrams using ER Modeling. Through a study and application of the American National Standards Institute (ANSI) Standard Structured Query Language (SQL) constructs the course introduces data definition (create, alter, drop), data manipulation (insert, update, delete), and transaction control (commit, savepoint, and rollback), and defining, altering, and deleting primary keys, foreign keys, and constraints. Students must have access to Oracle software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site.
Course Schedule
Current Syllabi
At the conclusion of the course, participants should be able to:
At the conclusion of the course, participants should be able to:
- Describe the role of databases and database applications
- Apply data modeling techniques using the entity-relationship model (ERM)
- Analyze the Extended ER Model and normalization in database designs
- Interpret the functions of Oracle Database
- Integrate SQL syntax in Database application
- Identify the difference between DML,DDL and TCL query statements
- Detailed instructions for weekly assignments are found in Appendix A.
- Refer to the e-classroom instructions (Appendix B) to find out how to upload assignments, participate in online Discussion Board discussions, and take exams.
Submit all assignments & Labs (except Discussion Board answers and Quizzes) in Assignments section
Assignment Requirements
Discussion Board Introduction
You are required to introduce yourself to your classmates in an online discussion. Additional discussion board topics may be added to clarify issues.
Competency
You will be required to complete assigned work and upload them in Assignments.
There is a Final Exit Exam (non-proctored, open-notes) based on Final Assignment, Final Lab and Final Quiz. This Final Exit Exam will be based on Week 1 through Week 6 Activities
Name | Grade % |
---|---|
Final Assignment & Lab | 24.00 % |
Week 8: Final Lab | 12.00 % |
Week 8: Final Assignment | 12.00 % |
Weekly Assignments[5-7] | 18.00 % |
Week 5: Assignment 5 | 6.00 % |
Week 6: Assignment 6 | 6.00 % |
Week 7: Assignment 7 | 6.00 % |
Weekly Lab Work[5-7] | 18.00 % |
Week 5: Lab 5 | 6.00 % |
Week 6: Lab 6 | 6.00 % |
Week 7: Lab 7 | 6.00 % |
Weekly Lab Work[1-4] | 16.00 % |
Week 2: Lab 2 | 4.00 % |
Week 3: Lab 3 | 4.00 % |
Week 4: Lab 4 | 4.00 % |
Week 1: Lab 1 | 4.00 % |
Weekly Assignments[1-4] | 16.00 % |
Week 2 : Assignment 2 | 4.00 % |
Week 3: Assignment 3 | 4.00 % |
Week 1 : Assignment 1 | 4.00 % |
Week 4: Assignment 4 | 4.00 % |
Weekly Forum | 8.00 % |
Week 1 Forum | 2.00 % |
Week 3 Forum | 2.00 % |
Week 5 Forum | 2.00 % |
Week 7 Forum | 2.00 % |
Book Title: | Oracle Database 12c - Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html |
ISBN: | Software Note |
Book Title: | Database Systems: Design, Implementation, & Management, 11th Ed - the VitalSource e-book is provided inside the classroom |
ISBN: | 9781285196145 |
Publication Info: | VS-Cengage |
Author: | Coronel/Morris |
Unit Cost: | $219.71 |
Electronic ISBN: | 9781305217164 |
Electronic Unit Cost: | $32.00 |