|
Dec 11, 2024
|
|
|
|
EMGT 6210 - Database Information Systems Introduction to application and development of database systems in industrial engineering. In addition, students will learn database theory, data modeling and SQL.
Requisites: EMGT 6200 Credit Hours: 3 Repeat/Retake Information: May not be retaken. Lecture/Lab Hours: 3.0 lecture Grades: Eligible Grades: A-F,WP,WF,WN,FN,AU,I Learning Outcomes: - Build a database/web server using a common development environment.
- Design a set of relations for storing data.
- Determine the locking requirements for concurrent access.
- Determine what check constraints may be required for a table.
- Develop a set of SQL DML statements to create a set of tables.
- Develop complex SQL queries to retrieve required data.
- Normalize a set of relations to 3rd normal form.
Add to Portfolio (opens a new window)
|
|