Database Management for Smart Teacher1 ONLY

johndoe74

dbm380_r9_syllabus.pdf

Home >Information Systems homework help >Database Management for Smart Teacher1 ONLY

DBM/380 Version 9 1

DBM 380 Syllabus College of Information Systems & Technology

DBM/380 Version 9 Database Concepts

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. Instructor and Contact Information Instructor’s Name: Patrick J Clair PMP, CSM Telephone: Mobile 210-601-8864 UOPhx E-mail Address: [email protected] Alternative E-mail Address: [email protected] Availability: By phone, after 7, but before 10pm. Email anytime. Welcome! Welcome to DBM380. I will do everything I can to ensure that the next five weeks will be an enlightening and

https://ecampus.phoenix.edu/secure/aapd/policies/

DBM/380 Version 9 2

enjoyable learning experience for us. Let me know if I can assist you with any questions or problems during our time together. Instructor Biography I work as a Consultant performing a variety of IT and quality improvement activities for companies in San Antonio, Houston and Austin. My job is to ensure that systems are properly engineered to meet customer requirements. Prior to my current position I worked as a consulting engineer working for a variety of public and private organizations that included the US Army. Prior to consulting work, I worked at Rush Enterprises, Southwest Research Institute and spent 21 years with Southwestern Bell, AT&T, Bell Laboratories and Lucent Technologies. I did everything from climbing telephone poles to product and project management in addition to running a data and network-engineering center. I received a Master of Science degree from Southern Methodist University in 1999 after earning a Bachelor of Arts from Illinois Benedictine University in 1993. I have been a member of the Project Management Institute since 1999 and I am a certified Project Management Professional (PMP) a Certified Scrum Master (CSM) and Six Sigma Green Belt. I live in Spring Branch. I have a 28-year-old daughter and a 24-year-old son. Hobbies are viticulture, music and building boats. Instructor’s Grading and Class Policies Grade Definitions A = Clearly stands out as excellent performance. Has unusually sharp insight into material and initiates thoughtful questions. Sees many sides of an issue. Articulates well and writes logically and clearly. Integrates ideas previously learned from this and other disciplines; anticipates next steps in progression of ideas. Example: "A" work should be of such a nature that it could be put on display for all students to review and emulate. The "A" student is an example for others to follow. This is perfect or very near perfect work. Student is generally not absent from class. B = Grasps subject matter at a level considered to be good to very good. Is an active listener and participant in class discussion. Speaks and writes well. Accomplishes more than the minimum requirements. Work in and out of class is of high quality. Example: "B" work indicates a high quality of performance and is given in recognition for solid work; a "B" should be considered a high grade. C = Demonstrates a satisfactory comprehension of the subject matter. Accomplishes only the minimum requirements, and displays little or no initiative. Communicates orally and in writing at an acceptable level for a college student. Has a generally acceptable understanding of all basic concepts. Example: "C" work represents average work for the students in a program or class. A student receiving a "C" has met course requirements, including deadlines. D = Quality and quantity of work in and out of class is below average and barely acceptable. Example: "D" work is passing by a slim margin. F = Quality and quantity of work in and out of class is unacceptable. Example: "F" work does not pass the course or meet minimum assignment expectations. Late Assignments All work must be submitted the week in which it is due. Work should posted by the beginning of class. Work more than two weeks late is not accepted. A letter grade is assessed for each week late. You have until midnight on the last day of class to submit. It is strongly recommended that students retain a copy of all

DBM/380 Version 9 3

assignments at the time that the assignment is posted. Instructor Feedback on Assignments The instructor commits to returning all students’ graded assignments with written feedback to the students by the subsequent class in which the assignments were due. Students are encouraged to meet privately with the instructor if they would like individualized verbal feedback and assistance with assignments. Changes to Assignments ** Please note that there may be changes or alterations to the assignments as they are listed in the course module. The assignments listed in my syllabus take precedence over those online. Incompletes Typically the instructor does not grant incompletes

Assignments

Week One: Database Architecture

Details Due Points

Objectives 1.1 Explain database architectures. 1.2 Define database systems. 1.3 Define relational database architecture.

Reading Read Ch. 1, “Database Systems,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch. 2, “Data Models,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch. 3, “The Relational Database Model,” of Database Systems: Design, Implementation, and Management.

Reading Reference Ch. 1, “Getting Started,” of Database Concepts as a supplemental reading.

Reading Read Ch. 1, “Introduction to Access,” of Exploring Microsoft ® Office

Access 2010 Comprehensive.

Reading Read this week’s Electronic Reserve Readings.

Participation Participate in class discussion. 2

Nongraded Activities and Preparation SkillSoft

Registration

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.

https://uopx.skillport.com/

DBM/380 Version 9 4

 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 Access

® 2010

Complete the following SkillSoft ® activity on your student website:

Creating Basic Tables in Access 2010.

Nongraded Activities and Preparation Database Systems and Relational Databases

Complete the following SkillSoft ® activity on your student website:

Database Systems and Relational Databases.

Nongraded Activities and Preparation Microsoft

Access ® Data

Types

Complete the following SkillSoft ® activity on your student website:

Microsoft Access Data Types.

Supporting Activity Unstructured and Structured Data

Write a 200- to 300-word short-answer response for the following:

 Reflect on the textbook readings. Use examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment?

Supporting Activity Limitations With Nonrelational Structures

Write a 200- to 300-word short-answer response for the following:

 What limitations have you or someone you know encountered in the past in using nonrelational structures (such as in a Microsoft

Excel ® or Word file) to store data? What were the advantages?

Learning Team Instructions SR-ht-003

Access Service Request SR-ht-003, “Develop a Design for a Fleet Truck Maintenance Database” located on the Huffman Trucking IT Service Requests site. A link to the Virtual Organizations can be found on your student website. Complete Service Request SR-ht-003 due in Week Five. Include Change Requests 2–5 in addition to the base request.

Individual Database Design Paper

Write a 350- to 700-word paper in which you do the following:

 Explain what database systems are and how they are used.

 Define database architecture. Consider Microsoft ® Access

® ,

Microsoft ® SQL Server

® , Oracle

® , and IBM DB2

® software as

DBM/380 Version 9 5

possible examples.

 Summarize your paper by describing the database systems in your workplace, identifying which database systems and architecture they fall under.

Include 2 to 4 references. Format your paper consistent with APA guidelines.

Week Two: Database Design

Details Due Points

Objectives 2.1 Explain database design. 2.2 Apply database design principles

Reading Read Ch. 9, “Database Design,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch. 2, “The Relational Model,” of Database Concepts.

Reading Read Ch. 5, “Database Design,” of Database Concepts.

Reading Read Ch. 6, “Data Validation Techniques”, of Exploring Microsoft ®

Office Access 2010 Comprehensive.

Reading Read this week’s Electronic Reserve Readings.

Participation Participate in class discussion. 2

Nongraded Activities and Preparation Introduction to Queries in Access

® 2010

Complete the following SkillSoft ® activity on your student website:

Introduction to Queries in Access 2010.

Nongraded Activities and Preparation Retrieving, Validating, and Attaching Data in Access

® 2010

Complete the following SkillSoft ® activity on your student website:

Retrieving, Validating, and Attaching Data in Access 2010.

Nongraded Activities and Preparation Logical and Physical

Complete the following SkillSoft ® activity on your student website:

The Logical and Physical Database Design Methodologies.

DBM/380 Version 9 6

Database Design Methodologies

Supporting Activity Null Value

Write a 200- to 300-word short-answer response for the following:

 Think of a situation where null value should be allowed and a situation where it should not be allowed. What are the consequences of inappropriate null settings?

Supporting Activity Many-To-Many Relationship

Write a 200- to 300-word short-answer response for the following:

 What are some issues when working with a many-to-many relationship? Provide some examples.

Supporting Activity Database Designer

Write a 200 - to 300-word short-answer response for the following:

 How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and class assignments.

Supporting Activity Data Types

Write a 200- to 300-word short-answer response for the following:

 Why it is necessary to choose appropriate data types for each data column?

Learning Team Instructions Service Request SR-ht-003: Change Request 2

Begin working on Service Request SR-ht-003, due in Week Five, by completing Change Request 2. Create documentation for this project that summarizes the process for using the entities and attributes for fleet truck maintenance. The Entities and Attributes for Fleet Truck Maintenance can be found in the Huffman Trucking Virtual Organization. Format your paper consistent with APA guidelines. Submit a draft of your team’s documentation.

Individual Database Environment Paper

As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standards. Write a 750- to 1,050-word paper in which you complete the following:

 Choose a database environment from the following:

o An appropriate database environment within your workplace (must be approved by your instructor)

o An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum

DBM/380 Version 9 7

o Smith Consulting (Virtual Organization) – needs a database to track their consulting staff, each staff member’s skill sets, and what projects they are working on

 Analyze the database environment.

 Describe the problems and constraints.

 Describe the objectives of the database environment.

 Describe the scope and boundaries.

 List the data specifications (must include a minimum of three entities with attributes).

Include 3 to 5 references. Format your paper consistent with APA guidelines. Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments.

Week Three: Entry Relationship Diagram

Details Due Points

Objectives 3.1 Explain Entity-Relationship Diagrams. 3.2 Develop an ERD.

Reading Read Ch. 3, “The Relational Database Model,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch. 4, “Entity Relationship (ER) Modeling,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch. 4, “Data Modeling and the Entity-Relationship Model,” of Database Concepts.

Reading Review “Using the Relationships Window” of Exploring Microsoft ®

Office Access 2010 Comprehensive.

Reading Read this week’s Electronic Reserve Readings.

Participation Participate in class discussion. 2

Nongraded Activities and Preparation Joins, SQL, and Action Queries in Access

® 2010

Complete the following SkillSoft ® activity on your student website:

Joins, SQL, and Action Queries in Access 2010.

Nongraded Activities and Preparation

Complete the following SkillSoft ® activity on your student website:

Getting Started with Visio 2010.

DBM/380 Version 9 8

Getting Started with Visio

® 2010

Supporting Activity DBMS and Data Mining

Write a 200- to 300-word short-answer response for the following:

 A motor vehicle maintenance center wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how can it help improve their services?

Supporting Activity Cardinality Constraints

Write a 200- to 300-word short-answer response for the following:

 What are four types of cardinality constraints? Provide personal examples of each. Note. The examples from the textbooks cannot be used for this question.

Supporting Activity Primary Key

Write a 200- to 300-word short-answer response for the following:

 How do you select the primary key from the candidate keys? How do foreign keys relate to candidate keys? Provide examples from either your workplace or class assignments.

Supporting Activity Overall Design

Write a 200- to 300-word short-answer response for the following:

 Under what circumstances would you break down an overall design to include individual user views? Provide examples from either your workplace or class assignments.

Learning Team Instructions Service Request SR-ht-003: Change Request 3

Continue working on Service Request SR-ht-003, due in Week Five, by completing Change Request 3. Create documentation that explains the process of creating the entity-relationship diagrams in the change request relative to this project. Format your paper consistent with APA guidelines. Submit a draft of your team’s documentation

Individual ERD Creation Project

The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment. Use a Microsoft

® Visio

® diagram to create a detailed ERD using the

data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty’s feedback. Use a Microsoft

® Access

® database to create the preliminary

database tables, columns with data types, primary keys, and relationships.

DBM/380 Version 9 9

Week Four: Normalization

Details Due Points

Objectives 4.1 Explain normalization. 4.2 Apply normalization principles to a relational database.

Reading Read Ch. 6, “Normalization of Database Tables,” of Database Systems: Design, Implementation, and Management.

Reading Review Ch. 2, “The Relational Model,” of Database Concepts.

Reading Review Ch. 5, “Database Design,” of Database Concepts.

Reading Read Ch. 9, “Fine-Tuning the Database,” of Exploring Microsoft ®

Office Access 2010 Comprehensive.

Reading Read this week’s Electronic Reserve Readings.

Participation Participate in class discussion. 2

Supporting Activity Normalization Process

Write a 200- to 300-word short-answer response for the following:

 In your own words, describe the nature and purpose of the normalization process. Provide some examples from sources other than the readings.

Supporting Activity Disadvantage of Normalizing

Write a 200- to 300-word short-answer response for the following:

 Discuss the disadvantages of normalizing a database to a high degree of normalization. Should there be a definite rule on when to stop normalizing? Provide some examples from sources other than the readings.

Supporting Activity Denormalization

Write a 200- to 300-word short-answer response for the following:

 In what business database environments is denormalization appropriate and why? What would denormalization specifically involve?

Learning Team Instructions SR-ht-003: Change Request 4 and 5

Continue working on Service Request SR-ht-003, due in Week Five, by completing Change Requests 4 and 5. Create documentation describing the principles and importance of normalization in relation to this project and the process by which this project was normalized. Format your paper consistent with APA guidelines. Submit a draft of your team’s documentation to the Assignments link.

Individual Normalization of

The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.

DBM/380 Version 9 10

the ERD Your database project must meet the following assessment requirements: Design and develop a database using professional principles and standards.

 Provide a logical and physical design of the database.

 Use relational database software application to develop database.

 Provide an entity relationship diagram.

 Normalize the database.

 Generate and provide test data. Use a Microsoft

® Visio

® diagram to normalize the ERD to third normal

form (3NF). Use the Microsoft

® Access

® database created in Week Three to

create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables. Note. Only the Microsoft

® Visio

® diagram must be normalized to the

3NF. The 3NF is not required for a Microsoft ® Access

® database.

Submit the ERD and final database to the appropriate Assignment link.

Week Five: Management of Databases

Details Due Points

Objectives 5.1 Explain the management of databases. 5.2 Demonstrate the application of a database in a desktop

environment.

Reading Read Ch 10, “Transaction Management and Concurrency Control,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch 11, “Database Performance Tuning and Query Optimization,” of Database Systems: Design, Implementation, and Management.

Reading Read Ch 15, “Database Administration and Security,” of Database Systems: Design, Implementation, and Management.

Reading Reference Ch 6, “Database Administration,” of Database Concepts as a supplemental reading.

Reading Read this week’s Electronic Reserve Readings.

DBM/380 Version 9 11

Participation Participate in class discussion. 2

Nongraded Activities and Preparation Optimizing, Securing, and Sharing Access

® 2010

Databases

Complete the following SkillSoft ® activity on your student website:

Optimizing, Securing, and Sharing Access 2010 Databases.

Supporting Activity Database Administrator and Architect

Write a 200- to 300-word short-answer response for the following:

 Describe the differences between a database administrator and a database architect. How is your organization structured to handle the functions of these roles?

Supporting Activity Database Service

Write a 200- to 300-word short-answer response for the following: Locate a hosted, distributed database service. Explore its features and talk about your experiences. In what situations would an organization consider using it?

Supporting Activity DBMS

Write a 200- to 300-word short-answer response for the following:

 Describe the advantages and disadvantages of DBMS-provided security. Compare it to network or application security.

Supporting Activity Database Recovery Process

Write a 200- to 300-word short-answer response for the following:

 Suppose that the database system within your organization has failed. Describe the database recovery process.

Supporting Activity Assignment Review

Write a 200- to 300-word short-answer response for the following:

 What difficulties did you encountered and how did you overcome them? Evaluate a classmate’s assignment by using the scoring guide provided by the instructor.

Learning Team Service Request SR-ht-003

Finalize the project work for SR-ht-003 and Change Requests 2–5. Compile all documentation from your Change request from Weeks Two through Five. Submit your team’s project work and documentation to your facilitator.

Learning Team Service Request SR-ht-003 Presentation

Create a 3- to 5-slide Microsoft ®

PowerPoint ® presentation in which

you explain how the principles of database management and your recommendations were applied to the project. Submit your team presentation to your facilitator.

DBM/380 Version 9 12

Copyright University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation. Skillsoft is a registered trademark of Skillsoft Ireland Limited. Edited in accordance with University of Phoenix® editorial standards and practices.