Faculty Contact Information:
|
Telephone +44-1423-844364 (from outside the U.K) or (01423) 844364 (within the UK). I can also be contacted using the e-mail address at the top of this syllabus.
|
|
Consultation:
I am always available for private consultation via e-mail. Telephone consultations will be by appointment only. Please schedule telephone appointments ahead of time via e-mail.
|
|
Required Texts and Readings:
|
Rob, P., and Coronel, C. (2004). Database Systems: Design, Implementation, and Management (6th ed.). Boston, MA: Course Technology.
|
|
Supplementary Readings:
|
The standard for papers in the graduate program is the APA style. All participants in this course and all graduate INSS, MGMT, PUAD, and ECON courses should have a copy of the style guide:
American Psychological Association. (2001). Publication Manual of the American Psychological Association, 5th Edition. Washington DC: Author. All graduate students should be prepared to utilize the UMUC online library at http://www.umuc.edu/library/. The library contains a large number of full text academic journals that are free of charge and immediately available. The library homepage also contains a number of links related to improving students' research and writing skills.
|
|
Recommended Journals:
|
Publications of the various professional societies (such as ACM -- the Association for Computing Machinery, the IEEE Computing Society, and the various management professional societies) are strongly recommended. In addition, there are many trade journals (such as eWEEK) that MIS professionals should become familiar with, many of these being published both weekly and on-line.
|
|
Course Description:
|
3 semester hours credit. Prerequisite: Either INSS 510, INSS 520, INSS 530, or permission of the Program Director. Examines database concepts and practices as they relate to business environments. Various database structures including relational and object-oriented are discussed. Concepts of distributed database architecture are explored. Design, development, and implementation of databases are examined. Organizational issues concerning the implementation of databases and the role of data in the decision-making process are examined. Decision support system architecture is reviewed with emphasis on the database component. Issues of intelligent databases are discussed. A database project is required.
|
|
Course Goals:
Upon completion of the course, participants should:
1. Understand and apply database concepts and practices
2. Understand relational and object-oriented database models, and how they compare to "traditional" models such as hierarchical and network.
3. Design and implement a relational database.
4. Understand and discuss issues associated with Internet database development.
|
|
Course Objectives:
At the conclusion of this course the student will be able to:
1. Describe, compare, and use tools of database design development and implementation, such as: Entity Relationship Diagrams (ERD), Relational schema, Table normalization, Structured Query Language (SQL), and ANSI/SPARC 3-level architecture - subschemas.
2. Discuss the advantages and issues of distributed database architecture and two- and three- tier database architectures,
3. Concurrency control and transaction management, .
4. Compare and contrast approaches to Security of databases
5. Define organizational issues and the responsibilities associated with database administration.
6. Discuss the role of data and information in decision making, and techniques such as data mining and data warehousing as used for decision support.
|
|
Grading Information:
Grades for this course will be assigned as follows:
A 90% +
B 80 – 89%
C 70 – 79%
F Below 70%
Please note that Bowie State University does not use "D" for graduate students. The grade F(a) is used to designate academic failure. F(n) is used to designate failure for non-completion. Grades of Incomplete or Withdrawal are governed by UMUC-Europe policies. For further details, please refer to the UMUC-Europe Graduate Catalog, available in your local Education Center or online at http://www.ed.umuc.edu/general_info/publications/catalogs.
|
|
Course Requirements:
Graduate school at the masters level focuses on helping students obtain the education needed for success as professionals in their chosen fields. Thus, UMUC-Europe Graduate Programs and Bowie State University share the common goals of promoting excellence in academic scholarship through thoughtful inquiry and the skillful application of knowledge and theory for the betterment of society.
In order to maximize your graduate educational experience in general and this course in particular, you are required to:
10% - Participate in online conferences and discussions
40% - Complete a major individual written project
25% - Complete an online open book/notes midterm examination
25% - Complete an online open book/notes final examination
Important note: Resubmission of course work from previous classes
(whether or not taken at UMUC, UMUC-Europe or BSU), partially or in its entirety, is not acceptable in this course and will result in an
automatic failure on the assignment.
|
|
Description of Course Requirements:
Participate in classroom discussions: You are expected to engage in the online conferences. Usually this requires the student to log into the classroom five to six times per week for about a half an hour per session. Each week's conferences will have numerous informational topics as well as one or two mini assignments. In the mini assignments, students will be asked questions on various real-world, textbook, and case-study topics, which they are required to answer to receive participation points.
Additionally, each student will be required to prepare a database project. This will require the student to analyze a problem (presented by the instructor), design a database system/application to solve the problem, and then actually develop the database application solution with a real database management system (DBMS)(such as MS Access, MySQL, etc.,). This will require the student to have access to a DBMS in order to develop the application. Students will also be required to prepare a small user's guide (5-10 pages)and software maintenance manual (3-4 pages) (with database design documents created during the design phase). Students will submit their database application, user's guide, and software maintenance manual to the instructor at the end of the course.
Additionally, students will have milestone dates throughout the course where part of their course long database project (CLDP) will be turned in. For example, students will need to turn in their database entities, relationships, and table definitions after week 5. This allows the instructor to ensure students fully understand the assignment and are progressing without problem. It also helps the student to set a timeline for completion of each major milestone of the project.
|
|
Course Schedule:
This schedule presents 16 units or modules, with each unit corresponding to a regular three-hour weekday meeting, a half-day on weekends, or a full week of DE.
Week 1 (13 - 19 June 05)
Introductions
Review of syllabus
Clarification of goals, objectives and requirements
Orientation to subject - Database Systems
Database Projects Assigned
Students should have read chapter 1 of the text prior to class
Week 2 (20 - 26 June 05)
Week 2 conferences - Data Models
Students have read chapter 2 of the text prior to class
Week 3 (27 June - 2 July 05)
Week 3 conferences - The Relational Database Model
-- Students have read chapter 3 of the text prior to class
-- Students notify instructor of the DBMS they will use for the CLDP
Week 4 (3 - 9 July 05)
Week 4 conferences - Entity Relationship (ER) Modeling
Students should have read chapter 4 of the text prior to class.
-- Students turn in CLDP ER diagrams, business rules, and table designs by COB 9 July 05.
Week 5 (10 - 16 July 05)
Week 5 conferences - Database Normalization
-- Students should have read chapter 5 of the text prior to class.
-- Students turn in CLDP ER diagrams, business rules, and fully normalized table designs by COB 16 July 05.
Week 6 (17 - 22 July 05)
Week 6 conferences - Structured Query Language (SQL) and Advanced SQL
Students should have read chapters 6 and 7 of the text prior to class.
Week 7 (23 - 29 July 05)
Online open book/notes midterm examination (Ch 1 - 7)
-- -- Students turn in list of queries to be used in CLDP and associated SQL code by COB 29 July 05.
-- Students continue working on project
Weeks 8 - 10 (1 - 21 Aug 05)
-- Summer Break
-- Students continue working on project
Week 11 (22 - 28 Aug 05)
Week 11 conferences - Database Design Life Cycle
-- Students should have read chapter 8 of the text prior to class.
-- Students turn design of CLDP reports and Input Forms/Menus
Week 12 (29 Aug - 3 Sep 05)
Week 12 conferences - Transaction Mgt and Concurrency Control
Students should have read chapter 9 of the text prior to class.
Week 13 (4 - 11 Sep 05)
Week 13 conferences - Distributed Database Management Systems
-- Students should have read chapter 10 of the text prior to class
-- Draft User's Guide and SWMM due for review by COB 11 Sep 05
Week 14 (12 - 18 Sep 05)
Week 14 conferences - Object-Oriented Databases
-- Students should have read chapter 11 of the text prior to class
-- Students present ideas on how to automatically update inventory upon sales and dispatch note goods inward (DNGI), as well as how to automatically generate product orders.
Week 15 (19 - 25 Sep 05)
Week 15 conferences - Data Warehousing and Database Administration
Students should have read chapters 12 and 15 of the text prior to class
Week 16 (26 Sep - 1 Oct 05)
Week 16 conferences - Databases and E-Commerce; Web Databases
-- Students have read chapters 13 & 14 of the text
-- Final CLDP Projects due by COB 1 October 05!!!
Week 17 (2 - 9 Oct 05)
Online open book/notes final examination (Chapters 1 - 15)
|
|
Academic Policies:
|
The University has a license agreement with Turnitin.com, a service that helps prevent plagiarism from internet resources. I may be using this service in this class by either requiring students to submit their papers electronically to Turnitin.com or by submitting questionable text on behalf of a student. If you or I submit part or all of your paper, it will be stored by Turnitin.com in their database throughout the term of the University's contract with Turnitin.com. If you object to this temporary storage of your paper, you must let me know no later than two weeks after the start of this class. Please Note: If you object to the storage of your paper on Turnitin.com, I may utilize other services to check your work for plagiarism The official university policy on Plagiarism and Academic Dishonesty can be found at http://www.umuc.edu/policy/aa15025.shtml. Section I.C. states: "Faculty may determine if the resubmission of course work from previous classes (whether or not taken at UMUC), partially or in its entirety, is acceptable when assigning a grade on that piece of course work. Faculty must provide this information in their written syllabi. If the resubmission of course work is deemed to be unacceptable, a charge may not be brought under this Policy and will be handled as indicated in the written syllabi."
Please refer to Description of Course Requirements for specific information on how resubmissions will be treated in this course and to the UMUC-Europe Graduate Catalog for information on the following:
Academic Integrity
Course Load
Exception to Policy
Grade Appeal Process
Make-up Examinations
Nondiscrimination
Students with Disabilities
Code of Civility
Hard copies of the catalog are available at your local Education Center.
|
|
Faculty Bio:
James Helton is a Senior software developer and analyst working for Lockheed Martion Corporation. He has been the software project lead for several medium to large size information systems projects. He has also worked in software development with databases as well as a database manager.
He has taught undergraduate computer science and information systems management courses for the University of Maryland since 2001, and graduate courses for Bowie State University since 2002. He has an undergraduate degree in Information Systems and a Master's degree in M.I.S.
|
|