PREREQUISITES:
MAS students: Completion of the MAS Core courses, plus permission of the instructor.
MLIS and Dual students: Some electives can be taken in conjunction with the MLIS Core courses; consult with the MLIS Program Chair for recommendations.
GOAL: The goal of this course is to provide students with knowledge and skills necessary to produce a well-designed database that enables the timely delivery of accurate information in a useful form
OBJECTIVES:
Upon completion of this course students will be able to:
- Explain basic database concepts and terminology
- Identify information needs within an organization
- Formulate user and organizational requirements for a database
- Design a conceptual model that satisfies these needs and requirements using a relational data / entity relationship model
- Normalize this relational data / entity relationship model
- Implement the corresponding logical model in a relational database management software (e.g. MS ACCESS, MS SQL Server, etc.)
- Design SQL queries for a relational database to satisfy users’ information needs
CONTENT:
- Overview of databases and database design
- Components of a database
- Conceptual design and Entity Relationship Diagram (ERD)
- The relational model
- Normalization
- Logical design
- Querying a database using SQL
- Issues and Trends in DBMS
- Creating a database
On this page