College of Information Systems & Technology DBM/380 Version 9 Database Concepts Copyright © 2012, 2010, 2008, 2007, 2006, 2005, 2003 by University of Phoenix. All rights reserved.
Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.
University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Boston, MA: Course Technology. Grauer, R. T., Mast, K., & Poatsy, M. A. (2011). Exploring Microsoft Office Access 2010 comprehensive. Upper Saddle River, NJ: Pearson Education. Kroenke, D. M., & Auer, D. J. (2011). Database concepts (5th ed.). Upper Saddle River, NJ: Pearson Education. Software Microsoft Access 2010 Virtual Desktop Microsoft Visio 2010 Virtual Desktop All electronic materials are available on the student website. ® ® ® ® ®
Point Values for Course Assignments
ASSIGNMENTS Individual (70%) Points
Course Design Guide DBM/380 Version 9
Database Management Systems Paper (Week 1) Database Environment Paper (Week 2) ERD Creation Project (Week 3) Normalization of the ERD (Week 4) No Individual Assignment Due (Week 5) Participation (2 points per week, Week 1-5) Discussion Questions (2 points per week, Weeks 1-5)
5 15 15 15 NA 10 10
Learning Team (30%) Service Request SR-ht-003 Change Request 2 (Week 2) Service Request SR-ht-003 Change Request 3 (Week 3) Service Request SR-ht-003 Change Request 4 and 5 (Week 4) Service Request SR-ht-003 Project (Week 5) Service Request SR-ht-003 Presentation (Week 5) Total 2 2 2 12 12 100
Week One: Database Architecture
Objectives 1.1 Explain database architectures. 1.2 Define database systems. 1.3 Define relational database architecture. Read Ch. 1, “Database Systems,” of Database Systems: Design, Implementation, and Management. Read Ch. 2, “Data Models,” of Database Systems: Design, Implementation, and Management. Read Ch. 3, “The Relational Database Model,” of Database Systems: Design, Implementation, and Management. Reference Ch. 1, “Getting Started,” of Database Concepts as a supplemental reading.
Course Design Guide DBM/380 Version 9
Read Ch. 1, “Introduction to Access,” of Exploring Microsoft Office Access 2010 Comprehensive. Read this week’s Electronic Reserve Readings. Participate in class discussion. Participate in class discussion. ®
Reading Participation Discussion Questions Nongraded Activities and Preparation ® SkillSoft Registration
All week All week 3/4/13 2 2
The first time you access SkillSoft , you need to register. Do the following to register for SkillSoft : • • Go to https://uopx.skillport.com Register by clicking on Register. The Register button is in the lower right corner, below the login boxes. • Leave the Organization Code field blank. • Use your phoenix.edu e-mail address. • Use your student website login name as your user ID (the name before the @email.phoenix.edu). Click Submit. ® ®
Nongraded Activities and Preparation Creating Basic Tables in...