DA 160 - Oracle Database Programming I

Credit Hours: 3

The study of database design and conceptual modeling is accomplished by analyzing various business scenarios and creating a data model, a conceptual representation of an organization’s information. By analyzing the detailed data requirements of each operating unit and creating conceptual models, students learn how large, complex, and dynamic organizations operate. Assignments and projects will be completed using the Oracle Corporation’s database software system.

Course Outcomes
Upon completion of this course, the student will be able to:

analyze business scenarios and create a conceptual representation of an organization’s information;
design and create a data model as a foundation of database design;
categorize components of a database model including entities, attributes, and relationships;
create entity relationship diagrams (ERD) based on a simple business scenario;
identify, define, and document a company’s business rules;
use the process of normalization to maximize a database’s efficiency and design; and
use basic SQL syntax as it relates to the SELECT statement.

F/S (S)