3 credits
Fall 2025 Lecture Upper Division
Covers the theory and practice of database design and usage. Students will learn the importance of data modeling concepts and how to use these effectively and how to plan and design a database, including issues such as data security and control.
Learning Outcomes1Understand why database management is important and what it entails.
2Analyze the database requirements of a business scenario and represent these requirements by means of entity-relationship (ER) diagrams.
3Translate an ER diagram into normalized relations for a relational DBMS.
4Design and implement an Oracle database.
5Write simple and relatively complex data retrieval and maintenance commands in the SQL language.
6Use Microsoft Access as a front end to a server database in Oracle.
7Appreciate major data administration tasks, including security control, backup and recovery, and concurrency control.
8Be familiar with data warehousing and its basic conceptual design.
Prerequisites
Restrictions
made by Purdue students.