Course Number: INF 6460

Credits: 3

Prerequisite(s): None.

Rationale for Inclusion in Curriculum:

A database is an organized collection of related data. In modern society, electronic databases are used to support a wide-range of information management operations as well as services for diverse groups of users.  Knowledge in database design and applications such as querying becomes essential for the success of information professionals in present society.

This course provides instruction on the fundamentals of database design, database implementation and querying. Related and current database management technologies will be used for students to have hands-on experiences.

Learning Outcomes:

By the end of the course, students will be able to:

1. Articulate database functions and data modeling;
2. Master database conceptual design using Entity-Relationship modeling;
3. Create conceptual design diagrams using graphic software packages;
4. Apply flexible solutions for data-modeling cases;
5. Apply normalization rules to evaluate and correct table structures;
6. Design databases that are diverse, inclusive and accessible, accommodating a range of data types and structures;
7. Implement the design using a relational database management system;
8. Use Structured Query Language to retrieve and manage information;
9. Identify basic concerns regarding database control and security.
10. Understand the trends of database-related technologies and the application of database technologies to various management activities in libraries and other information organizations.
11. Analyze complex information management problems that require database solutions.
12. Understand social justice issues relating to database design and querying.