| Course Title: | Developing and Managing Databases for Business Intelligence |
|---|---|
| Course Number: | BIAM530 |
| Course Description: | This course addresses designing relational databases and building large database applications, including tables, queries, forms, reports, and macros. Also addressed are implementing basic database security, backup and recovery procedures, the role of normalization, and meeting business requirements. Data warehousing, business analytics, implementation of data mining tools, data modeling, and decision trees are also examined. Case studies are used throughout the course. |
| Course Prerequisites: | N/A |
Syllabus
Course Information
Course Specific Requirements
Software: MS Office, MS Visio, MS SQL Server, IBM BigSheets and Apache Hadoop (provided via the IBM Bluemix platform)
See the Course Specific Resources under Course Home for more information on IBM Bluemix.
Software Citation Requirements
This course uses open-source software, and as the end users of this software, students are required to cite the software for any student work, such as assignments, labs, or projects, where the software has been utilized. Open-source software does have end-user license agreements, and all students should read the entire agreement for a software prior to installation or usage. In order to use the software in this course, software citations have been created for students and can be located on the Open Source Applications page. These software citations must be included in all student work submissions that have used the software.
Textbooks and Resources
Required Textbooks
The following books are required for this course:
Database Systems: Design, Implementation, and Management
11th Edition
by Carlos Cornel and Steven Morris
2015 Cengage
E-book Details
First Time Using VitalSource? Step 1: View the VitalSource Video Step 2: Register with VitalSource Bookshelf Online
Step 3: Access the Desktop and Mobile Versions | Already Registered? 3 Ways to Access Your eBooks
|
To find out more about VitalSource Bookshelf, check out the VitalSource FAQ.
Physical Books and Supplies
Your course may require additional materials, such as a course kit. Visit the online bookstore if you have not yet ordered your books and supplies.
Campus Additional Information
Enter content here, if necessary.
Terminal Course Objectives
DeVry University course content is constructed from curriculum guides developed for each course that are in alignment with specific Terminal Course Objectives. The Terminal Course Objectives (TCOs) define the learning objectives that the student will be required to comprehend and demonstrate by course completion. The TCOs that will be covered in detail each week can be found in the Objectives section for that particular week. Whenever possible, a reference will be made from a particular assignment or discussion back to the TCO that it emphasizes.
A
Given business needs to collect and utilize rapidly growing quantities of data in insightful ways, evaluate how modern data management and analysis technologies and methods have evolved to meet these needs.
B
Given a business project that requires data collection, storage, management, retrieval, and analysis, plan the project using an appropriate development life cycle model and methodology.
C
Given a business problem involving the storage and operational use of highly structured data at the enterprise level, design a relational database meeting the specified requirements.
D
Given a design for an enterprise-level relational database, examine how Structured Query Language (SQL) Data Definition Language (DDL) statements can be used to implement the design.
E
Given an implemented enterprise-level relational database, apply Structured Query Language (SQL) Data Manipulation Language (DML) statements to create, retrieve, update, and delete data to meet stated business intelligence requirements.
F
Given a business problem involving the long-term storage and analysis of highly structured data at the enterprise level, apply data warehouse concepts and technologies to satisfy present and anticipated future business intelligence requirements.
G
Given rapidly changing business needs and technological capabilities for data management, analyze the trade-offs associated with the adoption of emerging extensions in comparison to conventional database technologies.
H
Given the value of data to a business, prepare a report that outlines measures to be taken by a business to properly administer and protect an enterprise’s data assets.
I
Given a business problem involving large quantities of unstructured or semi-structured data, assess available alternatives to conventional relational database technologies that could be applied to the problem.
J
Given the value of data to a business and the need to perform business analytics on the data in the tables, evaluate Key Performance Indicators (KPI) to evaluate.
Lab Schedule
Week 1
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 2
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 3
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 4
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 5
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 6
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 7
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Week 8
None
Citrix
RKON
Skillsoft
Toolwire
WebServer
ACC COMAT
ACC NonCOMAT
CWP
Course Schedule
| Week, TCOs, and Topics | Readings and Class Preparation | Activities and Assignments |
|---|---|---|
| Week 1 TCO A Database Systems and Data Models | Chapter 1: Database Systems Chapter 2: Data Models | Homework Graded Discussion Topics |
| Week 2 TCO C Database Design | Chapter 3: The Relational Database Model Chapter 4: Entity Relationship (ER) Modeling Chapter 6: Normalization of Database Tables | iLab Graded Discussion Topics |
| Week 3 TCOs D and E Structured Query Language (SQL) | Chapter 7: Introduction to Structured Query Language (SQL) Chapter 8: Advanced SQL | iLab Graded Discussion Topics |
| Week 4 TCO B Database Life Cycle and Project Planning | Chapter 9: Database Design | Homework Graded Discussion Topics |
| Week 5 TCOs G and I Distributed Databases, Big Data, and NoSQL Databases | Chapter 12: Distributed Database Management Systems Chapter 14: Database Connectivity and Web Technologies | iLab Graded Discussion Topics |
| Week 6 TCOs F and J Business Intelligence, Data Warehousing, and Key Performance Indicators (KPIs) | Chapter 13: Business Intelligence and Data Warehouses | iLab Graded Discussion Topics |
| Week 7 TCO H Database Administration and Database Security | Chapter 15: Database Administration and Security | Homework Graded Discussion Topics |
| Week 8 All TCOs | Final Exam | |
Blended E-Learning
This course is an 8-week, intensive course that includes both classroom-based and e-learning activities. Your participation in both areas is essential to your success in this course. You should expect to spend time each week participating in the prescribed activities both before and after our class meeting.
Participation before, during, and after class meetings is critical to your success in this intensive environment.
To get the most out of our weekly class meetings, it is essential that you come to class prepared. The weekly readings listed in the Course Schedule will prepare you for class. Our class meetings, in turn, will prepare you for upcoming exams and assignments.
Through the DeVry e-learning platform, you will be able to
- review the Syllabus and weekly assignment information;
- submit completed work for grading;
- take quizzes and exams;
- obtain copies of class handouts and notes;
- e-mail the instructor and other students; and
- participate in online discussion of class material.
iConnect Live
This course contains iConnect Live sessions that provide students with the opportunity to attend live presentations, which cover course materials, projects, and assignments. Please see the iConnect Live items for the days and times of the live sessions and for the link to enter each session. You will also receive e-mail reminders each week.
If you are unable to attend the live session, you can watch the recorded session by clicking on the Recordings link that will appear in the iConnect Live item after the lecture has concluded. Please contact your instructor with any questions.
Please note that because of unavoidable technological issues and presenter availability, the live lectures may be substituted with prerecorded lectures.
Due Dates for Assignments & Exams
Unless otherwise specified, the following applies.
- Access to most weeks begins on Sunday at 12:01 a.m. mountain time (MT).
- All assignments are to be submitted on or before Sunday at the end of the specified week that they are due, by 11:59 p.m. (MT).
- All quizzes and exams are to be completed on or before Sunday at the end of the specified week that they open, by 11:59 p.m. (MT).
Week 8 opens at 12:01 a.m. (MT) on the ending Sunday of Week 7. Any assignments or exams must be completed by 11:59 p.m. (MT) Saturday of the eighth week.
Due Dates for Assignments & Exams
All assignments, quizzes, and exams are to be completed per the schedule indicated by your instructor.
Assignment Values and Letter Grades
The maximum score in this class is 1,000 points. The categories, which contribute to your final grade, are weighted as follows.
| Assignment | Points | Weighting |
|---|---|---|
Discussions (30 points, Weeks 1–7) | 210 | 21% |
| Homework (110 points, Week 1; 100 points, Weeks 4 and 7) | 310 | 31% |
| iLabs (50 points, Weeks 2, 3, 5, and 6) | 200 | 20% |
| Final Exam | 280 | 28% |
| Total Points | 1,000 | 100% |
All of your course requirements are graded using points. At the end of the course, the points are converted to a letter grade using the scale in the table below.
| Letter Grade | Points | Percentage |
|---|---|---|
| A | 930–1,000 | 93% to 100% |
| A- | 900–929 | 90% to 92.9% |
| B+ | 870–899 | 87% to 89.9% |
| B | 830–869 | 83% to 86.9% |
| B- | 800–829 | 80% to 82.9% |
| C+ | 770–799 | 77% to 79.9% |
| C | 730–769 | 73% to 76.9% |
| C- | 700–729 | 70% to 72.9% |
| D+ | 670–699 | 67% to 69.9% |
| D | 630–669 | 63% to 66.9% |
| D- | 600–629 | 60% to 62.9% |
| F | 599 and below | Below 60% |
DeVry Graduate Academic Policy and Relevant Resources
DeVry Undergraduate Academic Policy and Relevant Resources
Frequently Asked Questions
When are grades calculated, and how can I view my grades?
- You must complete any quizzes and post your written assignments (if necessary) to the weekly Dropbox by Sunday 11:59 p.m. (MT) each week, except Week 8 which closes at 11:59 p.m. (MT) Saturday.
- Once your work is reviewed, you should see comments and total points for each assignment in the Gradebook. Instructors should have Discussion work graded by the following Tuesday and all other assignments by the following Friday.
- You may check your progress at any time by going to the Gradebook, selecting the week and then your name.
- Click on the points earned for each assignment in the Gradebook to see any instructor comments.
What should I do if a discrepancy is found with my grade?
- Double-check the error and try to determine what caused it.
- Send your instructor an email explaining your findings.
- Trust that any error in grading will be corrected quickly
What if I cannot get my work submitted on time?
- If you have an emergency that will cause your work to be late, please contact your instructor in advance of the due date so that arrangements can be made. Your instructor may reserve the right to deduct points for work turned in late based on the reason and the timeliness of notice.
- If a technical problem prevents you from meeting the scheduled due date, please contact the Help Desk at 1-800-594-2402 and immediately email your instructor about the situation.
How can I get extra credit?
Extra credit is not an option.
Questions and Concerns
Please feel free to contact me for help with coursework or other areas that may impact your progress. Here are some examples.
- Do you have general questions about attendance, deadlines regarding your courses, student financial aid, or other areas?
- Are you a member of the military service? Do you need to adjust your schedule due to active duty, or do you have questions about your GI Bill® benefits or have other unforeseen military and veteran-related issues that have developed?
- Do you need supplementary student assistance? Please let me know if you are having academic difficulty and would like an ADA accommodation. Although I can talk with you about getting assistance, an excellent point of contact is the Office of Student Disability Services. You can reach the Office by calling 877-496-9050, option 3, or by e-mailing adaofficer@devry.edu or adaofficer@keller.edu.
Regardless of your situation, please feel free to contact me for assistance in whatever area of concern you might have. I will do everything I can to assist you or put you in contact with University colleagues who are trained to assist you in whatever area of concern you might have.
"GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by the VA is available at the official U.S. government website: www.benefits.va.gov/gibill.”