(WINTER 2010)

In this course you will learn how to develop data models which are used to publish the information that organizations rely on for their day-to-day decision making processes. Basic data modeling techniques will be explored including capturing data requirements, analyzing data elements, identifying entities and attributes, and determining relationships between entities. Data models will be developed using the entity/relationship graphical model. Once a basic data model has been developed, students will be instructed on how to enhance the data model to manage and enhance the value of the data it contains. This will directly affect the quality of the information produced from the data, and provide an organization with the knowledge necessary to optimally perform its business functions. The emphasis of this course is on analysis and design rather than on the actual implementation of a database. Prerequisites: Experience using a relational database (as a minimum, Microsoft Access or similar product) is highly desirable.

Derrick Lam, M.B.A, has taught database courses in Oracle, Sybase, and Microsoft SQL Server at UCI Extension for over 14 years. He has worked with Oracle since 1988 and Sybase and Microsoft SQL Server since 1994. He is a database administrator and application developer for Oracle, Sybase, and Microsoft SQL Server. He currently oversees the UCI Alumni and Donor Database and the UCI Foundation Accounting System, and recently used SQL Server 2005 Integration Services to migrate the UCI Alumni and Donor Database from Sybase to Oracle. He has spoken at conferences on topics related to Data Management, Data Metrics, and Improving the Value of Data. His current assignments include enhancing the design of the UCI Alumni and Donor Database to increase the fundraising value of the data stored in it.