DBM380 Database Concepts

Document Sample
DBM380 Database Concepts Powered By Docstoc
					DBM/380
Database Concepts
DBM/380 – Database Concepts                                                                             2


Instructor          Al R. Pangelinan
                    Cell phone/voicemail: 916-716-8559
                    Primary email: al.pangelinan@gmail.com
                    Website: www.phoenixinstructor.com

Course              Welcome to DBM/380 – Database Concepts

Version             rEsourceSM

Course              Group XRS02BIT6 will meet on campus on the following Saturdays:
Schedule                  03/03/2007       - Workshop 1
                          03/31/2007       - Workshop 5

                    The group will meet online during the following dates:
                           03/04 thru 03/10 - Workshop 2
                           03/11 thru 03/17 - Workshop 3
                           03/18 thru 03/24 - Workshop 4

                    The group will meet at the following location:
                           Roseville Learning Center
                           516 Gibson Drive
                           Roseville, CA 95678
                           800-266-2107
                           916-783-7829 Fax

Course              This course covers database concepts. Topics include data analysis, the principal
Description         data models with emphasis on the relational model, entity-relationship diagrams,
                    database design, normalization, and database administration.

Topics                  DATABASE ARCHITECTURE
                           o Explain database architecture.
                           o Define database systems.
                           o Define relational database architecture.
                        DATABASE DESIGN
                           o Explain database design.
                        ENTITY RELATIONSHIP DIAGRAM
                           o Explain Entity Relationship Diagrams (ERD).
                        NORMALIZATION
                           o Explain normalization.
                        MANAGEMENT OF DATABASES
                           o Explain the management of databases.
                           o Apply ERD.
                           o Apply database design.

Special Note        Where there is any difference between this syllabus and the assignments in
                    rEsource, this syllabus is the final word on the expected class work.

Required Text       The materials for this course are electronic and are found on the rEsourceSM Web
                    page. http://mycampus.phoenix.edu.




University of Phoenix                                                        Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                  3



Web Access          The ability to access your personal Inbox and your classrooms via the Web is an
to Class            alternative many of you will find extremely valuable. Although more limited in terms
                    of features than OE (Outlook Express), it provides us with even greater flexibility in
                    meeting our online responsibilities.

                    While Outlook Web Access (OWA) to class via
                    http://ecampus.phoenix.edu/owalogin.asp is possible, keep in mind that this should
                    be considered short-term, emergency access. Please use Outlook Express (OE)
                    whenever possible, since it is faster, easier to use and offers more formatting
                    options.

Newsgroups          FXWestern.03-03.25_XRS02BIT6-DBM380
                    This is a “parent” newsgroup for all newsgroup folders for the class. You cannot
                    send messages to it. It is not used for class discussions or group participation.

                    FXWestern.03-03.25_XRS02BIT6-DBM380.1Main
                    FXWestern.03-03.25_XRS02BIT6-DBM380.2Main
                    There are two newsgroups for each class containing the word “main”: “1Main” and
                    “2Main.” During the first on-campus workshop, your instructor will let you know
                    which of these two newsgroups to use for online workshop class discussions,
                    participation, and assignment posting. All online week class participation will take
                    place in the newsgroup designated “1Main” unless your instructor expressly asks
                    you to use the “2Main” newsgroup. Note: Do not start your own thread (NEW
                    POST) in this newsgroup unless advised by your instructor. All new threads
                    (not approved) will be deleted. Please use “Reply Group” when posting to
                    this newsgroup. There will be threads situated, such as the “Week 2 - DQ1”
                    thread, for students responses.

                    FXWestern.03-03.25_XRS02BIT6-DBM380.Assignments
                    This is a write-only newsgroup, which means you can write messages to it, but you
                    cannot read messages in it. Your instructor will let you know which assignments, if
                    any, you should send to this newsgroup. You may want to complete the “cc” line
                    and also address the messages you send to this newsgroup to your University of
                    Phoenix Online Learning System Inbox, so you will receive a confirmation copy of
                    them at the same time they are sent to the newsgroup.

                    FXWestern.03-03.25_XRS02BIT6-DBM380.Course-Materials
                    This is a read-only newsgroup, where the instructor will post the syllabus and other
                    course materials. Please check it for new messages on the first day of each online
                    workshop week.

                    FXWestern.03-03.25_XRS02BIT6-DBM380.Chat-Room
                    This is a read-and-write access newsgroup for everyone in the class. It is designed
                    as a place to discuss issues not related to the course content.

                    FXWestern.03-03.25_XRS02BIT6-DBM380.Learning-Team-A
                    FXWestern.03-03.25_XRS02BIT6-DBM380.Learning-Team-B
                    FXWestern.03-03.25_XRS02BIT6-DBM380.Learning-Team-C
                    FXWestern.03-03.25_XRS02BIT6-DBM380.Learning-Team-D
                    FXWestern.03-03.25_XRS02BIT6-DBM380.Learning-Team-E
                    Your instructor will assign your learning team to one of the class newsgroups listed
                    below. Please post a message in your assigned newsgroup to let your teammates
                    know you have access to the folder. At the same time, please unsubscribe from
                    the other Learning Team newsgroup folders.



University of Phoenix                                                           Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                  4


Learning            Students are highly encouraged to participate in using the learning resource center
Resources           for research and study. The digital library is open 24 hours a day, 7 days a week.
                    Registration to use the digital library is required. Details are found via a link at
                    your Student Web site.

Instructor          My biography is located at following link: www.myspace.com/vialogicinc
Biography


Teaching /          This course will incorporate faculty facilitation of theoretical content knowledge and
Learning            its applications. Student achievement of course objectives is evidenced by text-
Model               based discussions, Individual Written Work, and Oral and Written Team
                    Assignments. Through the accomplishment of projects, students practice and
                    refine learned skills and evidence application of knowledge through product
                    submissions for evaluation and grading.

Course              The University of Phoenix trusts each student to maintain high standards of
Standards           honesty and ethical behavior. All assignments submitted in fulfillment of course
                    requirements must be the students’ own work. All assignments except those
                    designed as “group” are meant to be individual efforts. Group work is meant to be
                    equal efforts by all group members. It is assumed that students will perform
                    professionally in preparing work required for this class.

                    Please note: All individual and group assignments must be original and prepared
                    specifically for this class.

Plagiarism          In this class there will be a “zero tolerance” policy in regards to any and all
                    plagiarism. Cutting/pasting or copying text verbatim from a source into your
                    paper – whether it is a sentence, a paragraph, a section, or an entire paper –
                    without putting the specific text in double quotes and including the proper citation
                    per APA guidelines is plagiarism. As a guideline, no more than 10% of a paper in
                    this class should be comprised of direct quotes. In all cases, cite your sources.
                    This cannot be emphasized enough! When you produce an assignment, written or
                    oral, that uses anyone else’s work (including the textbook), you must properly cite
                    and reference that work as a source. Do the research, use quotes where
                    appropriate, use citations where appropriate, and make sure that the paper that
                    you are submitting is your writing.

                    Any and all assignments that are found to have violated this plagiarism
                    policy will receive an automatic zero without any opportunity for revision,
                    and a report will be filed with the campus Office of Academic Affairs.

                    All written assignments will be submitted to the Center for Writing
                    Excellence.

Grading of          Unless otherwise noted, all individual and group papers are to be typed, spell-
Written Work        checked and grammar checked, submitted double-spaced, and prepared in the
                    proper APA format required for the program. The instructor will use the University
                    of Phoenix APA Formatting Guidelines for format reference, a copy of which can
                    be found on the Instructor’s Faculty Web page for this course. The attached
                    “Paper Evaluation Form” will be used as a guide to evaluate and weight the
                    scoring of papers in this course.




University of Phoenix                                                           Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                 5



APA                 In this course be sure you are adhering to the following minimum APA
Formatting          requirements (refer to the Publication Manual of the American Psychological
Specifics           Association, Fifth Edition):
                             General format, e.g., 12 point conventional font, double-spaced, 1”
                             margins.
                             Use a title page.
                             Use proper header.
                             Always use transitional headings to separate the sections in your paper.
                             The specific format of the headings can be of your choosing (bold,
                             underline, italic, justification). The use of headings not only improves the
                             overall readability of your paper by breaking up the body text, but it is an
                             excellent indicator of organized thought behind well-structured writing.
                             Include in-text citations and references page.
                             Please pay special attention to proper citation of Internet sources.

                    Also, please refer to the APA documents provided on my faculty website.

Feedback            I will send feedback on all graded assignments to each student’s personal email
                    address within seven days of receipt. I will send feedback and grade information
                    on all other graded activities (such as participation) to each student’s personal
                    email address within seven days of the end of the workshop week.

Center for          For continued improvement of both writing content and format, you may want to
Writing             take advantage of the services provided by the University of Phoenix Center for
Excellence          Writing Excellence (CWE).


                    In addition to excellent on-line writing tutorials and guides, the Center provides a
                    Reviewing service that allows students to upload papers and receive targeted
                    comments from a trained writing tutor. The CWE is accessible via a link at your
                    Student Web site.

                    Please note: It is the student’s responsibility to plan for appropriate lead times
                    when utilizing the services of the CWE.

Grading of          Although the instructor is evaluating your presentation, he is not your sole
Oral                audience. Be sure to engage your entire audience, in this case, your fellow
Presentation        classmates. Use appropriate eye contact toward the audience; ask them
                    questions or ask for their opinions. Structure your presentation so that you
                    address the following elements:
                        1. Motivate: Why is this important?
                        2. Preview: What specific points/topics are being covered?
                        3. Discuss: Cover each point/topic with adequate support.
                        4. Review: What was covered and how it applies.

                    The attached course “Presentation Evaluation Form”, a copy of which will be
                    reviewed during Workshop 1 and can be found on the Instructor’s Faculty Web
                    page, will be used to evaluate and weight the scoring of all presentations.

Oral                Students will receive real-time written feedback using the above-referenced
Presentation        “Presentation Evaluation Form” on graded oral presentations immediately following
Feedback            the presentation.



University of Phoenix                                                            Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                 6



Attendance          University of Phoenix courses emphasize group interaction in the classroom. If you
Policy              are absent, you do not gain the benefit of class involvement and are not
                    contributing to the learning of other students in the class.

                    Exception
                    Circumstances occasionally arise which may cause you to miss class. You are
                    allowed one absence during each course in a five- or six-week course. The
                    absence, however, will affect the overall course grade. If you are absent for two
                    weeks during a five- or six-workshop course, an automatic withdrawal will occur. In
                    other words, you will not earn course credit or a letter grade for the course. A "W"
                    or "WF" will be entered for the course.

                    For On-campus Weeks
                    Students are expected to arrive on time, be prepared, and attend ALL CLASSES.
                    Attendance is mandatory. Any absence will affect participation points. It is the
                    student’s responsibility to notify the instructor in advance, if possible, of any
                    absence or anticipated lateness. The faculty member has no authority to excuse
                    absences. It is the student’s responsibility to contact an Academic Counselor with
                    any absence concerns. The student is still responsible for work assigned.
                    Absences from class do not excuse a student from required assignments.

                    If a student is late for class or leaves early from class and has not made prior
                    arrangements with the instructor, the student may not be able to make up quizzes
                    or other in-class work that occurred while the student was not present.
                    To be in attendance during the first and last workshops of a FlexNet course, you
                    must attend the on-campus class meetings and sign the attendance roster.

                    For Online Weeks
                    To be in attendance during an online workshop week, you must post at least one
                    message to any of the course newsgroups on two days during the online week,
                    using your University of Phoenix account and email address.

Participation       In an intensive, collaborative learning environment such as that of University of
Policy              Phoenix, class attendance is perhaps the most obvious and objective starting point
                    measure for participation. If you are not in attendance, you miss out on many
                    opportunities for learning. Because of this, if you miss class, you will not receive
                    participation points for that workshop week.

                    During each workshop week, you are expected to be actively engaged in the
                    activities and discussions.

                    For On-campus Weeks
                    During face-to-face meetings on-campus, you need to come to class prepared to
                    engage in, and must contribute to, discussions and activities based on the topics
                    and objectives of the week.

                    I will consider a student’s relative involvement in class discussions and activities in
                    assigning a portion of the grade for participation. The quality of contributions will be
                    assessed based on the following criteria:
                              Responses should reflect knowledge of assigned readings.
                              Responses should show application of critical thinking skills.
                              Responses should show application of theory to real life situations.




University of Phoenix                                                             Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                 7


                    I will evaluate participation levels after every class meeting and will make
                    recommendations for improvement if necessary. In an intensive, collaborative
                    learning environment such as ours, class attendance is, perhaps, the most obvious
                    and objective measure of participation. If students do not attend, they miss out on
                    many opportunities for learning. Students who miss class will not receive
                    participation points for that evening. Students who arrive late or leave early should
                    also anticipate a reduced participation grade.

                    For Online Weeks
                    During online workshop weeks, you must contribute to your assigned main
                    newsgroup discussions in a substantive manner four days each week (a minimum
                    of two substantive notes on each of the four days for a total of 8 notes per week) to
                    earn 100% of the participation grade points for the workshop.

                    As the instructor for the course, I will take both the quantity and content of your
                    messages to your assigned main newsgroup into account to determine your weekly
                    online workshop participation grade. Discussion questions (DQs) and Weekly
                    Summary postings will count towards participation grade points.

Modality            All assignments (Individual and Team) in this course must be submitted in
Procedures          the Assignments-write-only newsgroup by twelve (12) in the morning (a.m.)
                    for online Workshops 2 thru 4 (ex. 03/11/2007 @12 a.m.) and six (6) in the
                    evening (p.m.) for on-campus Workshop 5. No late assignments will be
                    accepted. If a student is absent (planned or emergency), it is the responsibility of
                    the student to make certain that the assignments are submitted on or before the
                    end of class on the evening on which they are due. Assignments received after the
                    end of class will not be evaluated, nor will they earn credit. All deliverables will be
                    provided to the instructor electronically in Microsoft Word, Excel, PowerPoint,
                    Access (must be zipped) or Visio format. In addition, the Subject Lines for new
                    posts in the Assignments-write-only Newsgroup should use the following
                    naming convention:
                            Format
                            <class><assignment name><dash><last name>

                            Subject Line examples:
                            a) DBM/380 Individual Assignment #1 – Al Pangelinan
                            b) DBM/380 LT Reflection Paper – Team A

Incomplete          No “Incomplete” grades will be awarded in this class. No assignments will be
Policy              accepted past the last night of class.

Course              If a module for the course is on the Student Web, please be sure to refer first to this
Changes             document, the syllabus, since it (the syllabus) sets forth the specific requirements
                    and grading criteria for your course. If there is a module on the Student Web, you
                    will see that I have not made any changes to the learning objectives of this course.
                    However, there may be modifications of the weekly assignments which vary from
                    the module. If there are any differences between my syllabus and a course
                    module, my syllabus and assignments take priority over those in the module. In
                    other words, please use the syllabus as your guide through the course.




University of Phoenix                                                            Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                          8



UOP Grading         Score          Grade         Quality Points
Point Scale         95-100         A             4.00
                    90-94.9        A-            3.66
                    87-89.9        B+            3.33
                    84-86.9        B             3.00
                    80-83.9        B-            2.66
                    77-79.9        C+            2.33
                    74-76.9        C             2.00
                    70-73.9        C-            1.66
                    67-69.9        D+            1.33
                    64-66.9        D             1.00
                    60-63.9        D-            0.66
                    < 60           F             0.00

UOP Grade               A   Clearly stands out as an excellent performer. Has unusually sharp insight into
Definitions                 material and initiates thoughtful questions. Sees many sides of an issue.
and Criteria                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 reserve for all
                            students to review and emulate. The “A” student is an example for others to follow.
                        B   Grasps subject matter at a level considered to be good to very good. Participates
                            actively in class discussion. Writes well. In on-ground environments, speaks well.
                            Accomplishes more than the minimum requirements. Produces high quality work.
                            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 (on-ground environments) and in writing at an acceptable level for a college
                            student. Has an acceptable understanding of all basic concepts. Example: “C”
                            work represents average work. A student receiving a “C” has met the requirements,
                            including deadlines, of the course.
                        D   Quality and quantity of work is below average and barely acceptable. Example: “D”
                            work is passing by a slim margin.
                        F   Quality and quantity of work is unacceptable. Academic credit is not earned for an
                            F. Example: “F” work does not qualify the student to progress to a more advanced
                            level of course work.
                        W   Withdrawal. Students who attend at least one night of class, miss at least two class
                            sessions or two Learning Team meetings, or officially withdraw prior to completing
                            the course will receive a “W”, if the faculty member determines that the student was
                            passing the course or cannot make a determination whether the student was
                            passing or failing at the time of withdrawal. The grade is not calculated in the GPA.
                    WF      Withdrawal/Failing. Students who attend at least one night of a course, miss at least
                            two class sessions or two Learning Team meetings or officially withdraw prior to
                            completing the course will receive a “W/F” if the faculty member determines that the
                            student was failing the course at the time of the withdrawal.

Cell Phones        Hiding behind a laptop, answering e-mail, playing games, surfing the web etc. will
and Laptops        not be tolerated. Points will be deducted from your participation for that
                   evening if these rules are broken.




University of Phoenix                                                                  Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                  9



Dress Code         Students are required to dress in attire that is appropriate to the professional
                   learning environment. In other words, during regular class sessions, students
                   dress with an appropriate sense of propriety. Casual clothing is acceptable as long
                   as it not revealing and/or offensive to others in the learning environment. During
                   oral presentations, the instructor reserves the right to require more formal attire
                   including business casual/formal attire as we are training students to make
                   business presentations. Of course, if role playing or performing skits, the
                   appropriate costuming is acceptable. Please consult with your instructor regarding
                   his/her individual requirement regarding dress during your formal presentations.

Breaks             Two breaks have been scheduled during Workshops 1 and 5. The first break will
                   be taken at 10:30 a.m. (15 minutes) and the second at 12:00 p.m. (15 minutes).

Student’s           The University of Phoenix Code of Student Responsibility supports the University’s
Rights and          mission to provide opportunities for working adult students to learn and to meet
Responsi-           their life and career goals. As members of the University of Phoenix academic
bilities            community, students are responsible to respect the rights and privileges of others,
                    and to foster an environment conducive to student learning. Please review the
                    Code of Student Responsibility on my faculty web page, and ask any questions if
                    necessary.

Learning            Learning Teams are an extension of the classes and an essential part of the UOP
Teams               academic experience for students. In addition to providing a supplemental
                    learning environment for mastery of course content, Learning Teams also provide
                    students with an opportunity to develop and refine teamwork skills. The students
                    will select and form Learning Teams during Workshop 1. Once formed, Learning
                    Teams will not be changed during this course for any reason.

                   Each Learning Team must submit a “Learning Team Charter” during Workshop
                   Two, as well as weekly “Learning Team Logs” during Workshops Two through Six.
                   The purpose of the log is to document the participation of each team member, with
                   an emphasis on overall contribution, rather than with the number of meetings
                   and/or individual attendance dates and times. The signed log will be handed in at
                   the beginning of each Workshop. All Learning Team documents are provided on
                   the Learning Team Toolkit web page.

Peer                During Workshop Five, each student will complete a “Learning Team Peer
Evaluations         Evaluation” form, a copy of which can be found via a link at your Student Web site.

                    Any student whose average score on their combined peer evaluations is less
                    than 3.0 will receive a 20% deduction in the Learning Team component of
                    their grade.

Privacy and         One of the highlights of the University of Phoenix academic experience is that
Confidentiality     students can draw on the wealth of examples from their organizations in class
in the UOP          discussions and in their written work. However, it is imperative that students not
Classroom           share information that is confidential, privileged, or proprietary in nature. Students
                    must be mindful of any contracts they have agreed to with their companies.




University of Phoenix                                                            Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                             10



Assignment          The following table summarizes the weightings of all graded requirements for this
Weightings          class, both individual and group. Each assignment is further described in the
                    sections that follow.

                    ASSIGNMENT                                                               POINTS
                    Individual Assignments: (70 points)
                        Assignment #1 (Due Workshop 2)                                          12
                        Assignment #2 (Due Workshop 3)                                          12
                        Assignment #3 (Due Workshop 4)                                          12
                        Assignment #4 (Due Workshop 5)                                          15
                        Class Participation (All Workshops)                                     19
                    Learning Team Assignments: (30 points)
                        LT Charter and Logs                                                      5
                        LT Workflow Chart                                                        4
                        LT Role Assignments                                                      2
                        Written Assignment (Due Workshop 5)                                     10
                        Presentation (Due Workshop 5)                                            9
                        Peer Review (Due Workshop 5)                                             0
                    TOTAL POINTS                                                               100




University of Phoenix                                                         Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                                  11



Individual          Notes
Assignments         The following notes have been listed to provide more clarity:
                             Microsoft (MS) Access is required.
                             Create the MS Access project from scratch or by using the Wizard shown
                             in class. DO NOT use the “Template” method OR the option to create a
                             Switchboard. In other words, start from a “Blank” database.
                             All MS Access Assignments will be discussed prior to submission.

                    Assignment #1 (Due Workshop 2)
                    This assignment involves a Microsoft Access Project with the following items:
                            Using Microsoft Access, create a “Blank” database.
                            In the MS Access database, create the preliminary (no keys and no
                            relationships) database tables (minimum of five) for the Driver Log ERD
                            in Huffman Trucking on the Virtual Organization portal.

                    Assignment #2 (Due Workshop 3)
                    Extend your Microsoft Access Project with the following items:
                           Create the keys and relationships between tables for the Driver LOG from
                           Workshop 2.
                           Create forms to populate the tables with a minimum of ten (10) records
                           per table. Note: You cannot insert data directly by opening a table.

                    Assignment #3 (Due Workshop 4)
                    Extend your Microsoft Access Project with the following items:
                           Create the following queries and reports using the data created during
                           Workshop 3:
                               o Driving Logs Report By Driver
                               o Driving Logs Report By Log ID
                               o Drivers Report
                               o Drivers with Violations Report
                               o Vehicles Report
                               o Vehicles Used By Drivers Report

                    Assignment #4: Database Concepts Exam (Due Workshop 5)
                    The test will consist of multiple-choice, true/false, and fill-in-the-blank questions.
                    The test will be given during the first hour of class. A review will follow.




University of Phoenix                                                              Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                             12



Learning            Note
Team                It will be necessary for the student to access Huffman Trucking from the Virtual
Assignment          Organizations Portal of the course rEsource page.

                    Project Description
                    The Learning Team will do the following service request:
                            Service Request: SR-ht-003
                            Organization Name: Huffman Trucking
                            Locations: All hub locations
                            Requester: IT Project Manager
                            Description of Request: Develop Entity-Relationship Diagrams for Fleet
                            Truck Maintenance.
                            Background of Request: Smith Consulting developed entities and
                            attributes for Fleet Truck Maintenance but did not develop the database. In
                            an effort to better document our applications, Entity-Relationship Diagrams
                            are also needed.
                            Expected Results/Impact when completed: Creation of Entity-
                            Relationship Diagrams Fleet Truck Maintenance.

                    Objective
                    Apply Entity-Relationship Diagrams.

                    Standards
                    Refer to “Standards for Written Work” and “Standards for Presentations” in your
                    Program Handbook, which can be accessed through the University of Phoenix
                    eCampus Website.

                    Project Deliverables
                    Week 1 (Due Workshop 2)
                            Log and Charter: Create a Learning Team Charter, Weekly Log, Role
                            Assignments, and Workflow Chart.
                            Assignment #1:
                            o Review service request, needed data and Entity-Relationship
                                Diagrams.
                            o Document any issues with the data and ERDs.

                    Week 2 (Due Workshop 3)
                           Log: Create Weekly Log and Update Workflow Chart.
                           Assignment #2:
                           o Begin ERD draft on paper.
                           o Review how to create tables and relationships in Microsoft Access.

                    Week 3 (Due Workshop 4)
                           Log: Create Weekly Log and Update Workflow Chart.
                           Assignment #3:
                           o Create ERD in Microsoft Access.




University of Phoenix                                                          Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                          13



                    Week 4 (Due Workshop 5)
                           Log: Create Weekly Log and Update Workflow Chart.
                           Assignment #4:
                           o Complete the ERD for the service request.
                           o Compile a list of findings and recommendations.
                           Learning Team Written Assignment: Combine all items from
                           Assignments #1-#4 into one written assignment. The written assignment
                           should discuss all of your findings and recommendations, and it should
                           also include the process in which the learning team approached the
                           service request.
                           Final Project Presentation: Prepare a Microsoft PowerPoint presentation
                           that summarizes Assignments #1-#4. The presentation should be a total
                           of 20-25 minutes long or 5 minutes per team member.

                    Week 5 (Due Workshop 5)
                           Peer Review: Review each member of your team and submit the
                           Learning Team Evaluation Form.
                           Presentation Review: The Learning Team will be graded on the scope
                           and depth of research, the quality of analysis, and recommendations. One
                           member of each team will be selected to sit on an evaluation committee
                           during each presentation. The members of the evaluation team will be
                           required to ask two questions based on the position they are filling. At
                           the end of the presentation they will rate the presentation, and submit a
                           Presentation Evaluation Form.




University of Phoenix                                                       Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                       14


                                      COURSE CALENDAR

  Sunday          Monday      Tuesday        Wednesday   Thursday        Friday         Saturday
   02/25/07        02/26/07    02/27/07       02/28/07    03/01/07      03/02/07          03/03/07
                                                                                       On Campus
  03/04/07         03/05/07     03/06/07      03/07/07    03/08/07      03/09/07          03/10/07
 Wk 2 Online                  Wk2_DQ1 –                  Wk2_DQ2 –                       Individual
                              post to main               post to main                  assignment
                               newsgroup                 newsgroup                    (Wk2) - post to
                                                                                       assignments
                                                                                        newsgroup

                                                                                      LT log – post to
                                                                                       assignments
                                                                                        newsgroup
  03/11/07         03/12/07     03/13/07      03/14/07    03/15/07      03/16/07          03/17/07
 Wk 3 Online                  Wk3_DQ1 –                  Wk3_DQ2 –                       Individual
                              post to main               post to main                   assignment
                               newsgroup                 newsgroup                    (Wk3) - post to
                                                                                        news group

                                                                                      LT log – post to
                                                                                       assignments
                                                                                        newsgroup
  03/18/07         03/19/07     03/20/07      03/21/07    03/22/07      03/23/07          03/24/07
 Wk 4 Online                  Wk4_DQ1 –                  Wk4_DQ2 –                       Individual
                              post to main               post to main                   assignment
                               newsgroup                 newsgroup                    (Wk4) - post to
                                                                                       assignments
                                                                                        newsgroup

                                                                                            LT
                                                                                      Assignments –
                                                                                          post to
                                                                                       assignments
                                                                                        newsgroup
   03/25/07        03/26/07    03/27/07       03/28/07    03/29/07      03/30/07         03/31/07
                                                                                       On Campus




University of Phoenix                                                   Instructor: Al R. Pangelinan
DBM/380 – Database Concepts                                                                       15


                              ASSIGNMENT SCHEDULE SUMMARY

  WEEK/TOPIC            INDIVIDUAL ASSIGNMENT   PTS    LEARNING TEAM ASSIGNMENT             PTS
  Workshop 1:                 Participation      5                  (None)                    0


  Workshop 2:                 Participation      3                  Charter                   1

                             Assignment #1      12                Weekly Log                  1

                                                               Role Assignment                2

                                                            Weekly Workflow Chart             1
  Workshop 3:                 Participation      3                Weekly Log                  1

                             Assignment #2      12          Weekly Workflow Chart             1
  Workshop 4:                 Participation      3                Weekly Log                  1

                             Assignment #3      12          Weekly Workflow Chart             1
  Workshop 5:                 Participation      5                Weekly Log                  1

                             Assignment #4      15          Weekly Workflow Chart             1

                                                              Written Assignment             10

                                                                 Presentation                 9

                                                             Presentation Review              1

                                                                 Peer Review                  0

                                                        (20% deduction against Learning
                                                      Team grade if Peer Review average <
                                                                      3.0)

       TOTAL                                    70                                           30




University of Phoenix                                                   Instructor: Al R. Pangelinan
 DBM/380 – Database Concepts                                                                                            16


                                            PAPER EVALUATION FORM
COURSE:                   DBM/380 – Database Concepts                                        INSTRUCTOR:      Al Pangelinan
ASSIGNMENT:                                                                                  DATE:
STUDENT NAME(S):


                                                                                              Maximum %           Your %
ELEMENT
                                                                                              Point Value       Point Value

Content/Development – 40%
Subject Matter:
         Key elements of assignment covered
         Content is comprehensive/accurate/persuasive
         Displays an understanding of relevant theory
         Major points supported by specific details/examples
         Research is adequate/timely                                                                 40%
         Writer has gone beyond textbook for resources as appropriate

Higher-Order Thinking:
         Writer compares/contrasts/integrates theory/subject matter with work
         environment/experience
         At an appropriate level, the writer analyzes and synthesizes theory/practice to
         develop new ideas and ways of conceptualizing and performing
Organization – 30%
          Introduction provides a sufficient background on the topic/previews major points
          Central theme/purpose is immediately clear                                                 30%
          Structure is clear, logical, and easy to follow
          Subsequent sections develop/support the central theme
          Conclusion/recommendations follow logically from the body of the paper
Style/Mechanics

APA Formatting – 10%                                                                                 30%
          Citations/reference page follow guidelines
          Properly cites ideas/info from other sources
          Paper is laid out effectively – uses headings and other reader-friendly tools
          Paper is neat/shows attention to detail
          Paper includes copy of “Paper Evaluation Form” to facilitate feedback

Grammar/Punctuation/Spelling – 10%


Readability/Style – 10%
          Sentences are complete, clear, and concise
          Sentences are well-constructed with consistently strong, varied structure
          Transitions between sentences/paragraphs/sections maintain flow of thought
          Words used are precise and unambiguous
          The tone is appropriate to the audience, content, and assignment
TOTAL                                                                                            100%


COMMENTS:




 University of Phoenix                                                                         Instructor: Al R. Pangelinan
 DBM/380 – Database Concepts                                                                                                  17




                                    PRESENTATION EVALUATION FORM

COURSE:                  DBM/380 – Database Concepts                                               INSTRUCTOR:      Al Pangelinan
ASSIGNMENT:                                                                                        DATE:
STUDENT NAME(S):


                                                                                                    Maximum %           Your %
ELEMENT
                                                                                                    Point Value       Point Value

Content/Development – 30%
         Topic is relevant and addresses assignment specifications
                                                                                                           30%
         Content presented is comprehensive, accurate, and believable
         Key points are noted
         Topic is researched adequately
Organization/Structure – 25%
         Presentation is well-organized, clear, and effectively structured
         If this is a group presentation, it is integrated rather than being a disjointed series           25%
         of individual presentations
         There is an introduction to gain the audience’s attention and explain the purpose
         of the presentation
Style/Presentation/Appearance – 25%
         Non-verbal cues/gestures are appropriate to presentation and flow of ideas                        25%
         Content knowledge/confidence are evident
         Time was used well/not rushed
Use of Visual Aids – 10%
         Visual aids are used where appropriate
                                                                                                           10%
         Visual aids are appropriately professional given the presentation’s context
         They are easy to see/read
         Visual aids contribute to the overall effectiveness of the presentation
Adherence to Time Limit – 10%
                                                                                                           10%
         The presenter(s) stayed within the allotted time limit (Failure to do so may result
         in a deduction of points)
TOTAL                                                                                                  100%


COMMENTS:




 University of Phoenix                                                                               Instructor: Al R. Pangelinan