LIS-S 511 Database Design
Prerequisites: LIS S500 and LIS S503
Concerned with a comprehensive view of the processes involved in developing formal access to information from a user-centered point of view. Considers various database models such as flat file, hierarchical, relational, and hypertext in terms of text, sound, numeric, image, and geographic data. Students will design and implement databases using several commercial database management systems.
This course is tailored to the needs of students in the Master of Library and Information Science. It is recommended that MLIS students take the online version in the spring semester.
Students who have completed an upper-level undergraduate or graduate database course within the past two years with a grade of B– or higher should instead take CSCI 54100 Database Systems.
- Design and implement relational databases using tables, keys, relationships, and SQL commands to meet user and operational needs.
- Diagram a relational database design with entity–relationship diagrams (ERDs) using crow’s foot notation to enforce referential integrity.
- Evaluate tables for compliance to third normal form and perform normalization procedures on noncompliant tables.
- Write triggers to handle events and enforce business rules and create views within a relational database.
- Demonstrate an understanding of the data lifecycle, including data curation, stewardship, preservation, and security.
- Evaluate the social and ethical implications of data management.