Study of advanced database technology, database security, and database performance issues. Study of multi-user environment issues, concurrency control, distributed databases. The focus of MINS 318 will be on advanced database design topics. We will touch on some DBA topics, but only as they impact the advanced designer. We will also do design tuning and query optimization, and will explore other new areas in database technology as time and opportunity permits.
Registration is by approval of instructor only.
This course will provide an excellent opportunity for self-motivated, conscientious students to apply and extend the general database concepts. Oracle 8i will be the database used to illustrate the materials, and this will provide an opportunity for the student to further his or her knowledge of Oracle internals and functioning. You are expected to form your own groups. There will be two database design problems for business case scenarios involving a medical clinic and an airline. These cases will involve documenting your database schema with an E-R diagram and a table attribute design.