Dbm380 Course Syllabus

Only available on StudyMode
  • Download(s) : 138
  • Published : March 10, 2013
Open Document
Text Preview
Course Design Guide DBM/380 Version 9

1

Syllabus
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

2

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

Due
All week

Point s

Reading

All week

Reading

All week

Reading

All week

Reading

All week

Course Design Guide DBM/380 Version 9

3

Reading

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

®

All week

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

All week

Nongraded Activities and Preparation Creating Basic Tables in...
tracking img