dbm380 | undergraduate
topic title goes here
Introduction to the Relational Database Model and Other Database Models
- Explain the purpose and utility of a database.
- Identify the database model most commonly used in business today.
- Distinguish between several commercial relational database management systems.
Relational Database Design: Entity-Relationship Diagrams and Normalization
- Explain the purpose of an entity-relationship diagram.
- Create an entity-relationship diagram for a given business scenario.
- Explain the purpose of normalization with respect to a relational data model.
- Given an entity-relationship diagram depicting a non-normalized relational data model, normalize the data model.
Relational Database Implementation: Creating and Populating Relational Tables
- Create a multi-table relational database in a relational database management system (RDBMS) such as MicrosoftÂ® AccessÂ® using Structured Query Language (SQL) statements.
- Create relational tables within a relational database that correspond to a normalized entity-relationship diagram.
- Populate relational tables with data using SQL statements.
Relational Database Use: Querying and Updating Relational Tables
- Select data from related tables using SQL statements.
- Update data in related tables using SQL statements.
Relational Database Administration: Backing Up and Securing Relational Data
- Summarize the importance of backing up relational data.
- Evaluate at least three approaches to securing relational data.
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.