Information & Library Science Department ILS 532 outline

ILS 532

USER CENTERED DATABASE DESIGN AND DEVELOPMENT

COURSE DESCRIPTION

An introduction to the theories and principles of database design. Theories and principles will be used to design database systems based on practical library information problems. Students will be taught to use Microsoft Access as a database development system. Prerequisites: ILS 501 or departmental permission. Scheduled spring semesters. 3 credits. [Offered on campus]

 

COURSE OBJECTIVES/STUDENT LEARNING OUTCOMES

Upon completion of this course, students will be able to:

• Describe the typical functions and components of a database system
• Describe the main stages of the database application lifecycle
• Explain the relational database model
• Explain the Entity-Relationship model
• Demonstrate knowledge of user-centric methodologies
• Apply relational modeling in database design
• Demonstrate the knowledge of the Structured Query Language
• Demonstrate the knowledge and skills of using MS Access as a DBMS
• Design a relational database, basic applications, and user interfaces
• Create a relational database system and conduct evaluation.

COURSE OUTLINE

   I.       Unit 1: Orientation to the Class, Introduction to Databases

   II.      Unit 2: Database Environment & The Relational Model 

   III.     Unit 3: Database Planning, Design, and Administration

   IV.      Unit 4: Fact-Finding Techniques

   V.       Unit 5: Entity-Relationship Modeling

   VI.     Unit 6: Enhanced Entity-Relationship Modeling

   VII.    Unit 7: Conceptual Database Design

   VIII.   Unit 8: Midterm Exam 

   IX.     Unit 9: Normalization

   X.      Unit 10: Logical Database Design

   XI.     Unit 11: Physical Database Design

   XII.    Unit 12: Monitoring and Tuning the Operational System

   XIII.   Unit 13: Structured Query Language & Query-By-Example

   XIV.    Unit 14: Final Exam   

 

COURSE REQUIREMENTS

1.     Database Design Team Project: 400 pts. -- 40%
╖     Conceptual Data Model: 100 pts. -- 10%
╖     Logical Data Model: 150 pts. -- 15%
╖     Completed Database System: 150 pts. -- 15%
2.      Exams: 300 pts. -- 30%
╖     Midterm Exam: 150 pts. -- 15%
╖     Final Exam: 150 pts. -- 15%
3. Microsoft Access Individual Exercise: 200 pts. -- 20%
4. Class Attendance, Participation, and Contribution: 100 pts. -- 10%

 

SUGGESTED TEXTS / TEXTS USED IN THE PAST

Thomas M. Connoll and Carolyn E. Begg (2005), Database Systems: A Practical Approach toDesign, Implementation and Management (4th Edition). New York: Addison Wesley. ISBN-10: 0321210255  

 

Approved by the ILS Department Curriculum Committee and Faculty, Spring 2009.