Aug 09, 2020  
Fall 2017 Catalog 
Fall 2017 Catalog [ARCHIVED CATALOG]

DA 160 - Oracle Database Programming I

Credit Hours: 3

The study of database design and conceptual modeling 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, 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)