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.

Prerequisites: ITE 115

If you feel you lack this prerequisite, please contact Professor Drake immediately.

If you do well in this course, you will be able to:

• Determine Key Business Data Elements.
• Identify Entities.
• Identify Relationships.
• Understand Ordinality.
• Understand Cardinality.
• Model Supertypes, subtypes, acrs and hierarchies.
• Understand Normalization.
• Create Normalized Entity Relationship Diagrams.
• Convert ERD's to Relational Databases.
• Create a Table.
• Query a Relational Database.
• Discuss relational DBMS fundamentals, capabilities, limitations, applications and problems.

Possible Assignments Include: (Subject to change each semester. The actual assignments are available in the Syllabus in the Blackboard course site on the first day of classes.)

Your final grade may be based on the following scale. Please note that you must also pass at least 1 of the 2 exams in order to pass the course, regardless of your scores on the other assignments.

There are 2 exams in this course.