IFSM 410 Tu/Th 16:40-19:20 Yokota Term V (02-2003)

Instructor: Robert Shields (rcshields@ad.umuc.edu) Office Hours: Before classes and by appointment.

Web Site: http://www.oocities.org/rcshields2/

Prerequisite(s): Programming experience and IFSM 300. In addition, UMUC requires the following: ENGL101 be completed within your first 12 s.h. (~4 classes) and MATH105 or MATH107 be completed within your first 15 s.h. (~5 classes)

Course Materials: Text: Database Systems, Design, Implementation and Management, 5th Edition, By Peter Rob and Carlos Coronel. Published By: Course Technology ISBN 0-619-06269-X.

Description: (Formerly Database Program Development.) An introduction to the design and management of database systems in a business environment. Topics include the role of databases in organizations; the management of information as a critical business resource; types and functions of database management systems; conceptual data modeling and entity/relationship and semantic data models; and the fundamental principles of relational and object-oriented database design. The implementation and maintenance of database management systems and the role of the database administrator are discussed. Students may receive credit for only one of the following courses: CMIS 320 or IFSM 410.

	Tentative Course Schedule (This schedule is subject to change)
Week	Topic Read chapters before class	Chapt.	Homework #: Brief answers to review questions/problems are due on the days below
1	Intro. To Access File systems and Databases Relational DB Model, E-R Model	1 2 3	Thur: #1 Chap. 1: 2,4,8,9,10,11,14,15,17; Chap.2:1-10, 12 Sat. 22:00: #2 Problem Ch 2: 8-15
2	E-R Model (cont.) Normalization	3 4	Tue: #3 Ch 3: 2,3,4,7,8,9,12,14,15,17,19 Thur: #4 Ch 4: 1-9; Form Project teams Sat. 22:00: #5 Probs: Ch 3: 6,9,10; Ch 4: 5,6,7
3	SQL	5	Tue: #6 Ch 5: 1-20 Sat. 22:00: #7Problems: 16-33
4	DB Design EXAM	6	Tue: #8 Ch 6; 1-11; Project Milestone 1 Thur: Exam
5	Conceptual Design Verification and Implementation	7 8	Tue: #9 Ch 7: 1-6 Thur: #10 Ch 8: 1-6; Project Milestone 2 Sat. 22:00: #11 Problems: Ch 7:4; Ch 8: 1
6	Implementation (cont.) & OODB OODB	8, 11 11	Tue: #12 Problems: Ch 8: 1 Thur: #13 Ch 11: 2-6, 8-10,12,14-18 Sat. 22:00: Project Milestone 3
7	Data Warehouse Electronic Commerce	13 14	Tue: #14 Ch 13: 1-12, 14-22 Thur: #15 Ch 14: 1-12 Sat. 22:00: Project Milestone 4
8	DB Administration	16	Tue: #16 Ch 16: 3,4,6,7,9,24 Thur: Exam:

Additional Resources: You may want a beginning through intermediate book on ACCESS 2000. Former students recommended MS ACCESS 2000 Bible, by Prague and Irwin. In addition to having great step-by-step examples, the CD has a trial version of Visio. You can also find lots of free tutorials on the Internet. Note this is NOT a course on MS ACCESS.

Course Overview: Professionals in the information systems management field like to say, "Data are just data until they are organized in a meaningful way." It is only at this point that the data become information. How does this happen? By using relational database management systems (RDMS’s), which sort through and manipulate data to reveal as-yet undiscovered knowledge. For instance, buried in a mass of data on last year's sales we can find buying trends if we know how look for them.

There are three basic operations in the life cycle of data: (1) acquisition, (2) storage, and (3) manipulation. Once you have acquired, or captured, data, you can make computations, move the data from one place to another, and modify them. Manipulating the data is called processing, and fundamentally involves the same three basic operations.

Relational database management systems support this "acquire-store-manipulate" approach and provide clever tools that allow you considerable sophistication in capturing, editing, modifying, storing, and securing data, and retrieving them to manipulate and create ad hoc and scheduled reports. An RDMS turns data into information, and information is an economic asset in today's Information Age. This course will give you the tools to design, create, load, modify, and query relational databases with an RDMS.

Objectives: After completing this course, the student should be able to:

1. Identify and discuss the basic concepts of relational database theory and the life cycle of a database (competence in information technology) (Chapter 1,2)

2. Create, update, and manipulate data and control access to a database using structured query language (competence in information technology) (5)

3. Develop an entity-level working model of a relational database founded on multiple-user views and requirements using database design language and data-structure diagrams (competence in information technology) (3,6,7,8)

4. Demonstrate the use of database design language and data-structure diagrams as tools for the design of table structures, attributes, and data validity (competence in information technology) (4)

5. Identify and analyze current database trends, such as data mining and object-oriented databases, and their potential impact on future database applications (competence in information technology, information literacy, effective writing)(11,13)

6. Compare and contrast these database trends with those found in a variety of global locations and situations (competence in information technology, global perspective, information literacy, effective writing)(14)

7. Discuss an architectural view of a database management system, including the roles and tools of a database administrator (competence in information technology)(16)

Grades: Exams: (64%), Assignments: (16%), Project (20%)

I will assign grades with this scale: A = 90-100%; B = 80-89%; C = 70-79%; D = 60-69%; F = 0-59%

ATTENDANCE: I expect you to attend every class on time. It remains your responsibility to obtain information concerning the material covered and upcoming assignments. Excessive absences may result in the assignment of the grade F--failure for nonattendance.

EXAMS: Each examination or test may be a combination of short answer, fill-in the blank, multiple choice, essay questions, and problems. Be able to discuss and apply assigned reading materials, and complete assignments and projects to best prepare for the examinations.

MAKEUP EXAMS: If you miss a test or examination you must submit official documentation stating the reason for the absence before a make-up examination will be given. Only illness, TDY, extra duty, or emergencies are valid reasons for missing a scheduled examination. If you need to take a test or exam either earlier or later than its scheduled date (due to some work related activity), you must contact me immediately to arrange this

Project: You will design and implement a database based on problems 15-17 in Chapter 4. You will be working in teams of 3 (one team of 2 or 4 may be formed if needed). You will complete the project in steps. Progress toward the final version will be graded. Your team will deliver the following written milestones to document your progress:
MS# Milestone	Due Date	Points
1. Business Rules and ERD	See schedule	5
2. Normalization & Data Dictionary	See schedule	5
3. Populate Tables, Develop Queries and Report	See schedule	5
4. Final Project report with examples queries and reports	See schedule	5

Participation in class: To be properly prepared, read each of the assigned chapters before the class begins. For homework or in class, you may be asked to complete exercise sheets, to look up things on the Internet, to create some mini-algorithms, queries or databases. These exercises are meant to help you learn what you need in this course and will help you to become more accomplished in programming. Exercises may take from 15 minutes to two hours.

UMUC Databases The University subscribes to several on-line library databases that students, faculty, and staff may access via the WWW. The address to the UMUC libraries is: http://www.umuc.edu/library/ols.html. Log in with your Social Security number. Some databases contain full text articles. Those articles that are not full text may be ordered on-line. As a student of UMUC Asian Division you may order up to ten free articles per term. Please refer any questions about the Web Databases/MdUSA FAQ or a UMUC reference librarian at umuc-reference@info.umuc.edu.

Academic Policies: These polices discuss your rights and responsibilities regarding such issues as Attendance, Religious Observances, Examinations, Writing and Mathematics, Plagiarism, and Disabled Students.See http://www.ad.umuc.edu/gen/disc/acadpoli.html to see the policies.

Students who violate UMUC's policy on Academic Dishonesty and Plagiarism will receive a zero on the assignment in question; further violations of the policy will result in referral to the Dean's office for further administrative action. The grade of I (Incomplete) is only given in extraordinary circumstances. Students requesting an I must have completed at least 60 percent of the course work and hold a C average.