ITD - Information Technology Database and Design
DATA MODELING AND DESIGN
Prerequisite: ITE 115. 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.