The aim of the course |
Upon completion of this course, participants will have gained knowledge of SQL concepts, database system concepts and the ability to: • understand user requirements/views • analyze existing and future data processing needs • develop an enterprise data model that reflects the organization's fundamental business rules • develop and refine the conceptual data model, including all entities, relationships, attributes, and business rules • integrate and merge database views into conceptual model • apply normalization techniques • identify data integrity and security requirements • derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements • utilize prototyping as a rapid application development (RAD) method to implement a PC database (e.g., Microsoft Access® for the PC) |