LIS-S 511 Database Design
3 credits
- Prerequisites: LIS-S 500, LIS-S 507
- Delivery: On-Campus, Online
-
Semesters offered:
Fall, Spring
The above are the semesters this course is generally offered. View the course schedule to confirm.
Description
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.
Learning Outcomes
- 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.
- Formulate queries in relational algebra using selection, projection, restriction, Cartesian product, join, and set operators.
- Demonstrate an understanding of the data lifecycle, including data curation, stewardship, preservation, and security.
- Evaluate the social and ethical implications of data management.