Data Modeling and Design

Catalog description

Introduces life cycle application development methodologies in a systematic approach to developing relational databases and designing applications. Presents content introducing functional and business process modeling, using modeling information to produce application designs, analyzing data requirements as entities, attributes, and relationships and map an entity relationship diagram to an initial database design. Identifies the available automated development tools and utilizes Oracle Developer software to perform practical applications of these concepts. Prerequisite: Oracle or SQL programming including DDL, DML, transaction control & queries with SELECT statement and some exposure to procedural language programming. Lecture 3 hours per week.