im300 | undergraduate
Data Organization Architecture
This undergraduate-level course is 5 To enroll, speak with an Enrollment Representative.
topic title goes here
Normalizing the Database
- Describe how real-world database design often requires the reconciliation of conflicting goals.
- Demonstrate normalization through the third normal form.
- Identify the advantages and disadvantages of normalization.
- Explain how Entity Relationship Diagram (ERD) and Unified Modeling Language (UML) components affect database design and implementation.
Integrity and Constraints
- Define referential and entity integrity.
- Perform data manipulation and data definition commands.
- Apply SQL aggregate functions.
Optimizing the Database
- Select indices to improve performance.
- Explain the query execution plan reported by a Database Management System (DBMS) engine.
- Describe query optimizer.
- Describe how data models have evolved.
- Distinguish between object-relational systems and standard-relational systems.
- Distinguish between structured and unstructured data.
- Identify primary and foreign keys.
- Document business rules.
- Describe naming conventions.
- Describe data dictionaries and the system catalog.
- Explain why indexing is important.
Please ask about these special rates:
Teacher Rate: For some courses, special tuition rates are available for current, certified P-12 teachers and administrators. Please speak with an Enrollment Representative today for more details.
Military Rate: For some courses, special tuition rates are available for active duty military members and their spouses. Please speak with an Enrollment Representative today for more details.
The University of Phoenix reserves the right to modify courses.
While widely available, not all programs are available in all locations or in both online and on-campus formats. Please check with a University Enrollment Representative.
Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice.